ASHRAE Northeast Chapter
Toggle Navigation
  • Home
  • Society Membership
  • About Us
    • Current Officers
    • Committees
      • Research Promotion
    • Chapter History
    • Past Presidents
    • Chapter Constitution & By-laws
    • Contact Us
  • Events
    • Event Calendar
    • Event Photos
  • Scholarship
  • Members
    • Site Registration
    • Forgot Login
    • Member Spotlight
    • Chapter Dues
  • Newsletters
  • Links
    • ASHRAE Society
    • ASHRAE Region 1
    • ASHRAE Foundation
    • AHR Expo
    • ASPE - Capital Region New York
    • AEE - Capital Region
    • ASHRAE Jobs
    • Local Job Opportunities
  • Login

Archived - History Files

 Sub Categories

1950's (10 Documents)
1960's (10 Documents)
1970's (11 Documents)
1980's (10 Documents)
1990's (2 Documents)
2000's (0 Document)
2010's (0 Document)

 

This web site describes the activities of Northeast Chapter of the American Society of Heating, Refrigerating, and Air-Conditioning Engineers, Inc. (ASHRAE). It does not present official positions of the Society nor reflect Society policy. ASHRAE is not responsible for this site's content. To learn more about ASHRAE activities on an international level, contact the ASHRAE home page at http://www.ashrae.org/.

 

Back to Top

© 2021 ASHRAE Northeast Chapter

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611647872,
                "last": 1611647872,
                "now": 1611647872
            },
            "token": "xrjqUDy9zfBffJaPbrvhfUmcHzfbECSn"
        },
        "registry": {
            "com_edocman": {
                "category": {
                    "limitstart": 0,
                    "id": "40"
                }
            }
        },
        "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: 7.31 ms / 7.31 ms Memory: 0.507 MB / 0.88 MB Application: afterLoad
Time: 47.60 ms / 54.92 ms Memory: 2.020 MB / 2.90 MB Application: afterInitialise
Time: 18.19 ms / 73.11 ms Memory: 0.507 MB / 3.41 MB Application: afterRoute
Time: 1.33 ms / 74.44 ms Memory: 0.013 MB / 3.42 MB Application: beforeRenderComponent com_edocman
Time: 35.84 ms / 110.28 ms Memory: 0.249 MB / 3.67 MB Application: Before Access::preloadComponents (all components)
Time: 1.66 ms / 111.94 ms Memory: 0.076 MB / 3.75 MB Application: After Access::preloadComponents (all components)
Time: 0.05 ms / 111.99 ms Memory: -0.003 MB / 3.74 MB Application: Before Access::getAssetRules (id:317 name:com_edocman)
Time: 0.40 ms / 112.39 ms Memory: 0.010 MB / 3.75 MB Application: After Access::getAssetRules (id:317 name:com_edocman)
Time: 2.54 ms / 114.93 ms Memory: 0.015 MB / 3.77 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.04 ms / 114.97 ms Memory: 0.007 MB / 3.78 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 30.28 ms / 145.25 ms Memory: 0.782 MB / 4.56 MB Application: Before Access::preloadPermissions (com_edocman)
Time: 2.00 ms / 147.26 ms Memory: 0.383 MB / 4.94 MB Application: After Access::preloadPermissions (com_edocman)
Time: 0.04 ms / 147.29 ms Memory: -0.019 MB / 4.92 MB Application: Before Access::getAssetRules (id:8863 name:com_edocman.category.40)
Time: 0.01 ms / 147.31 ms Memory: 0.002 MB / 4.92 MB Application: After Access::getAssetRules (id:8863 name:com_edocman.category.40)
Time: 11.67 ms / 158.97 ms Memory: 0.112 MB / 5.04 MB Application: afterRenderComponent com_edocman
Time: 5.54 ms / 164.51 ms Memory: 0.110 MB / 5.15 MB Application: afterDispatch
Time: 7.22 ms / 171.73 ms Memory: 0.159 MB / 5.30 MB Application: beforeRenderModule mod_custom (Footer)
Time: 0.92 ms / 172.65 ms Memory: 0.008 MB / 5.31 MB Application: afterRenderModule mod_custom (Footer)
Time: 0.08 ms / 172.73 ms Memory: 0.000 MB / 5.31 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 28.41 ms / 201.14 ms Memory: 0.987 MB / 6.30 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.08 ms / 201.21 ms Memory: -0.005 MB / 6.29 MB Application: beforeRenderModule mod_finder (Smart Search)
Time: 8.23 ms / 209.44 ms Memory: 0.140 MB / 6.43 MB Application: afterRenderModule mod_finder (Smart Search)
Time: 15.46 ms / 224.90 ms Memory: 0.979 MB / 7.41 MB Application: afterRender

Database queries total: 42.27 ms

Memory Usage

8.17 MB (8,562,168 Bytes)

Database Queries

69 Queries Logged 42.27 ms


11 duplicate found!

2 duplicates: #18  #39
2 duplicates: #20  #22
7 duplicates: #25  #27  #29  #31  #33  #35  #37
  1. Query Time: 0.68 ms Query memory: 0.023 MB Memory before query: 1.248 MB Rows returned: 0
    SELECT `data`
    
      FROM `j745_session`
      WHERE `session_id` = X'6562666538633134393362303663666432623731366163316366353635643331'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.40 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    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:758
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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.23 ms After last query: 0.69 ms Query memory: 0.020 MB Memory before query: 1.264 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `j745_session`
      WHERE `session_id` = X'6562666538633134393362303663666432623731366163316366353635643331'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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.30 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 1.269 MB
    INSERT INTO `j745_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6562666538633134393362303663666432623731366163316366353635643331', 1, 1611647872, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `j745_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6562666538633134393362303663666432623731366163316366353635643331', 1, 1611647872, 0, '', 0)
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.12 ms
    end0.00 ms
    query end0.04 ms
    closing tables0.01 ms
    freeing items0.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:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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.90 ms After last query: 1.37 ms Query memory: 0.057 MB Memory before query: 1.306 MB Rows returned: 53
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j745_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefextensionextension82const541.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.30 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.29 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    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:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    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:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.50 ms After last query: 1.23 ms Query memory: 0.021 MB Memory before query: 1.369 MB Rows returned: 5
    SELECT id, rules
    
      FROM `j745_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_viewlevelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL5100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.28 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    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:321
    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:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.61 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.380 MB Rows returned: 2
    SELECT b.id
    
      FROM j745_usergroups AS a
      LEFT JOIN j745_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.27 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    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:321
    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:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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: 1.14 ms After last query: 0.35 ms Query memory: 0.051 MB Memory before query: 1.403 MB Rows returned: 164
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM j745_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefextensionextension82const2470.60Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.81 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    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:359
    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:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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: 0.69 ms After last query: 12.10 ms Query memory: 0.022 MB Memory before query: 2.050 MB Rows returned: 1
    SELECT *
    
      FROM j745_ea_configs
      WHERE `name` = 'config'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_ea_configsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL333.33Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.38 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    13JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    12Joomla\CMS\Table\Table->load()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:87
    11EA::config()JROOT/administrator/components/com_easyarticles/includes/utils.php:52
    10EasyArticles->__construct()JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23
    9EAAcl->__construct()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:59
    8EA::acl()JROOT/plugins/system/easyarticles/easyarticles.php:40
    7PlgSystemEasyArticles->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.33 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 2.092 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j745_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    19Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    18call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    16Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    15Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    14Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/administrator/components/com_easyarticles/includes/utils.php:55
    10EasyArticles->__construct()JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23
    9EAAcl->__construct()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:59
    8EA::acl()JROOT/plugins/system/easyarticles/easyarticles.php:40
    7PlgSystemEasyArticles->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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: 0.35 ms After last query: 0.11 ms Query memory: 0.007 MB Memory before query: 2.085 MB
    UPDATE `j745_extensions`
    
      SET `params` = '{\"mediaversion\":\"068510a0037d971016b778f52d90d517\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.04 ms
    updating0.09 ms
    end0.01 ms
    query end0.05 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    15Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    14Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/administrator/components/com_easyarticles/includes/utils.php:55
    10EasyArticles->__construct()JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23
    9EAAcl->__construct()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:59
    8EA::acl()JROOT/plugins/system/easyarticles/easyarticles.php:40
    7PlgSystemEasyArticles->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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: 1.84 ms After last query: 11.40 ms Query memory: 0.101 MB Memory before query: 2.516 MB Rows returned: 84
    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 j745_menu AS m
      LEFT JOIN j745_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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_client_id_parent_id_alias_languageNO INDEX KEY COULD BE USEDNULLNULL2584.38Using where; Using filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4toddt208_jm.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.48 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.78 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.05 ms
    cleaning up0.03 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    21Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    20call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    18Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    17Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    16Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    15Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    14Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    13Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    12Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    11Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    10Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    9Joomla\CMS\Application\SiteApplication::getRouter()JROOT/plugins/system/communitybuilder/communitybuilder.php:300
    8plgSystemCommunityBuilder->onAfterInitialise()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:626
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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: 1.14 ms After last query: 19.16 ms Query memory: 0.021 MB Memory before query: 3.395 MB Rows returned: 1
    SELECT `query`
    
      FROM j745_edocman_urls
      WHERE md5_key="b074bd572c48241603a3157b978d3824"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.42 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.30 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    10JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:270
    9EdocmanRouter->parse()JROOT/libraries/src/Router/SiteRouter.php:438
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:139
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1074
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.86 ms After last query: 0.34 ms Query memory: 0.022 MB Memory before query: 3.402 MB Rows returned: 13
    SELECT id, home, template, s.params
    
      FROM j745_template_styles as s
      LEFT JOIN j745_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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const111.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202toddt208_jm.e.element186.67Using index condition; Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.27 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.16 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    10Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/plugins/system/gantry5/gantry5.php:195
    9plgSystemGantry5->onAfterRouteSite()JROOT/plugins/system/gantry5/gantry5.php:57
    8plgSystemGantry5->onAfterRoute()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:1122
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.64 ms After last query: 0.80 ms Query memory: 0.019 MB Memory before query: 3.412 MB Rows returned: 1
    SELECT *
    
      FROM j745_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_languagesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.30 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    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:196
    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: 1.12 ms After last query: 13.95 ms Query memory: 0.031 MB Memory before query: 3.553 MB Rows returned: 128
    SELECT * 
      FROM j745_edocman_configs
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_configsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL128100.00NULL
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.52 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.14 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:564
    9EDocmanHelper::getConfig()JROOT/components/com_edocman/controller/controller.php:35
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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: 1.37 ms After last query: 19.43 ms Query memory: 0.034 MB Memory before query: 3.603 MB Rows returned: 31
    SHOW FULL COLUMNS 
      FROM `j745_edocman_categories`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j745_edocman_categories`
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.22 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.36 ms
    checking permissions0.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.03 ms
    Sending data0.07 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.13 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:445
    19JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    18Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    17Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_edocman/table/category.php:28
    16EDocmanTableCategory->__construct()JROOT/administrator/components/com_edocman/libraries/rad/model/model.php:246
    15OSModel->getTable()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:71
    14OSModelList->__construct()JROOT/components/com_edocman/model/list.php:33
    13EDocmanModelList->__construct()JROOT/components/com_edocman/model/category.php:24
    12EDocmanModelCategory->__construct()JROOT/administrator/components/com_edocman/libraries/rad/model/model.php:117
    11OSModel::getInstance()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:408
    10OSController->getModel()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:329
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.40 ms After last query: 0.61 ms Query memory: 0.031 MB Memory before query: 3.680 MB Rows returned: 53
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `j745_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_bfsurveytrial','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyarticles','com_edocman','com_eventgallery','com_export_users_community_builder','com_fields','com_finder','com_gallery','com_gantry','com_gantry5','com_installer','com_jce','com_jevents','com_jevlocations','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plotalot','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsvppro','com_search','com_simplifiedsocialshare','com_spiderfaq','com_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_assetsNULLrangeidx_asset_nameidx_asset_name202NULL54100.00Using index condition
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.31 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.17 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.47 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_edocman/model/list.php:124
    14EDocmanModelList->_buildQueryWhere()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:160
    13OSModelList->getTotal()JROOT/administrator/components/com_edocman/libraries/rad/model/model.php:299
    12OSModel->set()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:490
    11OSController->populateModelStates()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:411
    10OSController->getModel()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:329
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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: 1.45 ms After last query: 0.84 ms Query memory: 0.023 MB Memory before query: 3.755 MB Rows returned: 1
    Duplicate queries: #39
    SELECT COUNT(*)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND (((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.owner_group_ids = ''
      AND tbl.access IN (1,1,5)) OR ((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id = 40 )
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const1100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2DEPENDENT SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.71 ms
    init0.12 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.06 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:162
    13OSModelList->getTotal()JROOT/administrator/components/com_edocman/libraries/rad/model/model.php:299
    12OSModel->set()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:490
    11OSController->populateModelStates()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:411
    10OSController->getModel()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:329
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.30 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 3.760 MB Rows returned: 1
    SELECT *
    
      FROM j745_edocman_categories
      WHERE id = 40
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    12JDatabaseDriver->loadObject()JROOT/components/com_edocman/helper/helper.php:777
    11EDocmanHelper::canAccessCategory()JROOT/components/com_edocman/view/category/html.php:27
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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: 0.20 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 3.778 MB Rows returned: 1
    Duplicate queries: #22
    SELECT *
    
      FROM j745_edocman_categories
      WHERE id=40
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.00 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/components/com_edocman/helper/helper.php:221
    13EDocmanHelper::getCategory()JROOT/components/com_edocman/model/list.php:327
    12EDocmanModelList->_buildQueryOrder()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:136
    11OSModelList->getData()JROOT/components/com_edocman/view/category/html.php:42
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.88 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.785 MB Rows returned: 0
    SELECT tbl.*,DATEDIFF('2021-01-26 07:57:52', created_time) AS number_created_days,DATEDIFF('2021-01-26 07:57:52', modified_time) AS number_updated_days
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND (((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.owner_group_ids = ''
      AND tbl.access IN (1,1,5)) OR ((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id = 40 )
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
      GROUP BY tbl.id
      ORDER BY tbl.ordering ASC
      LIMIT 10
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const1100.00Using where; Using temporary; Using filesort; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2DEPENDENT SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.10 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.05 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.18 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.00 ms
    removing tmp table0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:139
    11OSModelList->getData()JROOT/components/com_edocman/view/category/html.php:42
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.27 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.788 MB Rows returned: 1
    Duplicate queries: #20
    SELECT *
    
      FROM j745_edocman_categories
      WHERE id=40
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    12JDatabaseDriver->loadObject()JROOT/components/com_edocman/helper/helper.php:221
    11EDocmanHelper::getCategory()JROOT/components/com_edocman/view/category/html.php:43
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.38 ms After last query: 12.29 ms Query memory: 0.023 MB Memory before query: 4.200 MB Rows returned: 1
    SELECT config_value 
      FROM j745_edocman_configs
      WHERE config_key="number_categories"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_configsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL12810.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:521
    13EDocmanHelper::getConfigValue()JROOT/components/com_edocman/model/categories.php:22
    12EDocmanModelCategories->__construct()JROOT/administrator/components/com_edocman/libraries/rad/model/model.php:117
    11OSModel::getInstance()JROOT/components/com_edocman/view/category/html.php:182
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.76 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 4.211 MB Rows returned: 7
    SELECT tbl.*
    
      FROM j745_edocman_categories AS tbl
      WHERE tbl.published=1
      AND tbl.parent_id=40
      AND (((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.accesspicker = '0'
      AND tbl.access IN (1,1,5)) OR ((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = 0) ) OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      ORDER BY tbl.ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYtblNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL412.44Using where; Using filesort
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.13 ms
    checking permissions0.00 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    Sorting result0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.15 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    removing tmp table0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:139
    12OSModelList->getData()JROOT/components/com_edocman/model/categories.php:42
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.31 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 4.230 MB Rows returned: 41
    Duplicate queries: #27  #29  #31  #33  #35  #37
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.00 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.07 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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: 0.25 ms Query memory: 0.022 MB Memory before query: 4.240 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(41))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const10100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.08 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.05 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.14 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.05 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    removing tmp table0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.22 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 4.244 MB Rows returned: 41
    Duplicate queries: #25  #29  #31  #33  #35  #37
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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: 0.57 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.254 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(42))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const10100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.04 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.12 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    removing tmp table0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.19 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 4.259 MB Rows returned: 41
    Duplicate queries: #25  #27  #31  #33  #35  #37
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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: 0.54 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 4.269 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(43))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const11100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.10 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    removing tmp table0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.19 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 4.273 MB Rows returned: 41
    Duplicate queries: #25  #27  #29  #33  #35  #37
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.49 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 4.283 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(44))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const10100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    removing tmp table0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.18 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 4.295 MB Rows returned: 41
    Duplicate queries: #25  #27  #29  #31  #35  #37
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.56 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.305 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(45))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const2100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.01 ms
    removing tmp table0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.28 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 4.310 MB Rows returned: 41
    Duplicate queries: #25  #27  #29  #31  #33  #37
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.37 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.320 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(46))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const1100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2DEPENDENT SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  37. Query Time: 0.29 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 4.325 MB Rows returned: 41
    Duplicate queries: #25  #27  #29  #31  #33  #35
    SELECT id, parent_id
    
      FROM j745_edocman_categories
      WHERE published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4110.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/helper.php:1108
    13EDocmanHelper::getAllChildrenCategories()JROOT/components/com_edocman/helper/helper.php:385
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  38. Query Time: 0.44 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.335 MB Rows returned: 1
    SELECT COUNT(tbl.id)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND ((tbl.user_ids = ''
      AND tbl.access IN (1,1,5)) OR (tbl.user_ids = ''
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id IN(47,49,50,51,52,53,54,55,60))
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrangedocument_id,category_idcategory_id5NULL9100.00Using index condition; Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.04 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    removing tmp table0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_edocman/helper/helper.php:427
    12EDocmanHelper::countDocuments()JROOT/components/com_edocman/model/categories.php:46
    11EDocmanModelCategories->getData()JROOT/components/com_edocman/view/category/html.php:188
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  39. Query Time: 0.41 ms After last query: 0.67 ms Query memory: 0.022 MB Memory before query: 4.338 MB Rows returned: 1
    Duplicate queries: #18
    SELECT COUNT(*)
    
      FROM j745_edocman_documents AS tbl
      WHERE tbl.published=1
      AND (((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.owner_group_ids = ''
      AND tbl.access IN (1,1,5)) OR ((tbl.user_ids = '' OR tbl.user_ids is NULL)
      AND tbl.accesspicker = '1'
      AND tbl.id in (Select item_id
      from j745_edocman_levels
      where (`groups`='9' OR `groups` LIKE '9,%' OR `groups` LIKE '%,9,%' OR `groups` LIKE '%,9')
      AND `data_type` = '1') ) or ( tbl.owner_group_ids ='1' OR tbl.owner_group_ids LIKE '1,%' OR tbl.owner_group_ids LIKE '%,1,%' OR tbl.owner_group_ids LIKE '%,1' or tbl.owner_group_ids ='9' OR tbl.owner_group_ids LIKE '9,%' OR tbl.owner_group_ids LIKE '%,9,%' OR tbl.owner_group_ids LIKE '%,9') OR tbl.user_ids='0' OR tbl.user_ids LIKE '0,%' OR tbl.user_ids LIKE '%,0,%' OR tbl.user_ids LIKE '%,0' OR (tbl.created_user_id=0
      AND tbl.created_user_id > 0))
      AND tbl.id IN (SELECT document_id
      FROM j745_edocman_document_category
      WHERE category_id = 40 )
      AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2021-01-26 07:57:52')
      AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2021-01-26 07:57:52')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYj745_edocman_document_categoryNULLrefdocument_id,category_idcategory_id5const1100.00Using where; Start temporary
    1PRIMARYtblNULLeq_refPRIMARYPRIMARY4toddt208_jm.j745_edocman_document_category.document_id15.00Using where; End temporary
    2DEPENDENT SUBQUERYj745_edocman_levelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL812.50Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.00 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    removing tmp table0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:162
    12OSModelList->getTotal()JROOT/administrator/components/com_edocman/libraries/rad/model/list.php:179
    11OSModelList->getPagination()JROOT/components/com_edocman/view/category/html.php:216
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  40. Query Time: 0.31 ms After last query: 3.90 ms Query memory: 0.029 MB Memory before query: 4.432 MB Rows returned: 41
    SELECT id, alias, parent_id
    
      FROM j745_edocman_categories
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_categoriesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL41100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/components/com_edocman/helper/route.php:183
    21EDocmanHelperRoute::getCategoriesPath()JROOT/components/com_edocman/router.php:81
    20EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    19Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    18Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    17Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    16Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    15Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    14Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/category/tmpl/table.php:14
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  41. Query Time: 0.48 ms After last query: 1.39 ms Query memory: 0.026 MB Memory before query: 4.538 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="b074bd572c48241603a3157b978d3824"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.30 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    21JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    20EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    19Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    18Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    17Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    16Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    15Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    14Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/category/tmpl/table.php:14
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  42. Query Time: 0.50 ms After last query: 0.08 ms Query memory: 0.010 MB Memory before query: 4.549 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=40&layout=table"
      WHERE md5_key="b074bd572c48241603a3157b978d3824"
      AND id=8
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.04 ms
    updating0.14 ms
    end0.01 ms
    query end0.07 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    20EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    19Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    18Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    17Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    16Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    15Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    14Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/category/tmpl/table.php:14
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  43. Query Time: 1.28 ms After last query: 0.22 ms Query memory: 0.080 MB Memory before query: 4.558 MB Rows returned: 481
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `j745_assets`
      WHERE `name` LIKE 'com_edocman.%' OR `name` = 'com_edocman' OR `parent_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_assetsNULLALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL102221.48Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.90 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_edocman/view/category/tmpl/table.php:51
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  44. Query Time: 0.90 ms After last query: 4.52 ms Query memory: 0.027 MB Memory before query: 4.944 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="0f03f2dc6ba12664eafdf6f7078d0ae7"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.47 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  45. Query Time: 0.39 ms After last query: 0.08 ms Query memory: 0.011 MB Memory before query: 4.956 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=41"
      WHERE md5_key="0f03f2dc6ba12664eafdf6f7078d0ae7"
      AND id=10
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.05 ms
    updating0.09 ms
    end0.01 ms
    query end0.06 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  46. Query Time: 0.61 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 4.967 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="97d1f123258209279c59d511360b466c"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.42 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  47. Query Time: 0.31 ms After last query: 0.05 ms Query memory: 0.011 MB Memory before query: 4.980 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=42"
      WHERE md5_key="97d1f123258209279c59d511360b466c"
      AND id=11
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.03 ms
    updating0.07 ms
    end0.01 ms
    query end0.04 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  48. Query Time: 0.65 ms After last query: 0.28 ms Query memory: 0.027 MB Memory before query: 4.990 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="f6202b800b660e42403ac478d1f3d9a9"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.40 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  49. Query Time: 0.39 ms After last query: 0.07 ms Query memory: 0.011 MB Memory before query: 5.003 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=43"
      WHERE md5_key="f6202b800b660e42403ac478d1f3d9a9"
      AND id=12
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.03 ms
    updating0.09 ms
    end0.00 ms
    query end0.04 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  50. Query Time: 0.44 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 5.014 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="bb4f89a8b849e29720d3816e871246b6"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.27 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  51. Query Time: 0.21 ms After last query: 0.04 ms Query memory: 0.011 MB Memory before query: 5.026 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=44"
      WHERE md5_key="bb4f89a8b849e29720d3816e871246b6"
      AND id=13
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.02 ms
    updating0.04 ms
    end0.00 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  52. Query Time: 0.41 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 5.037 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="6b0f9300d84a837d427378f76e12e3d4"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.27 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  53. Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.011 MB Memory before query: 5.050 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=45"
      WHERE md5_key="6b0f9300d84a837d427378f76e12e3d4"
      AND id=14
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.02 ms
    updating0.03 ms
    end0.00 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  54. Query Time: 0.36 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 5.060 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="13c3d8695e6c522e60754922e1e65e4f"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.24 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  55. Query Time: 0.16 ms After last query: 0.04 ms Query memory: 0.011 MB Memory before query: 5.073 MB
    UPDATE j745_edocman_urls
    
      SET `query`="view=category&id=46"
      WHERE md5_key="13c3d8695e6c522e60754922e1e65e4f"
      AND id=15
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_edocman_urlsNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.02 ms
    updating0.03 ms
    end0.00 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/components/com_edocman/router.php:235
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  56. Query Time: 0.40 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 5.084 MB Rows returned: 1
    SELECT id
    
      FROM j745_edocman_urls
      WHERE md5_key="d8cf0e2c6eee844bcc4436e640683afa"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_edocman_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL43810.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.27 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    23JDatabaseDriver->loadResult()JROOT/components/com_edocman/router.php:229
    22EdocmanRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    21Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    20Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    19Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    18Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    17Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    16Joomla\CMS\Router\Route::_()JROOT/components/com_edocman/view/common/categories_table.php:33
    15include JROOT/components/com_edocman/view/common/categories_table.phpJROOT/components/com_edocman/helper/html.php:37
    14EDocmanHelperHtml::loadCommonLayout()JROOT/components/com_edocman/view/category/tmpl/table.php:91
    13include JROOT/components/com_edocman/view/category/tmpl/table.phpJROOT/administrator/components/com_edocman/libraries/rad/view/html.php:207
    12OSViewHtml->render()JROOT/administrator/components/com_edocman/libraries/rad/view/html.php:113
    11OSViewHtml->display()JROOT/components/com_edocman/view/category/html.php:246
    10EDocmanViewCategoryHtml->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:360
    9OSController->display()JROOT/components/com_edocman/controller/controller.php:46
    8EDocmanController->display()JROOT/administrator/components/com_edocman/libraries/rad/controller/controller.php:302
    7OSController->execute()JROOT/components/com_edocman/edocman.php:29
    6require_once JROOT/components/com_edocman/edocman.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    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:196
    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.]

  57. Query Time: 0.21 ms After last query: 0.05 ms Query memory: 0.011 MB Memory before query: 5.096 MB