Aditya Test site
Toggle Navigation
  • Home
  • Blog
  • login
  • form
  • Categories listing
  • Products listing
  • cart
HikaShop , Joomla!® E-Commerce Extension

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": 1614507793,
                "last": 1614507793,
                "now": 1614507793
            },
            "token": "eVJuMDvthzrc5MhtxkhWEaFh9E7fKVUR"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "13"
            }
        },
        "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.55 ms / 22.55 ms Memory: 1.656 MB / 2.02 MB Application: afterLoad
Time: 215.57 ms / 238.12 ms Memory: 13.667 MB / 15.69 MB Application: afterInitialise
Time: 35.28 ms / 273.40 ms Memory: 1.963 MB / 17.65 MB Application: afterRoute
Time: 2.27 ms / 275.67 ms Memory: 0.020 MB / 17.67 MB Application: beforeRenderComponent com_hikashop
Time: 102.26 ms / 377.92 ms Memory: 6.373 MB / 24.04 MB Application: afterRenderComponent com_hikashop
Time: 11.90 ms / 389.82 ms Memory: 0.599 MB / 24.64 MB Application: afterDispatch
Time: 5.36 ms / 395.18 ms Memory: 0.140 MB / 24.78 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 4.05 ms / 399.23 ms Memory: 0.118 MB / 24.90 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.09 ms / 399.32 ms Memory: 0.001 MB / 24.90 MB Application: beforeRenderModule mod_hikashop (Categories on 2 levels)
Time: 16.52 ms / 415.84 ms Memory: 0.277 MB / 25.18 MB Application: afterRenderModule mod_hikashop (Categories on 2 levels)
Time: 0.19 ms / 416.03 ms Memory: 0.000 MB / 25.16 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 10.10 ms / 426.13 ms Memory: 0.526 MB / 25.69 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 14.74 ms / 440.87 ms Memory: 0.965 MB / 26.66 MB Application: afterRender

Database queries total: 44.78 ms

Memory Usage

27.24 MB (28,565,504 Bytes)

Database Queries

48 Queries Logged 44.78 ms


4 duplicate found!

2 duplicates: #8  #9
2 duplicates: #27  #38
  1. Query Time: 0.79 ms Query memory: 0.025 MB Memory before query: 3.710 MB Rows returned: 0
    SELECT `data`
    
      FROM `xvd3l_session`
      WHERE `session_id` = '57087d8a122e8c74d42ca886a0b6c1c4'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.12 ms
    Opening tables0.03 ms
    System lock0.03 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.16 ms
    preparing0.01 ms
    executing0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.07 ms
    logging slow query0.00 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.44 ms After last query: 1.68 ms Query memory: 0.022 MB Memory before query: 3.875 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `xvd3l_session`
      WHERE `session_id` = '57087d8a122e8c74d42ca886a0b6c1c4'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.01 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
    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.87 ms After last query: 0.11 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 ('57087d8a122e8c74d42ca886a0b6c1c4', 1, 1614507793, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `xvd3l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('57087d8a122e8c74d42ca886a0b6c1c4', 1, 1614507793, 0, '', 0)
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.04 ms
    update0.27 ms
    Waiting for query cache lock0.01 ms
    update0.03 ms
    end0.01 ms
    query end2.19 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 1.11 ms After last query: 3.48 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.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.04 ms
    statistics0.13 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.64 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.48 ms After last query: 3.11 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.07 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    logging slow query0.01 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.62 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.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.05 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: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: 2.65 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.12 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.86 ms
    Sending data1.23 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
    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.64 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.01 ms
    cleaning up0.03 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.76 ms After last query: 6.20 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.02 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.30 ms
    end0.02 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
    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.41 ms After last query: 0.38 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.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.07 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
    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.41 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.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.05 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
    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.43 ms After last query: 39.26 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.13 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    Opening tables0.07 ms
    System lock0.02 ms
    init0.07 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.30 ms
    Sending data0.52 ms
    end0.01 ms
    query end0.01 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.97 ms After last query: 48.13 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.05 ms
    Opening tables0.08 ms
    System lock0.02 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.40 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.03 ms
    closing tables0.01 ms
    freeing items0.06 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/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.52 ms After last query: 0.69 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.03 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.09 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/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.414 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.02 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.50 ms After last query: 0.87 ms Query memory: 0.023 MB Memory before query: 11.439 MB Rows returned: 0
    SELECT `source`,`keepurlparams`
    
      FROM `xvd3l_admintools_redirects`
      WHERE ((`dest` = 'cart/product/listing') OR (`dest` = 'cart/product/listing') OR ('cart/product/listing' 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.05 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.08 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.69 ms After last query: 18.31 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.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.09 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
    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.90 ms After last query: 0.24 ms Query memory: 0.007 MB Memory before query: 12.855 MB
    UPDATE `xvd3l_extensions`
    
      SET `params` = '{\"mediaversion\":\"0c53f7b5a2b414340a0d6071edd5948e\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `xvd3l_extensions` SET `params` = '{\"mediaversion\":\"0c53f7b5a2b414340a0d6071edd5948e\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.12 ms
    Updating0.13 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end0.01 ms
    query end2.43 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.85 ms After last query: 6.62 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.04 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.06 ms
    Sending data0.46 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
    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.61 ms After last query: 8.32 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.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.03 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.08 ms
    Sending data0.08 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
    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.66 ms After last query: 11.13 ms Query memory: 0.024 MB Memory before query: 15.414 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.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.16 ms
    preparing0.01 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.70 ms After last query: 34.37 ms Query memory: 0.026 MB Memory before query: 17.492 MB Rows returned: 1
    SELECT *
    
      FROM `xvd3l_admintools_wafblacklists`
      WHERE `verb` IN('','GET')
      AND `option` IN('','com_hikashop')
      AND `view` IN('')
      AND `task` IN('','listing','.listing')
      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.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.06 ms
    optimizing0.03 ms
    statistics0.07 ms
    preparing0.01 ms
    Creating tmp table0.68 ms
    executing0.01 ms
    Copying to tmp table0.17 ms
    Sorting result0.06 ms
    Sending data0.07 ms
    end0.01 ms
    removing tmp table0.16 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
    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.52 ms After last query: 3.88 ms Query memory: 0.025 MB Memory before query: 17.652 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.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.08 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
    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.65 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 17.663 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.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.13 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
    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: 0.58 ms After last query: 11.66 ms Query memory: 0.033 MB Memory before query: 18.404 MB Rows returned: 1
    SELECT * 
      FROM xvd3l_menu
      WHERE id = '1014'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.04 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.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    18JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/helpers/helper.php:2069
    17hikashopClass->get()JROOT/administrator/components/com_hikashop/classes/menus.php:20
    16hikashopMenusClass->get()JROOT/administrator/components/com_hikashop/helpers/module.php:229
    15hikashopModuleHelper->_getParams()JROOT/administrator/components/com_hikashop/helpers/module.php:14
    14hikashopModuleHelper->initialize()JROOT/components/com_hikashop/views/product/view.html.php:176
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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.45 ms After last query: 0.39 ms Query memory: 0.008 MB Memory before query: 18.444 MB
    REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value) 
      VALUES ('menu_1014','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30=')
    Explain
    EXPLAIN not possible on query: REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value) VALUES ('menu_1014','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30=')
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    update0.18 ms
    Waiting for query cache lock0.01 ms
    update0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/administrator/components/com_hikashop/classes/config.php:131
    17hikashopConfigClass->save()JROOT/administrator/components/com_hikashop/classes/menus.php:468
    16hikashopMenusClass->createMenuOption()JROOT/administrator/components/com_hikashop/helpers/module.php:234
    15hikashopModuleHelper->_getParams()JROOT/administrator/components/com_hikashop/helpers/module.php:14
    14hikashopModuleHelper->initialize()JROOT/components/com_hikashop/views/product/view.html.php:176
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.59 ms After last query: 19.86 ms Query memory: 0.033 MB Memory before query: 19.942 MB Rows returned: 1
    Duplicate queries: #38
    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.06 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 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: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/product/view.html.php:448
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.84 ms After last query: 12.17 ms Query memory: 0.026 MB Memory before query: 20.739 MB Rows returned: 0
    SELECT cart.cart_id 
      FROM xvd3l_hikashop_cart AS cart
      WHERE (cart.cart_type = 'cart')
      AND (cart.session_id = '57087d8a122e8c74d42ca886a0b6c1c4')
      ORDER BY cart.cart_current DESC, cart.cart_modified DESC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcartrefsession_idsession_id767const1Using where; Using filesort
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.22 ms
    preparing0.04 ms
    executing0.04 ms
    Sorting result0.08 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:1734
    17JDatabaseDriver->loadResult()JROOT/administrator/components/com_hikashop/classes/cart.php:68
    16hikashopCartClass->getCurrentCartId()JROOT/administrator/components/com_hikashop/classes/cart.php:91
    15hikashopCartClass->get()JROOT/administrator/components/com_hikashop/helpers/helper.php:447
    14hikashop_getZone()JROOT/components/com_hikashop/views/product/view.html.php:499
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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.54 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 20.748 MB Rows returned: 1
    SELECT category_id 
      FROM xvd3l_hikashop_category
      WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
      AND category_id IN ('2')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.02 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    14JDatabaseDriver->loadColumn()JROOT/components/com_hikashop/views/product/view.html.php:520
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.50 ms After last query: 6.93 ms Query memory: 0.030 MB Memory before query: 21.312 MB Rows returned: 0
    SELECT * 
      FROM xvd3l_hikashop_filter
      WHERE filter_published = 1
      AND (filter_access = 'all' OR filter_access LIKE '%,9,%')
      ORDER BY filter_ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.04 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/filter.php:293
    15hikashopFilterClass->getFilters()JROOT/components/com_hikashop/views/product/view.html.php:139
    14ProductViewProduct->filter()JROOT/components/com_hikashop/views/product/view.html.php:543
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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: 1.71 ms After last query: 0.12 ms Query memory: 0.034 MB Memory before query: 21.323 MB Rows returned: 2
    SELECT hk_parent.* 
      FROM xvd3l_hikashop_category AS hk_cat
      LEFT JOIN xvd3l_hikashop_category AS hk_parent
      ON (hk_parent.category_left <= hk_cat.category_left
      AND hk_parent.category_right >= hk_cat.category_right)
      WHERE hk_cat.category_id = 2
      GROUP BY hk_parent.category_id
      ORDER BY hk_parent.category_left
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhk_catconstPRIMARYPRIMARY4const1Using temporary; Using filesort
    1SIMPLEhk_parentALLNULLNO INDEX KEY COULD BE USEDNULLNULL36
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.02 ms
    Creating tmp table0.68 ms
    executing0.01 ms
    Copying to tmp table0.19 ms
    Sorting result0.05 ms
    Sending data0.09 ms
    end0.01 ms
    removing tmp table0.16 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    17JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/category.php:725
    16hikashopCategoryClass->getParents()JROOT/administrator/components/com_hikashop/classes/filter.php:313
    15hikashopFilterClass->getFilters()JROOT/components/com_hikashop/views/product/view.html.php:139
    14ProductViewProduct->filter()JROOT/components/com_hikashop/views/product/view.html.php:543
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.84 ms After last query: 0.13 ms Query memory: 0.037 MB Memory before query: 21.336 MB Rows returned: 1
    SELECT a.*,b.* 
      FROM xvd3l_hikashop_category AS a
      LEFT JOIN xvd3l_hikashop_file AS b
      ON a.category_id = b.file_ref_id
      AND b.file_type = 'category'
      WHERE a.category_id = 2
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbreffile_typefile_type767const13
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.29 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    15JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/classes/category.php:35
    14hikashopCategoryClass->get()JROOT/components/com_hikashop/views/product/view.html.php:546
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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.85 ms After last query: 0.32 ms Query memory: 0.027 MB Memory before query: 21.356 MB Rows returned: 1
    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=checkout&layout=show'
      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.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.03 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.05 ms
    executing0.01 ms
    Sending data0.24 ms
    end0.02 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
    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/classes/menus.php:206
    15hikashopMenusClass->getCheckoutURL()JROOT/administrator/components/com_hikashop/helpers/cart.php:254
    14hikashopCartHelper->getJS()JROOT/components/com_hikashop/views/product/view.html.php:719
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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: 2.66 ms After last query: 34.40 ms Query memory: 0.044 MB Memory before query: 23.842 MB Rows returned: 0
    SELECT DISTINCT b.* 
      FROM xvd3l_hikashop_product_category AS a
      LEFT JOIN xvd3l_hikashop_product AS b
      ON a.product_id=b.product_id
      WHERE (b.product_published = 1)
      AND (b.product_type = 'main')
      AND (a.category_id IN (2))
      AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%'))
      ORDER BY a.ordering ASC
      LIMIT 0, 21
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefcategory_id,product_idcategory_id4const1Using where; Using temporary; Using filesort
    1SIMPLEbeq_refPRIMARY,product_main_indexPRIMARY4adityaic_joomla_test.a.product_id1Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    System lock0.01 ms
    init0.09 ms
    optimizing0.04 ms
    statistics0.22 ms
    preparing0.05 ms
    Creating tmp table1.32 ms
    executing0.01 ms
    Copying to tmp table0.06 ms
    Sorting result0.03 ms
    Sending data0.09 ms
    end0.01 ms
    removing tmp table0.25 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.07 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()JROOT/components/com_hikashop/views/product/view.html.php:800
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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.80 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 23.851 MB Rows returned: 1
    SELECT COUNT( DISTINCT b.product_id ) 
      FROM xvd3l_hikashop_product_category AS a
      LEFT JOIN xvd3l_hikashop_product AS b
      ON a.product_id=b.product_id
      WHERE (b.product_published = 1)
      AND (b.product_type = 'main')
      AND (a.category_id IN (2))
      AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%'))
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefcategory_id,product_idcategory_id4const1
    1SIMPLEbeq_refPRIMARY,product_main_indexPRIMARY4adityaic_joomla_test.a.product_id1Using where
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.06 ms
    optimizing0.04 ms
    statistics0.16 ms
    preparing0.02 ms
    executing0.06 ms
    Sending data0.03 ms
    end0.01 ms
    removing tmp table0.01 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    14JDatabaseDriver->loadResult()JROOT/components/com_hikashop/views/product/view.html.php:845
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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.68 ms After last query: 2.40 ms Query memory: 0.031 MB Memory before query: 24.004 MB Rows returned: 0
    SELECT * 
      FROM xvd3l_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='category'
      AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')
      AND ((field_with_sub_categories = 0
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories = 1
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%')))
      ORDER BY a.`field_ordering` ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL54Using where; Using filesort
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.08 ms
    optimizing0.06 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.14 ms
    Sending data0.04 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/administrator/components/com_hikashop/classes/field.php:126
    15hikashopFieldClass->getData()JROOT/administrator/components/com_hikashop/classes/field.php:146
    14hikashopFieldClass->getFields()JROOT/components/com_hikashop/views/product/view.html.php:873
    13ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    12ProductViewProduct->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1907
    10hikashopController->display()JROOT/components/com_hikashop/controllers/product.php:42
    9productController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1885
    7hikashopController->execute()JROOT/components/com_hikashop/hikashop.php:92
    6require_once JROOT/components/com_hikashop/hikashop.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: 1.32 ms After last query: 17.53 ms Query memory: 0.027 MB Memory before query: 24.781 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 10:23:14')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-02-28 10:23:14')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 1014 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.07 ms
    System lock0.02 ms
    init0.08 ms
    optimizing0.05 ms
    statistics0.13 ms
    preparing0.08 ms
    executing0.01 ms
    Sorting result0.20 ms
    Sending data0.28 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.06 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.]

  38. Query Time: 0.55 ms After last query: 8.93 ms Query memory: 0.033 MB Memory before query: 25.106 MB Rows returned: 1
    Duplicate queries: #27
    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.06 ms
    preparing0.02 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.]

  39. Query Time: 0.53 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 25.119 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.08 ms
    checking permissions0.06 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.02 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 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.]

  40. Query Time: 0.63 ms After last query: 0.23 ms Query memory: 0.033 MB Memory before query: 25.129 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.06 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.07 ms
    optimizing0.04 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.13 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 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: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.]

  41. Query Time: 0.57 ms After last query: 0.11 ms Query memory: 0.028 MB Memory before query: 25.150 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.03 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.22 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: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.]

  42. Query Time: 0.46 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 25.158 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.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.09 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
    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.]

  43. Query Time: 0.36 ms After last query: 0.65 ms Query memory: 0.025 MB Memory before query: 25.198 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.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.02 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: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.]

  44. Query Time: 1.29 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 25.209 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.10 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.08 ms
    optimizing0.03 ms
    statistics0.02 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.10 ms
    Sending data0.19 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: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.]

  45. Query Time: 2.33 ms After last query: 0.46 ms Query memory: 0.025 MB Memory before query: 25.243 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.05 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.09 ms
    executing0.02 ms
    Sorting result0.01 ms
    Sending data1.66 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
    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.]

  46. Query Time: 0.81 ms After last query: 0.29 ms Query memory: 0.026 MB Memory before query: 25.258 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.06 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.05 ms
    executing0.01 ms
    Sending data0.23 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
    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.]

  47. Query Time: 0.40 ms After last query: 10.19 ms Query memory: 0.087 MB Memory before query: 25.590 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.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.17 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
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1459
    23JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    22Joomla\CMS\Table\Table->load()JROOT/administrator/components/com_easyblog/includes/easyblog.php:492
    21EB::config()JROOT/components/com_easyblog/router.php:26
    20EasyBlogRouterBase::buildRoute()JROOT/components/com_easyblog/router.php:1149
    19EasyBlogBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    18Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:528
    17Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:498
    16Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:102
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:52
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_menu/helper.php:139
    11ModMenuHelper::getList()JROOT/modules/mod_menu/mod_menu.php:15
    10include JROOT/modules/mod_menu/mod_menu.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.69 ms After last query: 13.21 ms Query memory: 0.038 MB Memory before query: 26.371 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.05 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.21 ms
    end0.01 ms
    query end0.02 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: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.]

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 2 × SELECT * 
      FROM xvd3l_hikashop_category
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `xvd3l_extensions`
  3. 2 × SELECT `manifest_cache` 
      FROM `xvd3l_extensions`
  4. 2 × SELECT a.id 
      FROM xvd3l_menu AS a
      INNER JOIN `xvd3l_menu_types` as b
      on a.menutype = b.menutype
  5. 2 × SELECT * 
      FROM xvd3l_languages
  6. 2 × SELECT a.* 
      FROM xvd3l_hikashop_category AS a
  7. 2 × SELECT category_id 
      FROM xvd3l_hikashop_category
  8. 1 × SELECT DISTINCT b.* 
      FROM xvd3l_hikashop_product_category AS a
      LEFT JOIN xvd3l_hikashop_product AS b
      ON a.product_id=b.product_id
  9. 1 × SELECT * 
      FROM xvd3l_hikashop_filter
  10. 1 × SELECT hk_parent.* 
      FROM xvd3l_hikashop_category AS hk_cat
      LEFT JOIN xvd3l_hikashop_category AS hk_parent
      ON (hk_parent.category_left <= hk_cat.category_left
      AND hk_parent.category_right >= hk_cat.category_right)
  11. 1 × SELECT a.*,b.* 
      FROM xvd3l_hikashop_category AS a
      LEFT JOIN xvd3l_hikashop_file AS b
      ON a.category_id = b.file_ref_id
      AND b.file_type = 'category'
  12. 1 × SELECT `data` 
      FROM `xvd3l_session`
  13. 1 × SELECT COUNT( DISTINCT b.product_id ) 
      FROM xvd3l_hikashop_product_category AS a
      LEFT JOIN xvd3l_hikashop_product AS b
      ON a.product_id=b.product_id
  14. 1 × SELECT * 
      FROM xvd3l_hikashop_field as a
  15. 1 × SELECT * 
      FROM xvd3l_hikashop_file
  16. 1 × SELECT COUNT(*)  
      FROM xvd3l_hikashop_category AS a
  17. 1 × SELECT category_left,category_right 
      FROM xvd3l_hikashop_category
  18. 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
  19. 1 × SELECT * 
      FROM xvd3l_easyblog_configs
  20. 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
  21. 1 × SELECT * 
      FROM xvd3l_menu
  22. 1 × SELECT cart.cart_id 
      FROM xvd3l_hikashop_cart AS cart
  23. 1 × SELECT `session_id` 
      FROM `xvd3l_session`
  24. 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
  25. 1 × SELECT * 
      FROM `xvd3l_admintools_wafblacklists`
  26. 1 × SELECT `params` 
      FROM xvd3l_extensions
  27. 1 × SELECT * 
      FROM xvd3l_hikashop_confi
  28. 1 × SELECT `source`,`keepurlparams` 
      FROM `xvd3l_admintools_redirects`
  29. 1 × SELECT `ip` 
      FROM `xvd3l_admintools_ipblock
  30. 1 × SELECT * 
      FROM `xvd3l_admintools_ipautoban`
  31. 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
  32. 1 × SELECT * 
      FROM `xvd3l_admintools_wafexceptions`
  33. 1 × SELECT `value` 
      FROM `xvd3l_admintools_storage`
  34. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM xvd3l_extensions
  35. 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
  36. 1 × SELECT id, rules 
      FROM `xvd3l_viewlevels
  37. 1 × SELECT * 
      FROM xvd3l_acymailing_confi
OTHER Tables:
  1. 1 × INSERT INTO `xvd3l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('57087d8a122e8c74d42ca886a0b6c1c4', 1, 1614507793, 0, '', 0
  2. 1 × SHOW VARIABLES LIKE "collation_database
  3. 1 × UPDATE `xvd3l_extensions` 
      SET `params` = '{\"mediaversion\":\"0c53f7b5a2b414340a0d6071edd5948e\"}'
  4. 1 × REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value) 
      VALUES ('menu_1014','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30='