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

Warning: getimagesize(/home/adityaiconvmcom/public_html/images/com_hikashop/upload/badge_newproduct_16223.png): failed to open stream: No such file or directory in /home/adityaiconvmcom/public_html/administrator/components/com_hikashop/classes/badge.php on line 191
New product
AUD24.20 (24,20 €) each Orange sneakers
+
–
Add to cart
AUD21.45 (21,45 €) each Grey sneakers
+
–
Add to cart
AUD38.50 (38,50 €) each Slippers
+
–
Add to cart
Discount 10%
AUD17.60 (17,60 €) each Green slippers
+
–
Add to cart

Warning: getimagesize(/home/adityaiconvmcom/public_html/images/com_hikashop/upload/badge_newproduct_16223.png): failed to open stream: No such file or directory in /home/adityaiconvmcom/public_html/administrator/components/com_hikashop/classes/badge.php on line 191
New product
AUD10.89 (10,89 €) each Grey slippers
+
–
Add to cart
AUD28.60 (28,60 €) each Red sneakers
+
–
Add to cart
AUD17.60 (17,60 €) each Black shoes
+
–
Add to cart
AUD32.89 (32,89 €) each Blue sneakers
+
–
Add to cart
AUD27.50 (27,50 €) each Grey shoes
+
–
Add to cart
AUD37.40 (37,40 €) each Baby shoes
+
–
Add to cart
AUD17.60 (17,60 €) each Slippers
+
–
Add to cart
Discount 10%
AUD18.15 (18,15 €) each Blue baby shoes
+
–
Add to cart
Display #
Results 1 - 12 of 12
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

© 2019 Aditya Test site

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550745608,
                "last": 1550745608,
                "now": 1550745608
            },
            "token": "GGyjdGWkAZtgRszn6DSUmqIcPf2VM0Vi"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "13",
                "last_category_selected": 16
            }
        },
        "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: 24.99 ms / 24.99 ms Memory: 1.656 MB / 2.02 MB Application: afterLoad
Time: 405.10 ms / 430.09 ms Memory: 13.657 MB / 15.68 MB Application: afterInitialise
Time: 88.72 ms / 518.81 ms Memory: 1.835 MB / 17.51 MB Application: afterRoute
Time: 1.92 ms / 520.73 ms Memory: 0.029 MB / 17.54 MB Application: beforeRenderComponent com_hikashop
Time: 250.23 ms / 770.96 ms Memory: 7.927 MB / 25.47 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes1.png] does not exists (from: listing_img_title.php:33)
Time: 0.76 ms / 771.72 ms Memory: 0.003 MB / 25.47 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/badge_newproduct_16223.png] does not exists (from: badge.php:209)
Time: 38.56 ms / 810.28 ms Memory: 0.144 MB / 25.62 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes2.png] does not exists (from: listing_img_title.php:33)
Time: 5.94 ms / 816.22 ms Memory: 0.003 MB / 25.62 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes3.png] does not exists (from: listing_img_title.php:33)
Time: 3.11 ms / 819.32 ms Memory: 0.003 MB / 25.62 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes4.png] does not exists (from: listing_img_title.php:33)
Time: 0.21 ms / 819.53 ms Memory: 0.003 MB / 25.62 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/badge_discount10_2908.png] does not exists (from: badge.php:209)
Time: 222.26 ms / 1041.79 ms Memory: 0.037 MB / 25.66 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes5.png] does not exists (from: listing_img_title.php:33)
Time: 0.68 ms / 1042.46 ms Memory: 0.002 MB / 25.66 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/badge_newproduct_16223.png] does not exists (from: badge.php:209)
Time: 4.71 ms / 1047.17 ms Memory: 0.017 MB / 25.68 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes6.png] does not exists (from: listing_img_title.php:33)
Time: 3.21 ms / 1050.38 ms Memory: 0.003 MB / 25.68 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes7_876.png] does not exists (from: listing_img_title.php:33)
Time: 3.10 ms / 1053.48 ms Memory: 0.003 MB / 25.69 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes8.png] does not exists (from: listing_img_title.php:33)
Time: 3.08 ms / 1056.57 ms Memory: 0.003 MB / 25.69 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes9.png] does not exists (from: listing_img_title.php:33)
Time: 3.08 ms / 1059.65 ms Memory: 0.003 MB / 25.69 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes10.png] does not exists (from: listing_img_title.php:33)
Time: 3.13 ms / 1062.78 ms Memory: 0.019 MB / 25.71 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes11_6681.png] does not exists (from: listing_img_title.php:33)
Time: 3.24 ms / 1066.02 ms Memory: 0.003 MB / 25.71 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/shoes12.png] does not exists (from: listing_img_title.php:33)
Time: 0.22 ms / 1066.24 ms Memory: 0.002 MB / 25.72 MB Application: HikaShop image [/home/adityaiconvmcom/public_html/images/com_hikashop/upload/badge_discount10_2908.png] does not exists (from: badge.php:209)
Time: 4.11 ms / 1070.35 ms Memory: 0.000 MB / 25.19 MB Application: afterRenderComponent com_hikashop
Time: 8.95 ms / 1079.30 ms Memory: 0.404 MB / 25.59 MB Application: afterDispatch
Time: 6.23 ms / 1085.53 ms Memory: 0.208 MB / 25.80 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 20.52 ms / 1106.05 ms Memory: 0.083 MB / 25.88 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.08 ms / 1106.13 ms Memory: 0.001 MB / 25.89 MB Application: beforeRenderModule mod_hikashop (Categories on 2 levels)
Time: 10.60 ms / 1116.73 ms Memory: 0.139 MB / 26.02 MB Application: afterRenderModule mod_hikashop (Categories on 2 levels)
Time: 0.13 ms / 1116.86 ms Memory: 0.000 MB / 26.01 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 9.42 ms / 1126.29 ms Memory: 0.465 MB / 26.48 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 14.10 ms / 1140.38 ms Memory: 1.097 MB / 27.57 MB Application: afterRender

Database queries total: 53.69 ms

Memory Usage

28.54 MB (29,923,160 Bytes)

Database Queries

82 Queries Logged 53.69 ms


6 duplicate found!

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

  4. Query Time: 0.82 ms After last query: 50.15 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.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.38 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.01 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.26 ms After last query: 3.33 ms Query memory: 0.023 MB Memory before query: 4.329 MB Rows returned: 5
    SELECT id, rules
    
      FROM `xvd3l_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.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.34 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.341 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.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.01 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: 1.48 ms After last query: 0.86 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 USEDNULLNULL379Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    Sorting result0.43 ms
    Sending data0.73 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
    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.45 ms After last query: 15.05 ms Query memory: 0.024 MB Memory before query: 5.640 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.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.16 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php: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.40 ms After last query: 6.36 ms Query memory: 0.024 MB Memory before query: 5.937 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.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.15 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php: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.25 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.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 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: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.28 ms After last query: 2.98 ms Query memory: 0.024 MB Memory before query: 6.414 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.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 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.50 ms After last query: 86.14 ms Query memory: 0.040 MB Memory before query: 9.071 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.18 ms
    checking permissions0.02 ms
    checking permissions0.04 ms
    Opening tables0.05 ms
    System lock0.02 ms
    init0.10 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.27 ms
    Sending data0.39 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.01 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.99 ms After last query: 96.91 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.07 ms
    Opening tables0.09 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.43 ms
    Sending data0.02 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.02 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    12JDatabaseDriver->loadObject()JROOT/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.42 ms After last query: 0.72 ms Query memory: 0.024 MB Memory before query: 11.408 MB Rows returned: 0
    SELECT *
    
      FROM `xvd3l_admintools_ipautoban`
      WHERE `ip` = '54.173.237.152'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.07 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.09 ms Query memory: 0.023 MB Memory before query: 11.413 MB Rows returned: 0
    SELECT `ip`
    
      FROM `xvd3l_admintools_ipblock`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_ipblockALLNULLNO INDEX KEY COULD BE USEDNULLNULL1
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 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.57 ms After last query: 0.83 ms Query memory: 0.023 MB Memory before query: 11.439 MB Rows returned: 0
    SELECT `source`,`keepurlparams`
    
      FROM `xvd3l_admintools_redirects`
      WHERE ((`dest` = 'hikashop-menu-for-categories-listing/category/16-kids') OR (`dest` = 'hikashop-menu-for-categories-listing/category/16-kids') OR ('hikashop-menu-for-categories-listing/category/16-kids' LIKE `dest`))
      AND `published` = '1'
      ORDER BY `ordering` DESC
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_admintools_redirectsALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.03 ms
    init0.04 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.02 ms
    Sorting result0.06 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.71 ms After last query: 18.08 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.04 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.10 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
    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:2751
    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.76 ms After last query: 0.23 ms Query memory: 0.007 MB Memory before query: 12.855 MB
    UPDATE `xvd3l_extensions`
    
      SET `params` = '{\"mediaversion\":\"fb091cc1c02caf40064f3c5619baf1f2\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `xvd3l_extensions` SET `params` = '{\"mediaversion\":\"fb091cc1c02caf40064f3c5619baf1f2\"}' 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.15 ms
    end0.01 ms
    Waiting for query cache lock0.01 ms
    end0.02 ms
    query end2.21 ms
    closing tables0.03 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    15Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    14Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/administrator/components/com_hikashop/helpers/helper.php:2751
    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.75 ms After last query: 6.33 ms Query memory: 0.050 MB Memory before query: 13.516 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.02 ms
    checking permissions0.03 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.46 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    13JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/config.php:16
    12hikashopConfigClass->load()JROOT/administrator/components/com_hikashop/helpers/helper.php:1067
    11hikashop_config()JROOT/administrator/components/com_hikashop/helpers/helper.php:2770
    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.66 ms After last query: 58.07 ms Query memory: 0.028 MB Memory before query: 14.610 MB Rows returned: 2
    SELECT *
    
      FROM xvd3l_languages
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.03 ms
    Opening tables0.05 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.07 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 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.45 ms After last query: 12.27 ms Query memory: 0.024 MB Memory before query: 15.403 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.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php: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.05 ms After last query: 87.88 ms Query memory: 0.026 MB Memory before query: 17.354 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.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Creating tmp table0.38 ms
    executing0.01 ms
    Copying to tmp table0.09 ms
    Sorting result0.05 ms
    Sending data0.03 ms
    end0.01 ms
    removing tmp table0.10 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/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.37 ms After last query: 4.57 ms Query memory: 0.025 MB Memory before query: 17.514 MB Rows returned: 1
    SELECT *
    
      FROM xvd3l_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.41 ms After last query: 0.33 ms Query memory: 0.021 MB Memory before query: 17.534 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM xvd3l_template_styles as s
      LEFT JOIN xvd3l_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL4Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403adityaic_joomla_test.s.template,const1Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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.30 ms After last query: 6.09 ms Query memory: 0.033 MB Memory before query: 17.923 MB Rows returned: 1
    SELECT * 
      FROM xvd3l_menu
      WHERE id = '999'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.01 ms
    cleaning up0.01 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:2065
    17hikashopClass->get()JROOT/administrator/components/com_hikashop/classes/menus.php:20
    16hikashopMenusClass->get()JROOT/administrator/components/com_hikashop/helpers/module.php:222
    15hikashopModuleHelper->_getParams()JROOT/administrator/components/com_hikashop/helpers/module.php:14
    14hikashopModuleHelper->initialize()JROOT/components/com_hikashop/views/category/view.html.php:37
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.34 ms After last query: 0.47 ms Query memory: 0.008 MB Memory before query: 17.971 MB
    REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value) 
      VALUES ('menu_999','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30=')
    Explain
    EXPLAIN not possible on query: REPLACE INTO xvd3l_hikashop_config (config_namekey,config_value) VALUES ('menu_999','YTozNDp7czoxNDoiYm9yZGVyX3Zpc2libGUiO3M6MToiMiI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoxMjoiY29udGVudF90eXBlIjtzOjg6ImNhdGVnb3J5IjtzOjExOiJsYXlvdXRfdHlwZSI7czozOiJkaXYiO3M6NzoiY29sdW1ucyI7aTozO3M6NToibGltaXQiO3M6MjoiMjEiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE1OiJtb2R1bGVjbGFzc19zZngiO3M6MDoiIjtzOjc6Im1vZHVsZXMiO3M6MDoiIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTU6InVzZV9tb2R1bGVfbmFtZSI7czoxOiIwIjtzOjEzOiJwcm9kdWN0X29yZGVyIjtzOjg6Im9yZGVyaW5nIjtzOjY6InJhbmRvbSI7czoxOiIwIjtzOjE5OiJwcm9kdWN0X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6MTA6InNob3dfcHJpY2UiO3M6MToiMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMSI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIxIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6MTc6ImNhdGVnb3J5X29yZGVyaW5nIjtzOjE4OiJjaGlsZF9kaXNwbGF5X3R5cGUiO3M6Nzoibm9jaGlsZCI7czoxMToiY2hpbGRfbGltaXQiO3M6MDoiIjtzOjIwOiJkaXZfaXRlbV9sYXlvdXRfdHlwZSI7czo5OiJpbWdfdGl0bGUiO3M6MTc6ImRpdl9jdXN0b21fZmllbGRzIjtzOjA6IiI7czo2OiJoZWlnaHQiO3M6MzoiMTUwIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjc6IiNGRkZGRkYiO3M6NjoibWFyZ2luIjtzOjI6IjEwIjtzOjE1OiJyb3VuZGVkX2Nvcm5lcnMiO3M6MToiMSI7czoxMToidGV4dF9jZW50ZXIiO3M6MToiMSI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjE6IjAiO3M6MjA6ImxpbmtfdG9fcHJvZHVjdF9wYWdlIjtzOjE6IjEiO3M6MTQ6ImRpc3BsYXlfYmFkZ2VzIjtzOjE6IjEiO30=')
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    update0.14 ms
    Waiting for query cache lock0.01 ms
    update0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 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:227
    15hikashopModuleHelper->_getParams()JROOT/administrator/components/com_hikashop/helpers/module.php:14
    14hikashopModuleHelper->initialize()JROOT/components/com_hikashop/views/category/view.html.php:37
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.32 ms After last query: 3.12 ms Query memory: 0.033 MB Memory before query: 18.149 MB Rows returned: 1
    SELECT * 
      FROM xvd3l_hikashop_category
      WHERE category_id = '16'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    16JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/helpers/helper.php:2065
    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/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.30 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 18.163 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 ('16')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.43 ms After last query: 91.62 ms Query memory: 0.032 MB Memory before query: 20.856 MB Rows returned: 0
    SELECT a.* 
      FROM xvd3l_hikashop_category AS a
      WHERE a.category_parent_id = 16
      AND a.category_published=1
      AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')
      ORDER BY a.category_ordering ASC
      LIMIT 0, 21
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL36Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.05 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 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: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/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.35 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 20.863 MB Rows returned: 1
    SELECT COUNT(*)  
      FROM xvd3l_hikashop_category AS a
      WHERE a.category_parent_id = 16
      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.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 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/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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: 0.45 ms After last query: 2.93 ms Query memory: 0.037 MB Memory before query: 21.152 MB Rows returned: 1
    Duplicate queries: #39
    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 = 16
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbreffile_typefile_type767const13
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    15JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/classes/category.php:35
    14hikashopCategoryClass->get()JROOT/components/com_hikashop/views/category/view.html.php:345
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.93 ms After last query: 6.99 ms Query memory: 0.035 MB Memory before query: 21.695 MB Rows returned: 4
    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 = 16
      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.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Creating tmp table0.35 ms
    executing0.01 ms
    Copying to tmp table0.11 ms
    Sorting result0.03 ms
    Sending data0.06 ms
    end0.01 ms
    removing tmp table0.10 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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/field.php:408
    15hikashopFieldClass->getCategories()JROOT/administrator/components/com_hikashop/classes/field.php:145
    14hikashopFieldClass->getFields()JROOT/components/com_hikashop/views/category/view.html.php:349
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.41 ms After last query: 0.14 ms Query memory: 0.032 MB Memory before query: 21.724 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 '%,16,%'))OR (field_with_sub_categories = 1
      AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%' OR field_categories LIKE '%,16,%')))
      ORDER BY a.`field_ordering` ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL54Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.08 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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/category/view.html.php:349
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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: 0.29 ms After last query: 3.30 ms Query memory: 0.034 MB Memory before query: 21.898 MB Rows returned: 1
    Duplicate queries: #73
    SELECT * 
      FROM xvd3l_hikashop_category
      WHERE category_id = '2'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    17JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/helpers/helper.php:2065
    16hikashopClass->get()JROOT/administrator/components/com_hikashop/classes/category.php:38
    15hikashopCategoryClass->get()JROOT/administrator/components/com_hikashop/classes/category.php:697
    14hikashopCategoryClass->getParents()JROOT/components/com_hikashop/views/category/view.html.php:384
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.37 ms After last query: 0.08 ms Query memory: 0.033 MB Memory before query: 21.912 MB Rows returned: 3
    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 = 16
      AND hk_parent.category_left >= 2
      AND hk_parent.category_right <= 29
      GROUP BY hk_parent.category_id
      ORDER BY hk_parent.category_left
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhk_catconstPRIMARYPRIMARY4const1Using filesort
    1SIMPLEhk_parentALLNULLNO INDEX KEY COULD BE USEDNULLNULL36Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.04 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/category.php:725
    14hikashopCategoryClass->getParents()JROOT/components/com_hikashop/views/category/view.html.php:384
    13CategoryViewCategory->listing()JROOT/components/com_hikashop/views/category/view.html.php:25
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.66 ms After last query: 81.05 ms Query memory: 0.029 MB Memory before query: 23.736 MB Rows returned: 0
    SELECT cart.cart_id 
      FROM xvd3l_hikashop_cart AS cart
      WHERE (cart.cart_type = 'cart')
      AND (cart.session_id = 'e41b6fc37e12ad54ae96555390e62f54')
      ORDER BY cart.cart_current DESC, cart.cart_modified DESC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    System lock0.02 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    logging slow query0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    24JDatabaseDriver->loadResult()JROOT/administrator/components/com_hikashop/classes/cart.php:68
    23hikashopCartClass->getCurrentCartId()JROOT/administrator/components/com_hikashop/classes/cart.php:91
    22hikashopCartClass->get()JROOT/administrator/components/com_hikashop/helpers/helper.php:443
    21hikashop_getZone()JROOT/components/com_hikashop/views/product/view.html.php:499
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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: 0.58 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 23.747 MB Rows returned: 1
    SELECT category_id 
      FROM xvd3l_hikashop_category
      WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
      AND category_id IN ('16')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_categoryconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.06 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.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    21JDatabaseDriver->loadColumn()JROOT/components/com_hikashop/views/product/view.html.php:520
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  38. Query Time: 0.48 ms After last query: 6.79 ms Query memory: 0.033 MB Memory before query: 24.315 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.06 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.06 ms
    optimizing0.03 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.09 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    23JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/filter.php:293
    22hikashopFilterClass->getFilters()JROOT/components/com_hikashop/views/product/view.html.php:139
    21ProductViewProduct->filter()JROOT/components/com_hikashop/views/product/view.html.php:543
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  39. Query Time: 0.75 ms After last query: 0.19 ms Query memory: 0.041 MB Memory before query: 24.327 MB Rows returned: 1
    Duplicate queries: #31
    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 = 16
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbreffile_typefile_type767const13
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.18 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
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    22JDatabaseDriver->loadObject()JROOT/administrator/components/com_hikashop/classes/category.php:35
    21hikashopCategoryClass->get()JROOT/components/com_hikashop/views/product/view.html.php:546
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  40. Query Time: 0.93 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 24.345 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.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    System lock0.03 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.06 ms
    executing0.01 ms
    Sending data0.30 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
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    24JDatabaseDriver->loadColumn()JROOT/administrator/components/com_hikashop/classes/menus.php:276
    23hikashopMenusClass->loadAMenuItemId()JROOT/administrator/components/com_hikashop/classes/menus.php:206
    22hikashopMenusClass->getCheckoutURL()JROOT/administrator/components/com_hikashop/helpers/cart.php:254
    21hikashopCartHelper->getJS()JROOT/components/com_hikashop/views/product/view.html.php:719
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  41. Query Time: 4.29 ms After last query: 0.48 ms Query memory: 0.060 MB Memory before query: 24.359 MB Rows returned: 12
    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 (16))
      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_id4const7Using where; Using temporary; Using filesort
    1SIMPLEbeq_refPRIMARY,product_main_indexPRIMARY4adityaic_joomla_test.a.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.11 ms
    optimizing0.03 ms
    statistics0.23 ms
    preparing0.05 ms
    Creating tmp table1.49 ms
    executing0.01 ms
    Copying to tmp table1.30 ms
    Sorting result0.07 ms
    Sending data0.38 ms
    end0.01 ms
    removing tmp table0.19 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
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    21JDatabaseDriver->loadObjectList()JROOT/components/com_hikashop/views/product/view.html.php:800
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  42. Query Time: 0.83 ms After last query: 0.74 ms Query memory: 0.033 MB Memory before query: 24.478 MB Rows returned: 12
    SELECT * 
      FROM xvd3l_hikashop_file
      WHERE file_ref_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
      AND file_type IN ('product','file')
      ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_fileALLfile_typeNO INDEX KEY COULD BE USEDNULLNULL146Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.09 ms
    optimizing0.01 ms
    statistics0.12 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.14 ms
    Sending data0.17 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    22JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/product.php:1721
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  43. Query Time: 0.47 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 24.511 MB Rows returned: 0
    SELECT variant_product_id 
      FROM xvd3l_hikashop_variant
      WHERE variant_product_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_variantrangevariant_product_idvariant_product_id4NULL12Using where; Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.05 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    22JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/product.php:1742
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  44. Query Time: 0.60 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 24.522 MB Rows returned: 0
    SELECT product_id 
      FROM xvd3l_hikashop_product_related
      WHERE product_related_type = 'options'
      AND product_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_product_relatedindexPRIMARYPRIMARY775NULL17Using where; Using index
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.20 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    22JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/product.php:1758
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  45. Query Time: 1.21 ms After last query: 0.23 ms Query memory: 0.029 MB Memory before query: 24.536 MB Rows returned: 0
    SELECT product_parent_id, product_id 
      FROM xvd3l_hikashop_product
      WHERE product_parent_id IN ('18','19','20','21','22','23','24','25','26','27','28','29')
      AND product_published = 1
      AND product_type = 'variant'
      AND product_sale_start < 1550745608
      AND (product_sale_end > 1550745608 OR product_sale_end = 0)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_productrefproduct_parent_id,product_main_indexproduct_main_index767const41Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.17 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.66 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
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    25JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/currency.php:948
    24hikashopCurrencyClass->_loadProductVariants()JROOT/administrator/components/com_hikashop/classes/currency.php:509
    23hikashopCurrencyClass->getProductsPrices()JROOT/administrator/components/com_hikashop/classes/currency.php:471
    22hikashopCurrencyClass->getListingPrices()JROOT/administrator/components/com_hikashop/classes/product.php:1773
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  46. Query Time: 0.69 ms After last query: 0.24 ms Query memory: 0.041 MB Memory before query: 24.553 MB Rows returned: 0
    SELECT * 
      FROM xvd3l_hikashop_discount
      WHERE discount_type='discount'
      AND discount_published=1
      AND (discount_quota > discount_used_times OR discount_quota = 0)
      AND discount_start < 1550745608
      AND (discount_end > 1550745608 OR discount_end = 0)
      AND ( (discount_product_id IN ('','0','18','19','20','21','22','23','24','25','26','27','28','29')) OR (discount_product_id LIKE '%,18,%') OR (discount_product_id LIKE '%,19,%') OR (discount_product_id LIKE '%,20,%') OR (discount_product_id LIKE '%,21,%') OR (discount_product_id LIKE '%,22,%') OR (discount_product_id LIKE '%,23,%') OR (discount_product_id LIKE '%,24,%') OR (discount_product_id LIKE '%,25,%') OR (discount_product_id LIKE '%,26,%') OR (discount_product_id LIKE '%,27,%') OR (discount_product_id LIKE '%,28,%') OR (discount_product_id LIKE '%,29,%') )
      AND (discount_flat_amount != 0 OR discount_percent_amount != 0)
      AND (discount_flat_amount = 0 OR discount_currency_id =6)
      AND (discount_access = 'all' OR discount_access LIKE '%,9,%')
      AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    System lock0.02 ms
    init0.16 ms
    optimizing0.05 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    24JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/currency.php:551
    23hikashopCurrencyClass->getProductsPrices()JROOT/administrator/components/com_hikashop/classes/currency.php:471
    22hikashopCurrencyClass->getListingPrices()JROOT/administrator/components/com_hikashop/classes/product.php:1773
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  47. Query Time: 0.51 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 24.565 MB Rows returned: 3
    SELECT currency_id 
      FROM xvd3l_hikashop_currency
      WHERE currency_published=1 OR currency_id = 6
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLExvd3l_hikashop_currencyALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL182Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.02 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.17 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    25JDatabaseDriver->loadColumn()JROOT/administrator/components/com_hikashop/classes/currency.php:466
    24hikashopCurrencyClass->publishedCurrencies()JROOT/administrator/components/com_hikashop/classes/currency.php:559
    23hikashopCurrencyClass->getProductsPrices()JROOT/administrator/components/com_hikashop/classes/currency.php:471
    22hikashopCurrencyClass->getListingPrices()JROOT/administrator/components/com_hikashop/classes/product.php:1773
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  48. Query Time: 1.37 ms After last query: 0.26 ms Query memory: 0.034 MB Memory before query: 24.576 MB Rows returned: 12
    SELECT a.*, 
      CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id
      FROM xvd3l_hikashop_price AS a
      WHERE a.price_product_id IN (18,19,20,21,22,23,24,25,26,27,28,29)
      AND a.price_currency_id IN (1,2,6)
      AND a.price_start_date < 1550745608
      AND (a.price_end_date < 1 OR a.price_end_date > 1550745608)
      AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access))
      AND (a.price_users = '' OR a.price_users LIKE '%,0,%')
      ORDER BY a.price_site_id ASC, a.price_value DESC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarangeprice_product_idprice_product_id4NULL12Using where; Using filesort
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.07 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.30 ms
    executing0.01 ms
    Sorting result0.29 ms
    Sending data0.23 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    24JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_hikashop/classes/currency.php:577
    23hikashopCurrencyClass->getProductsPrices()JROOT/administrator/components/com_hikashop/classes/currency.php:471
    22hikashopCurrencyClass->getListingPrices()JROOT/administrator/components/com_hikashop/classes/product.php:1773
    21hikashopProductClass->loadProductsListingData()JROOT/components/com_hikashop/views/product/view.html.php:817
    20ProductViewProduct->listing()JROOT/components/com_hikashop/views/product/view.html.php:28
    19ProductViewProduct->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:752
    18hikashop_getLayout()JROOT/components/com_hikashop/views/category/tmpl/listing.php:129
    17include JROOT/components/com_hikashop/views/category/tmpl/listing.phpJROOT/libraries/src/MVC/View/HtmlView.php:697
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_hikashop/helpers/helper.php:2182
    15hikashopView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    14Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:2165
    13hikashopView->display()JROOT/components/com_hikashop/views/category/view.html.php:26
    12CategoryViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    11Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1903
    10hikashopController->display()JROOT/administrator/components/com_hikashop/helpers/helper.php:1640
    9hikashopController->listing()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/administrator/components/com_hikashop/helpers/helper.php:1881
    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.]

  49. Query Time: 0.45 ms After last query: 0.13 ms Query memory: 0.033 MB Memory before query: 24.607 MB Rows returned: 1