Aditya Test site
Toggle Navigation
  • Home
  • Blog
  • login
  • form
  • Categories listing
  • Products listing
  • cart

Main Menu

  • Home
  • Blog
  • login
  • form
  • Categories listing
  • Products listing
  • cart

Categories on 2 levels

Shoes

  • Men
  • Women
  • Kids

Computing

  • Peripherals
  • Computers

E-books

  • English books
  • French books

Automobile

  • Cars
  • Spare parts

  • Privacy
  • Terms
  • Copyright © Site Name
  • Sitemap
  • Icon Visual Marketing

Back to Top

© 2021 Aditya Test site

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614502434,
                "last": 1614502434,
                "now": 1614502434
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_contactenhanced": {
            "isekeywords": {
                "referer": null,
                "all_keywords": [
                    ""
                ],
                "filter_keywords": [],
                "params": {
                    "load-instructions": "0",
                    "enable-highlight": "0",
                    "integrate-ce": "1",
                    "exclude": "a,e,i,o,u,an,the,for,is,in,are,was,and,from,of,on,with,this,that,or,these,those"
                },
                "queryString": "",
                "i": 1,
                "excludes": [
                    "a",
                    "e",
                    "i",
                    "o",
                    "u",
                    "an",
                    "the",
                    "for",
                    "is",
                    "in",
                    "are",
                    "was",
                    "and",
                    "from",
                    "of",
                    "on",
                    "with",
                    "this",
                    "that",
                    "or",
                    "these",
                    "those",
                    " ",
                    ".",
                    ",",
                    ";",
                    "!",
                    "?"
                ]
            }
        }
    }
}

Profile Information

Time

Memory

Time: 22.39 ms / 22.39 ms Memory: 1.656 MB / 2.02 MB Application: afterLoad
Time: 206.88 ms / 229.27 ms Memory: 13.666 MB / 15.69 MB Application: afterInitialise
Time: 32.32 ms / 261.60 ms Memory: 1.828 MB / 17.51 MB Application: afterRoute
Time: 1.67 ms / 263.27 ms Memory: 0.019 MB / 17.53 MB Application: beforeRenderComponent com_xmap
Time: 150.03 ms / 413.30 ms Memory: 0.842 MB / 18.38 MB Application: Before Access::preloadComponents (all components)
Time: 2.20 ms / 415.50 ms Memory: 0.071 MB / 18.45 MB Application: After Access::preloadComponents (all components)
Time: 0.06 ms / 415.56 ms Memory: 0.000 MB / 18.44 MB Application: Before Access::preloadPermissions (com_xmap)
Time: 1.16 ms / 416.72 ms Memory: 0.011 MB / 18.45 MB Application: After Access::preloadPermissions (com_xmap)
Time: 18.88 ms / 435.60 ms Memory: 0.257 MB / 18.71 MB Application: Before Access::getAssetRules (id:70 name:com_xmap)
Time: 0.62 ms / 436.22 ms Memory: 0.027 MB / 18.74 MB Application: After Access::getAssetRules (id:70 name:com_xmap)
Time: 83.57 ms / 519.79 ms Memory: 0.409 MB / 19.15 MB Application: afterRenderComponent com_xmap
Time: 11.11 ms / 530.90 ms Memory: 0.553 MB / 19.70 MB Application: afterDispatch
Time: 5.20 ms / 536.11 ms Memory: 0.137 MB / 19.84 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 3.71 ms / 539.82 ms Memory: 0.109 MB / 19.95 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.08 ms / 539.90 ms Memory: 0.000 MB / 19.95 MB Application: beforeRenderModule mod_hikashop (Categories on 2 levels)
Time: 59.58 ms / 599.48 ms Memory: 3.586 MB / 23.53 MB Application: afterRenderModule mod_hikashop (Categories on 2 levels)
Time: 0.15 ms / 599.63 ms Memory: 0.000 MB / 23.52 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 2.02 ms / 601.66 ms Memory: 0.043 MB / 23.56 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 13.77 ms / 615.43 ms Memory: 1.043 MB / 24.61 MB Application: afterRender

Database queries total: 43.50 ms

Memory Usage

25.11 MB (26,334,528 Bytes)

Database Queries

48 Queries Logged 43.50 ms


4 duplicate found!

2 duplicates: #8  #9
2 duplicates: #25  #26
  1. Query Time: 0.78 ms Query memory: 0.025 MB Memory before query: 3.710 MB Rows returned: 0
    SELECT `data`
    
      FROM `xvd3l_session`
      WHERE `session_id` = '336afab3226d073eb044a04b41766890'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    System lock0.03 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.19 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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.36 ms After last query: 1.70 ms Query memory: 0.022 MB Memory before query: 3.875 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `xvd3l_session`
      WHERE `session_id` = '336afab3226d073eb044a04b41766890'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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: 2.90 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 3.881 MB
    INSERT INTO `xvd3l_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('336afab3226d073eb044a04b41766890', 1, 1614502434, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `xvd3l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('336afab3226d073eb044a04b41766890', 1, 1614502434, 0, '', 0)
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    update0.21 ms
    Waiting for query cache lock0.01 ms
    update0.01 ms
    end0.00 ms
    query end2.48 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 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.62 ms After last query: 3.50 ms Query memory: 0.060 MB Memory before query: 4.091 MB Rows returned: 49
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `xvd3l_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_extensionsrefextensionextension82const49Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.32 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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.25 ms After last query: 3.06 ms Query memory: 0.023 MB Memory before query: 4.330 MB Rows returned: 5
    SELECT id, rules
    
      FROM `xvd3l_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    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.33 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.342 MB Rows returned: 2
    SELECT b.id
    
      FROM xvd3l_usergroups AS a
      LEFT JOIN xvd3l_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where; Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    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.24 ms After last query: 0.81 ms Query memory: 0.041 MB Memory before query: 4.408 MB Rows returned: 181
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM xvd3l_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_extensionsALLextensionNO INDEX KEY COULD BE USEDNULLNULL293Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.36 ms
    Sending data0.58 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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.83 ms After last query: 14.39 ms Query memory: 0.024 MB Memory before query: 5.641 MB Rows returned: 0
    Duplicate queries: #9
    SELECT `manifest_cache`
    
      FROM `xvd3l_extensions`
      WHERE `type` = 'component'
      AND `name` = 'com_admintools'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_extensionsrefextensionextension82const49Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.31 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/libraries/fof30/Container/Container.php:787
    12FOF30\Container\Container->getDefaultMediaVersion()JROOT/libraries/fof30/Container/Container.php:675
    11FOF30\Container\Container->__construct()JROOT/libraries/fof30/Container/Container.php:159
    10FOF30\Container\Container::makeInstance()JROOT/libraries/fof30/Container/Container.php:140
    9FOF30\Container\Container::getInstance()JROOT/plugins/system/admintools/admintools/main.php:813
    8plgSystemAdmintools->initialize()JROOT/plugins/system/admintools/admintools/main.php:110
    7plgSystemAdmintools->__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.81 ms After last query: 6.15 ms Query memory: 0.024 MB Memory before query: 5.936 MB Rows returned: 0
    Duplicate queries: #8
    SELECT `manifest_cache`
    
      FROM `xvd3l_extensions`
      WHERE `type` = 'component'
      AND `name` = 'com_admintools'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_extensionsrefextensionextension82const49Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.30 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/libraries/fof30/Container/Container.php:787
    12FOF30\Container\Container->getDefaultMediaVersion()JROOT/libraries/fof30/Container/Container.php:675
    11FOF30\Container\Container->__construct()JROOT/libraries/fof30/Container/Container.php:290
    10FOF30\Container\Container::makeInstance()JROOT/libraries/fof30/Container/Container.php:140
    9FOF30\Container\Container::getInstance()JROOT/plugins/system/admintools/admintools/main.php:813
    8plgSystemAdmintools->initialize()JROOT/plugins/system/admintools/admintools/main.php:110
    7plgSystemAdmintools->__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.52 ms After last query: 0.37 ms Query memory: 0.024 MB Memory before query: 5.953 MB Rows returned: 1
    SELECT `value`
    
      FROM `xvd3l_admintools_storage`
      WHERE `key` = 'cparams'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_storageconstPRIMARYPRIMARY402const1
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    13JDatabaseDriver->loadResult()JROOT/administrator/components/com_admintools/Helper/Storage.php:123
    12Akeeba\AdminTools\Admin\Helper\Storage->load()JROOT/administrator/components/com_admintools/Helper/Storage.php:53
    11Akeeba\AdminTools\Admin\Helper\Storage->__construct()JROOT/administrator/components/com_admintools/Helper/Storage.php:41
    10Akeeba\AdminTools\Admin\Helper\Storage::getInstance()JROOT/plugins/system/admintools/admintools/main.php:278
    9plgSystemAdmintools->loadComponentParameters()JROOT/plugins/system/admintools/admintools/main.php:831
    8plgSystemAdmintools->initialize()JROOT/plugins/system/admintools/admintools/main.php:110
    7plgSystemAdmintools->__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: 0.49 ms After last query: 2.89 ms Query memory: 0.024 MB Memory before query: 6.413 MB Rows returned: 0
    SELECT *
    
      FROM `xvd3l_admintools_wafexceptions`
      WHERE NOT(`option` LIKE 'com_%')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_wafexceptionsALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.05 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    11JDatabaseDriver->loadAssocList()JROOT/plugins/system/admintools/admintools/main.php:549
    10plgSystemAdmintools->loadWAFExceptionsSEF()JROOT/plugins/system/admintools/admintools/main.php:460
    9plgSystemAdmintools->loadWAFExceptions()JROOT/plugins/system/admintools/admintools/main.php:843
    8plgSystemAdmintools->initialize()JROOT/plugins/system/admintools/admintools/main.php:110
    7plgSystemAdmintools->__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.]

  12. Query Time: 1.17 ms After last query: 38.68 ms Query memory: 0.040 MB Memory before query: 9.070 MB Rows returned: 18
    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 xvd3l_menu AS m
      LEFT JOIN xvd3l_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL18Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4adityaic_joomla_test.m.component_id1
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.20 ms
    Sending data0.44 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    20Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    19call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    17Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    16Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    15Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    14Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    13Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    12Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    11Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    10Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    9Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    8Joomla\CMS\Application\SiteApplication::getRouter()JROOT/plugins/system/wbamp/wbamp.php:210
    7plgSystemWbamp->__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.]

  13. Query Time: 0.47 ms After last query: 46.41 ms Query memory: 0.023 MB Memory before query: 11.373 MB Rows returned: 1
    SHOW VARIABLES LIKE "collation_database"
    Explain
    EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"
    Profile
    StatusDuration
    starting0.03 ms
    Opening tables0.04 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.20 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.00 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    12JDatabaseDriver->loadObject()JROOT/libraries/joomla/database/driver/mysqli.php:342
    11JDatabaseDriverMysqli->getCollation()JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    10AtsystemFeatureUtf8mb4->onAfterInitialise()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:135
    8plgSystemAdmintools->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.]

  14. Query Time: 0.51 ms After last query: 0.65 ms Query memory: 0.024 MB Memory before query: 11.408 MB Rows returned: 0
    SELECT *
    
      FROM `xvd3l_admintools_ipautoban`
      WHERE `ip` = '3.235.11.178'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    12JDatabaseDriver->loadObject()JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    11AtsystemFeatureAutoipfiltering->isIPBlocked()JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    10AtsystemFeatureAutoipfiltering->onAfterInitialise()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:135
    8plgSystemAdmintools->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.]

  15. Query Time: 0.45 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 11.413 MB Rows returned: 0
    SELECT `ip`
    
      FROM `xvd3l_admintools_ipblock`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_ipblockALLNULLNO INDEX KEY COULD BE USEDNULLNULL1
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    12JDatabaseDriver->loadColumn()JROOT/plugins/system/admintools/feature/ipblacklist.php:139
    11AtsystemFeatureIpblacklist->isIPBlocked()JROOT/plugins/system/admintools/feature/ipblacklist.php:33
    10AtsystemFeatureIpblacklist->onAfterInitialise()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:135
    8plgSystemAdmintools->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.]

  16. Query Time: 0.47 ms After last query: 0.76 ms Query memory: 0.023 MB Memory before query: 11.439 MB Rows returned: 0
    SELECT `source`,`keepurlparams`
    
      FROM `xvd3l_admintools_redirects`
      WHERE ((`dest` = 'sitemap') OR (`dest` = 'sitemap') OR ('sitemap' LIKE `dest`))
      AND `published` = '1'
      ORDER BY `ordering` DESC
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_redirectsALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.05 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1767
    11JDatabaseDriver->loadRow()JROOT/plugins/system/admintools/feature/urlredir.php:89
    10AtsystemFeatureUrlredir->onAfterInitialise()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:135
    8plgSystemAdmintools->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.]

  17. Query Time: 0.41 ms After last query: 17.58 ms Query memory: 0.028 MB Memory before query: 12.861 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `xvd3l_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    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_hikashop/helpers/helper.php:2755
    10include_once JROOT/administrator/components/com_hikashop/helpers/helper.phpJROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
    9plgSystemHikashopgeolocation->process()JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
    8plgSystemHikashopgeolocation->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.]

  18. Query Time: 2.20 ms After last query: 0.23 ms Query memory: 0.007 MB Memory before query: 12.855 MB
    UPDATE `xvd3l_extensions`
    
      SET `params` = '{\"mediaversion\":\"730de712f54d3a55bcecd6e9eeb6ffe5\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `xvd3l_extensions` SET `params` = '{\"mediaversion\":\"730de712f54d3a55bcecd6e9eeb6ffe5\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.06 ms
    Updating0.09 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end0.01 ms
    query end1.90 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 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_hikashop/helpers/helper.php:2755
    10include_once JROOT/administrator/components/com_hikashop/helpers/helper.phpJROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
    9plgSystemHikashopgeolocation->process()JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
    8plgSystemHikashopgeolocation->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.]

  19. Query Time: 0.49 ms After last query: 6.39 ms Query memory: 0.050 MB Memory before query: 13.526 MB Rows returned: 318
    SELECT * 
      FROM xvd3l_hikashop_config
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_configALLNULLNO INDEX KEY COULD BE USEDNULLNULL318
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.25 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/config.php:16
    12hikashopConfigClass->load()JROOT/administrator/components/com_hikashop/helpers/helper.php:1071
    11hikashop_config()JROOT/administrator/components/com_hikashop/helpers/helper.php:2774
    10include_once JROOT/administrator/components/com_hikashop/helpers/helper.phpJROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:168
    9plgSystemHikashopgeolocation->process()JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:57
    8plgSystemHikashopgeolocation->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.]

  20. Query Time: 0.32 ms After last query: 8.20 ms Query memory: 0.028 MB Memory before query: 14.620 MB Rows returned: 2
    SELECT *
    
      FROM xvd3l_languages
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.05 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_sh404sef/helpers/language.php:215
    12Sh404sefHelperLanguage::getAllContentLanguages()JROOT/administrator/components/com_sh404sef/helpers/language.php:167
    11Sh404sefHelperLanguage::getUrlCodeFromTag()JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
    10Sh404sefClassPageinfo->setCurrentLanguage()JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
    9Sh404sefClassPageinfo->init()JROOT/plugins/system/sh404sef/sh404sef.php:63
    8plgSystemSh404sef->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.]

  21. Query Time: 0.69 ms After last query: 11.09 ms Query memory: 0.024 MB Memory before query: 15.413 MB Rows returned: 1
    SELECT `params` 
      FROM xvd3l_extensions
      WHERE `element`='com_sh404sef'
      AND `type`='component';
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.05 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    15JDatabaseDriver->loadResult()JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
    14ShlDbClass->loadResult()JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
    13ShlDbClass->shlLoadResult()JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
    12ShlDbHelper::selectResult()JROOT/administrator/components/com_sh404sef/helpers/general.php:160
    11Sh404sefHelperGeneral::getComponentParams()JROOT/administrator/components/com_sh404sef/classes/config.php:653
    10Sh404sefClassConfig->__construct()JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
    9Sh404sefFactory::getConfig()JROOT/plugins/system/sh404sef/sh404sef.php:86
    8plgSystemSh404sef->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.]

  22. Query Time: 1.69 ms After last query: 31.42 ms Query memory: 0.026 MB Memory before query: 17.357 MB Rows returned: 1
    SELECT *
    
      FROM `xvd3l_admintools_wafblacklists`
      WHERE `verb` IN('','GET')
      AND `option` IN('','com_xmap')
      AND `view` IN('','html')
      AND `task` IN('','html.')
      AND `enabled` = '1'
      GROUP BY `query`
      ORDER BY `query` ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_wafblacklistsALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where; Using temporary; Using filesort
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.09 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Creating tmp table0.70 ms
    executing0.01 ms
    Copying to tmp table0.15 ms
    Sorting result0.06 ms
    Sending data0.05 ms
    end0.01 ms
    removing tmp table0.17 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/admintools/feature/wafblacklist.php:87
    10AtsystemFeatureWafblacklist->onAfterRoute()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:145
    8plgSystemAdmintools->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.]

  23. Query Time: 0.30 ms After last query: 3.83 ms Query memory: 0.025 MB Memory before query: 17.517 MB Rows returned: 1
    SELECT *
    
      FROM xvd3l_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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.]

  24. Query Time: 0.34 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 17.527 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM xvd3l_template_styles as s
      LEFT JOIN xvd3l_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL4Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403adityaic_joomla_test.s.template,const1Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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: 2.87 ms After last query: 32.41 ms Query memory: 0.029 MB Memory before query: 17.867 MB Rows returned: 1
    Duplicate queries: #26
    SELECT s.*
    
      FROM xvd3l_xmap_sitemap AS s
      WHERE s.published = '1'
      AND s.access IN (1,1,5)
      AND s.id = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_access,idx_statePRIMARY4const1
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    Opening tables2.18 ms
    System lock0.02 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.06 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/components/com_xmap/models/sitemap.php:65
    12XmapModelSitemap->getItem()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_xmap/views/html/view.html.php:63
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.54 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 17.873 MB Rows returned: 1
    Duplicate queries: #25
    SELECT s.*
    
      FROM xvd3l_xmap_sitemap AS s
      WHERE s.published = '1'
      AND s.access IN (1,1,5)
      AND s.id = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_access,idx_statePRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    System lock0.02 ms
    init0.10 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    13JDatabaseDriver->loadObject()JROOT/components/com_xmap/models/sitemap.php:71
    12XmapModelSitemap->getItem()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_xmap/views/html/view.html.php:63
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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: 1.18 ms After last query: 2.42 ms Query memory: 0.028 MB Memory before query: 17.918 MB Rows returned: 7
    SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
    
      FROM xvd3l_menu AS n
      INNER JOIN xvd3l_menu AS p
      ON p.lft = 0
      WHERE n.lft > p.lft
      AND n.lft < p.rgt
      AND n.menutype = 'mainmenu'
      AND n.published = 1
      AND n.access IN (1,1,5)
      ORDER BY n.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEnrefidx_menutype,idx_left_rightidx_menutype98const7Using where; Using filesort
    1SIMPLEprefidx_left_rightidx_left_right4const1Using where; Using index
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.17 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.05 ms
    executing0.01 ms
    Sorting result0.14 ms
    Sending data0.23 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.06 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    14JDatabaseDriver->loadObjectList()JROOT/components/com_xmap/helpers/xmap.php:103
    13XmapHelper::getMenuItems()JROOT/components/com_xmap/models/sitemap.php:96
    12XmapModelSitemap->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_xmap/views/html/view.html.php:64
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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: 1.25 ms After last query: 0.24 ms Query memory: 0.027 MB Memory before query: 17.956 MB Rows returned: 9
    SELECT e.element,e.folder,e.params
    
      FROM xvd3l_extensions AS e
      WHERE e.folder = 'xmap'
      AND e.enabled = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEeALLNULLNO INDEX KEY COULD BE USEDNULLNULL293Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.90 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/components/com_xmap/helpers/xmap.php:185
    15XmapHelper::getExtensions()JROOT/components/com_xmap/helpers/xmap.php:222
    14XmapHelper::prepareMenuItem()JROOT/components/com_xmap/helpers/xmap.php:141
    13XmapHelper::getMenuItems()JROOT/components/com_xmap/models/sitemap.php:96
    12XmapModelSitemap->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_xmap/views/html/view.html.php:64
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.66 ms After last query: 107.01 ms Query memory: 0.026 MB Memory before query: 18.321 MB Rows returned: 1
    SELECT `created`,`modified`,`introtext`,`fulltext`
    
      FROM `xvd3l_content`
      WHERE `id`=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.17 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.07 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    16JDatabaseDriver->loadObject()JROOT/plugins/xmap/com_content/com_content.php:82
    15xmap_com_content->prepareMenuItem()JROOT/components/com_xmap/helpers/xmap.php:238
    14XmapHelper::prepareMenuItem()JROOT/components/com_xmap/helpers/xmap.php:141
    13XmapHelper::getMenuItems()JROOT/components/com_xmap/models/sitemap.php:96
    12XmapModelSitemap->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_xmap/views/html/view.html.php:64
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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: 1.55 ms After last query: 2.23 ms Query memory: 0.032 MB Memory before query: 18.382 MB Rows returned: 49
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `xvd3l_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_hikashop','com_igallery','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nonumberinstaller','com_plugins','com_postinstall','com_privacy','com_redirect','com_redirector','com_search','com_sh404sef','com_tags','com_templates','com_uniform','com_users','com_watchfulli','com_weblinks','com_wrapper','com_xmap')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_assetsALLidx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL100Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.14 ms
    optimizing0.02 ms
    statistics0.33 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.52 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    15Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    14Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    13Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    12Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    11Joomla\CMS\User\User->authorise()JROOT/components/com_xmap/views/html/view.html.php:67
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.86 ms After last query: 0.60 ms Query memory: 0.026 MB Memory before query: 18.444 MB Rows returned: 2
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `xvd3l_assets`
      WHERE `name` LIKE 'com_xmap.%' OR `name` = 'com_xmap' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_assetsALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL100Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.19 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.27 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.08 ms
    logging slow query0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    15Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    14Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    13Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    12Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    11Joomla\CMS\User\User->authorise()JROOT/components/com_xmap/views/html/view.html.php:67
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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: 1.69 ms After last query: 15.35 ms Query memory: 0.030 MB Memory before query: 18.659 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `xvd3l_assets`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xvd3l_assets`
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.58 ms
    System lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.02 ms
    Opening tables0.03 ms
    checking permissions0.07 ms
    checking permissions0.04 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.04 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.17 ms
    closing tables0.01 ms
    freeing items0.13 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    19JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:445
    18JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    17Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    16Joomla\CMS\Table\Table->__construct()JROOT/libraries/src/Table/Asset.php:61
    15Joomla\CMS\Table\Asset->__construct()JROOT/libraries/src/Access/Access.php:783
    14Joomla\CMS\Access\Access::getAssetId()JROOT/libraries/src/Access/Access.php:544
    13Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    12Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    11Joomla\CMS\User\User->authorise()JROOT/components/com_xmap/views/html/view.html.php:67
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.58 ms After last query: 1.23 ms Query memory: 0.029 MB Memory before query: 18.707 MB Rows returned: 0
    SELECT *
    
      FROM xvd3l_assets
      WHERE `name` = 'com_xmap.sitemap.1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.10 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1459
    16JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    15Joomla\CMS\Table\Table->load()JROOT/libraries/src/Access/Access.php:784
    14Joomla\CMS\Access\Access::getAssetId()JROOT/libraries/src/Access/Access.php:544
    13Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    12Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    11Joomla\CMS\User\User->authorise()JROOT/components/com_xmap/views/html/view.html.php:67
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.90 ms After last query: 65.13 ms Query memory: 0.026 MB Memory before query: 18.812 MB Rows returned: 2
    SELECT m.params,m.title
    
      FROM xvd3l_modules AS m
      WHERE m.module = 'mod_menu'
      AND m.published = '1'
      AND m.client_id = '0'
      AND m.access IN('1,1,5')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmindex_mergepublished,newsfeedspublished,newsfeeds5,204NULL1Using intersect(published,newsfeeds); Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.26 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/components/com_xmap/displayer/html.php:312
    15XmapDisplayerHtml->getMenuTitle()JROOT/components/com_xmap/displayer/html.php:102
    14XmapDisplayerHtml->printSitemap()JROOT/components/com_xmap/views/html/tmpl/default.php:29
    13include JROOT/components/com_xmap/views/html/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    12Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    11Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_xmap/views/html/view.html.php:84
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.56 ms After last query: 2.20 ms Query memory: 0.027 MB Memory before query: 18.909 MB Rows returned: 1
    SELECT `introtext`,`fulltext`,`alias`,`catid`
    
      FROM `xvd3l_content`
      WHERE `id`=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    17JDatabaseDriver->loadObject()JROOT/plugins/xmap/com_content/com_content.php:268
    16xmap_com_content::getTree()JROOT/components/com_xmap/displayer/abstract.php:171
    15XmapDisplayerAbstract->printMenuTree()JROOT/components/com_xmap/displayer/html.php:105
    14XmapDisplayerHtml->printSitemap()JROOT/components/com_xmap/views/html/tmpl/default.php:29
    13include JROOT/components/com_xmap/views/html/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    12Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    11Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_xmap/views/html/view.html.php:84
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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.74 ms After last query: 7.16 ms Query memory: 0.089 MB Memory before query: 19.093 MB Rows returned: 1
    SELECT *
    
      FROM xvd3l_easyblog_configs
      WHERE `name` = 'config'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_easyblog_configsALLNULLNO INDEX KEY COULD BE USEDNULLNULL3Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.28 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    29JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1459
    28JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    27Joomla\CMS\Table\Table->load()JROOT/administrator/components/com_easyblog/includes/easyblog.php:492
    26EB::config()JROOT/components/com_easyblog/router.php:26
    25EasyBlogRouterBase::buildRoute()JROOT/components/com_easyblog/router.php:1149
    24EasyBlogBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    23Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:528
    22Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:498
    21Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:102
    18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:52
    17Joomla\CMS\Router\Route::_()JROOT/components/com_xmap/displayer/html.php:145
    16XmapDisplayerHtml->printNode()JROOT/components/com_xmap/displayer/abstract.php:161
    15XmapDisplayerAbstract->printMenuTree()JROOT/components/com_xmap/displayer/html.php:105
    14XmapDisplayerHtml->printSitemap()JROOT/components/com_xmap/views/html/tmpl/default.php:29
    13include JROOT/components/com_xmap/views/html/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    12Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    11Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_xmap/views/html/view.html.php:84
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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: 3.13 ms After last query: 4.44 ms Query memory: 0.006 MB Memory before query: 19.158 MB
    UPDATE xvd3l_xmap_sitemap
    
      SET views_html = views_html + 1 , count_html = '7' , lastvisit_html = '1614502434'
      WHERE id = '1'
    Explain
    EXPLAIN not possible on query: UPDATE xvd3l_xmap_sitemap SET views_html = views_html + 1 , count_html = '7' , lastvisit_html = '1614502434' WHERE id = '1'
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.06 ms
    Updating0.12 ms
    end0.01 ms
    Waiting for query cache lock0.01 ms
    end0.08 ms
    query end2.52 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/components/com_xmap/models/sitemap.php:138
    11XmapModelSitemap->hit()JROOT/components/com_xmap/views/html/view.html.php:86
    10XmapViewHtml->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_xmap/controller.php:37
    8XmapController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_xmap/xmap.php:19
    6require_once JROOT/components/com_xmap/xmap.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: 1.30 ms After last query: 13.57 ms Query memory: 0.027 MB Memory before query: 19.837 MB Rows returned: 4
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM xvd3l_modules AS m
      LEFT JOIN xvd3l_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN xvd3l_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-02-28 08:53:54')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-02-28 08:53:54')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 152 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const9Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4adityaic_joomla_test.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403adityaic_joomla_test.m.module,const1Using where
    Profile
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.03 ms
    init0.18 ms
    optimizing0.05 ms
    statistics0.10 ms
    preparing0.07 ms
    executing0.01 ms
    Sorting result0.21 ms
    Sending data0.25 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.08 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:581
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:95
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.59 ms After last query: 11.92 ms Query memory: 0.033 MB Memory before query: 20.436 MB Rows returned: 1
    SELECT * 
      FROM xvd3l_hikashop_category
      WHERE category_id = '2'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    16JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/helpers/helper.php:2069
    15hikashopClass->get()JROOT/administrator/components/com_hikashop/classes/category.php:38
    14hikashopCategoryClass->get()JROOT/components/com_hikashop/views/category/view.html.php:142
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.36 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 20.449 MB Rows returned: 1
    SELECT category_id 
      FROM xvd3l_hikashop_category
      WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
      AND category_type='product'
      AND category_id IN ('2')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.03 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    14JDatabaseDriver->loadColumn()JROOT/components/com_hikashop/views/category/view.html.php:173
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.40 ms After last query: 35.77 ms Query memory: 0.033 MB Memory before query: 23.127 MB Rows returned: 4
    SELECT a.* 
      FROM xvd3l_hikashop_category AS a
      WHERE a.category_parent_id = 2
      AND a.category_published=1
      AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
      ORDER BY a.category_ordering ASC
      LIMIT 0, 21
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL36Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.05 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/category.php:569
    14hikashopCategoryClass->getChildren()JROOT/components/com_hikashop/views/category/view.html.php:268
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.41 ms After last query: 0.08 ms Query memory: 0.028 MB Memory before query: 23.148 MB Rows returned: 4
    SELECT * 
      FROM xvd3l_hikashop_file
      WHERE file_type='category'
      AND file_ref_id IN (12,17,26,29)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_filereffile_typefile_type767const13Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/category.php:585
    14hikashopCategoryClass->getChildren()JROOT/components/com_hikashop/views/category/view.html.php:268
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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: 0.32 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 23.155 MB Rows returned: 1
    SELECT COUNT(*)  
      FROM xvd3l_hikashop_category AS a
      WHERE a.category_parent_id = 2
      AND a.category_published=1
      AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL36Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    14JDatabaseDriver->loadResult()JROOT/components/com_hikashop/views/category/view.html.php:273
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.43 ms After last query: 0.60 ms Query memory: 0.025 MB Memory before query: 23.196 MB Rows returned: 4
    SELECT category_left,category_right 
      FROM xvd3l_hikashop_category
      WHERE category_id IN (12,17,26,29)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryrangePRIMARYPRIMARY4NULL4Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.03 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/category.php:472
    14hikashopCategoryClass->getChildren()JROOT/components/com_hikashop/views/category/view.html.php:300
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.83 ms After last query: 0.11 ms Query memory: 0.036 MB Memory before query: 23.207 MB Rows returned: 9
    SELECT a.* 
      FROM xvd3l_hikashop_category AS a
      WHERE ((a.category_left > 3
      AND a.category_right < 10) OR (a.category_left > 11
      AND a.category_right < 16) OR (a.category_left > 17
      AND a.category_right < 22) OR (a.category_left > 23
      AND a.category_right < 28))
      AND a.category_published=1
      AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
      ORDER BY a.category_ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL36Using where; Using filesort
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.07 ms
    optimizing0.03 ms
    statistics0.02 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.11 ms
    Sending data0.19 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.08 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/category.php:569
    14hikashopCategoryClass->getChildren()JROOT/components/com_hikashop/views/category/view.html.php:300
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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: 2.28 ms After last query: 0.44 ms Query memory: 0.025 MB Memory before query: 23.241 MB Rows returned: 9
    SELECT count(pc.product_id) AS number_of_products, pc.category_id  
      FROM xvd3l_hikashop_product_category AS pc
      INNER JOIN xvd3l_hikashop_product AS p
      ON pc.product_id = p.product_id
      AND p.product_published > 0
      AND p.product_parent_id = 0
      WHERE pc.category_id IN (12,17,26,29,13,15,18,27,14,19,28,31,16)
      GROUP BY pc.category_id
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpcrangecategory_id,product_idcategory_id4NULL55Using where; Using index
    1SIMPLEpeq_refPRIMARY,product_parent_idPRIMARY4adityaic_joomla_test.pc.product_id1Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.09 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.01 ms
    Sending data1.67 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.07 ms
    logging slow query0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    14JDatabaseDriver->loadObjectList()JROOT/components/com_hikashop/views/category/view.html.php:327
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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: 1.04 ms After last query: 4.47 ms Query memory: 0.026 MB Memory before query: 23.554 MB Rows returned: 2
    SELECT a.id 
      FROM xvd3l_menu AS a
      INNER JOIN `xvd3l_menu_types` as b
      on a.menutype = b.menutype
      WHERE a.type='component'
      AND a.published=1
      AND b.title IS NOT NULL
      AND a.access IN (1,1,5)
      AND a.client_id=0
      AND a.link='index.php?option=com_hikashop&view=category&layout=listing'
      AND a.language IN ('*', '', 'en-GB')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_client_id_parent_id_alias_language,idx_menutype,idx_languageidx_client_id_parent_id_alias_language1const19Using where
    1SIMPLEbALLidx_menutypeNO INDEX KEY COULD BE USEDNULLNULL4Using where; Using join buffer
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.18 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.26 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    17JDatabaseDriver->loadColumn()JROOT/administrator/components/com_hikashop/classes/menus.php:276
    16hikashopMenusClass->loadAMenuItemId()JROOT/administrator/components/com_hikashop/helpers/helper.php:994
    15hikashop_contentLink()JROOT/components/com_hikashop/views/category/view.html.php:482
    14CategoryViewCategory->getLink()JROOT/components/com_hikashop/views/category/view.html.php:415
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:756
    11hikashop_getLayout()JROOT/modules/mod_hikashop/mod_hikashop.php:73
    10include JROOT/modules/mod_hikashop/mod_hikashop.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.37 ms After last query: 16.13 ms Query memory: 0.038 MB Memory before query: 24.312 MB Rows returned: 160
    SELECT * 
      FROM xvd3l_acymailing_config
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_acymailing_configALLNULLNO INDEX KEY COULD BE USEDNULLNULL160
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    14JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/compat/joomla.php:464
    13acymailing_loadObjectList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    12cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:434
    11acymailing_config()JROOT/administrator/components/com_acymailing/compat/joomla.php:803
    10include_once JROOT/administrator/components/com_acymailing/compat/joomla.phpJROOT/administrator/components/com_acymailing/helpers/helper.php:21
    9include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/plugins/system/regacymailing/regacymailing.php:22
    8plgSystemRegacymailing->initAcy()JROOT/plugins/system/regacymailing/regacymailing.php:146
    7plgSystemRegacymailing->onAfterRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1050
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 2 × SELECT s.* 
      FROM xvd3l_xmap_sitemap AS s
  2. 2 × SELECT `manifest_cache` 
      FROM `xvd3l_extensions`
  3. 2 × SELECT * 
      FROM xvd3l_languages
  4. 2 × SELECT a.* 
      FROM xvd3l_hikashop_category AS a
  5. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `xvd3l_assets`
  6. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `xvd3l_extensions`
  7. 1 × SELECT count(pc.product_id) AS number_of_products, pc.category_id  
      FROM xvd3l_hikashop_product_category AS pc
      INNER JOIN xvd3l_hikashop_product AS p
      ON pc.product_id = p.product_id
      AND p.product_published > 0
      AND p.product_parent_id = 0
  8. 1 × SELECT category_left,category_right 
      FROM xvd3l_hikashop_category
  9. 1 × SELECT a.id 
      FROM xvd3l_menu AS a
      INNER JOIN `xvd3l_menu_types` as b
      on a.menutype = b.menutype
  10. 1 × SELECT COUNT(*)  
      FROM xvd3l_hikashop_category AS a
  11. 1 × SELECT * 
      FROM xvd3l_hikashop_file
  12. 1 × SELECT `created`,`modified`,`introtext`,`fulltext` 
      FROM `xvd3l_content`
  13. 1 × SELECT category_id 
      FROM xvd3l_hikashop_category
  14. 1 × SELECT * 
      FROM xvd3l_hikashop_category
  15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM xvd3l_modules AS m
      LEFT JOIN xvd3l_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN xvd3l_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  16. 1 × SELECT * 
      FROM xvd3l_easyblog_configs
  17. 1 × SELECT `introtext`,`fulltext`,`alias`,`catid` 
      FROM `xvd3l_content`
  18. 1 × SELECT m.params,m.title 
      FROM xvd3l_modules AS m
  19. 1 × SELECT * 
      FROM xvd3l_assets
  20. 1 × SELECT `data` 
      FROM `xvd3l_session`
  21. 1 × SELECT e.element,e.folder,e.params 
      FROM xvd3l_extensions AS e
  22. 1 × SELECT * 
      FROM `xvd3l_admintools_ipautoban`
  23. 1 × SELECT id, rules 
      FROM `xvd3l_viewlevels
  24. 1 × SELECT b.id 
      FROM xvd3l_usergroups AS a
      LEFT JOIN xvd3l_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  25. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM xvd3l_extensions
  26. 1 × SELECT `value` 
      FROM `xvd3l_admintools_storage`
  27. 1 × SELECT * 
      FROM `xvd3l_admintools_wafexceptions`
  28. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM xvd3l_menu AS m
      LEFT JOIN xvd3l_extensions AS e
      ON m.component_id = e.extension_id
  29. 1 × SELECT `ip` 
      FROM `xvd3l_admintools_ipblock
  30. 1 × SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav` 
      FROM xvd3l_menu AS n
      INNER JOIN xvd3l_menu AS p
      ON p.lft = 0
  31. 1 × SELECT `source`,`keepurlparams` 
      FROM `xvd3l_admintools_redirects`
  32. 1 × SELECT * 
      FROM xvd3l_hikashop_confi
  33. 1 × SELECT `params` 
      FROM xvd3l_extensions
  34. 1 × SELECT * 
      FROM `xvd3l_admintools_wafblacklists`
  35. 1 × SELECT id, home, template, s.params 
      FROM xvd3l_template_styles as s
      LEFT JOIN xvd3l_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  36. 1 × SELECT `session_id` 
      FROM `xvd3l_session`
  37. 1 × SELECT * 
      FROM xvd3l_acymailing_confi
OTHER Tables:
  1. 1 × INSERT INTO `xvd3l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('336afab3226d073eb044a04b41766890', 1, 1614502434, 0, '', 0
  2. 1 × SHOW VARIABLES LIKE "collation_database
  3. 1 × UPDATE `xvd3l_extensions` 
      SET `params` = '{\"mediaversion\":\"730de712f54d3a55bcecd6e9eeb6ffe5\"}'
  4. 1 × SHOW FULL COLUMNS 
      FROM `xvd3l_assets
  5. 1 × UPDATE xvd3l_xmap_sitemap 
      SET views_html = views_html + 1 , count_html = '7' , lastvisit_html = '1614502434'