Let Our Material Handling Expertise Work For You

Valley Craft Industries, Inc. is a US manufacturer based in Lake City, Minnesota that builds material handling and storage solutions. In 1953, Carl Weinmann installed a brake on a hand truck to solve a common industry safety issue, and from there Valley Craft was born. Since then, we have established a culture of continuous improvement and innovation to resolve our customer's needs.

Become a Valley Craft Dealer

For 60 years, Valley Craft’s success has been based on a committed and highly educated dealer network that guides our customers to finding the best solution Valley Craft has to offer. If you are committed to providing the best products and best service, then we invite you to become a dealer by filling out the registration form below.
BECOME A DEALER

© 2013-2018 - Valley Craft Industries, Inc
2001 South Highway 61, Lake City, MN 55041
Phone: 651-345-3386 Fax: 651-345-6535

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563392021,
                "last": 1563392021,
                "now": 1563392021
            },
            "token": "mhFvdFQ3eFWKGS3YHr3FZMcqFbCF1tr9"
        },
        "registry": {
            "com_hikashop": {
                "user_id": 0,
                "zone_id": ""
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 6.07 ms / 6.07 ms Memory: 0.792 MB / 1.04 MB Application: afterLoad

Time: 59.99 ms / 66.06 ms Memory: 5.473 MB / 6.51 MB Application: afterInitialise

Time: 27.22 ms / 93.28 ms Memory: 1.439 MB / 7.95 MB Application: afterRoute

Time: 0.50 ms / 93.78 ms Memory: 0.045 MB / 7.99 MB Application: beforeRenderComponent com_content

Time: 1.45 ms / 95.23 ms Memory: 0.115 MB / 8.11 MB Application: Before Access::preloadComponents (all components)

Time: 0.45 ms / 95.68 ms Memory: 0.132 MB / 8.24 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 95.71 ms Memory: 0.000 MB / 8.23 MB Application: Before Access::preloadPermissions (com_content)

Time: 0.53 ms / 96.23 ms Memory: 0.259 MB / 8.49 MB Application: After Access::preloadPermissions (com_content)

Time: 0.04 ms / 96.28 ms Memory: 0.000 MB / 8.48 MB Application: Before Access::getAssetRules (id:174 name:com_content.article.15)

Time: 0.25 ms / 96.52 ms Memory: 0.019 MB / 8.50 MB Application: After Access::getAssetRules (id:174 name:com_content.article.15)

Time: 15.25 ms / 111.77 ms Memory: 1.261 MB / 9.76 MB Application: afterRenderComponent com_content

Time: 1.73 ms / 113.50 ms Memory: 0.053 MB / 9.81 MB Application: afterDispatch

Time: 5.10 ms / 118.60 ms Memory: 0.211 MB / 10.02 MB Application: beforeRenderModule mod_bdthemes_logo (Valley Craft Logo)

Time: 0.82 ms / 119.43 ms Memory: 0.015 MB / 10.04 MB Application: afterRenderModule mod_bdthemes_logo (Valley Craft Logo)

Time: 0.20 ms / 119.62 ms Memory: 0.023 MB / 10.06 MB Application: beforeRenderModule mod_jux_hk_megamenu (Mobile Category Mega Menu)

Time: 13.21 ms / 132.84 ms Memory: 1.494 MB / 11.55 MB Application: afterRenderModule mod_jux_hk_megamenu (Mobile Category Mega Menu)

Time: 0.28 ms / 133.11 ms Memory: 0.000 MB / 11.28 MB Application: beforeRenderModule mod_jux_hk_megamenu (New Category Mega Menu)

Time: 8.78 ms / 141.90 ms Memory: 1.329 MB / 12.61 MB Application: afterRenderModule mod_jux_hk_megamenu (New Category Mega Menu)

Time: 0.16 ms / 142.06 ms Memory: 0.000 MB / 12.33 MB Application: beforeRenderModule mod_universal_ajaxlivesearch (Main Product Search)

Time: 2.04 ms / 144.10 ms Memory: 0.108 MB / 12.44 MB Application: afterRenderModule mod_universal_ajaxlivesearch (Main Product Search)

Time: 0.19 ms / 144.29 ms Memory: 0.000 MB / 12.39 MB Application: beforeRenderModule mod_ajaxlivesearchresult (Search Results)

Time: 0.10 ms / 144.38 ms Memory: 0.009 MB / 12.40 MB Application: afterRenderModule mod_ajaxlivesearchresult (Search Results)

Time: 0.12 ms / 144.50 ms Memory: 0.002 MB / 12.40 MB Application: beforeRenderModule mod_custom (Valley Craft Blog Header)

Time: 1.88 ms / 146.38 ms Memory: 0.052 MB / 12.45 MB Application: afterRenderModule mod_custom (Valley Craft Blog Header)

Time: 0.17 ms / 146.56 ms Memory: 0.025 MB / 12.48 MB Application: beforeRenderModule mod_hikashop (Recently Viewed Items)

Time: 9.00 ms / 155.56 ms Memory: 1.347 MB / 13.83 MB Application: afterRenderModule mod_hikashop (Recently Viewed Items)

Time: 0.06 ms / 155.62 ms Memory: 0.000 MB / 13.77 MB Application: beforeRenderModule mod_custom (Valley Craft Story Images)

Time: 183.37 ms / 338.99 ms Memory: 0.016 MB / 13.79 MB Application: afterRenderModule mod_custom (Valley Craft Story Images)

Time: 0.06 ms / 339.04 ms Memory: 0.000 MB / 13.79 MB Application: beforeRenderModule mod_custom (Become a Valley Craft Dealer)

Time: 0.22 ms / 339.26 ms Memory: 0.007 MB / 13.80 MB Application: afterRenderModule mod_custom (Become a Valley Craft Dealer)

Time: 0.04 ms / 339.30 ms Memory: 0.000 MB / 13.80 MB Application: beforeRenderModule mod_custom (Become A Dealer Content)

Time: 0.81 ms / 340.11 ms Memory: 0.007 MB / 13.80 MB Application: afterRenderModule mod_custom (Become A Dealer Content)

Time: 0.12 ms / 340.23 ms Memory: 0.002 MB / 13.81 MB Application: beforeRenderModule mod_menu (Footer Menu 1)

Time: 1.61 ms / 341.84 ms Memory: 0.052 MB / 13.86 MB Application: afterRenderModule mod_menu (Footer Menu 1)

Time: 0.04 ms / 341.88 ms Memory: 0.000 MB / 13.85 MB Application: beforeRenderModule mod_custom (Copyright and Address)

Time: 0.21 ms / 342.09 ms Memory: 0.007 MB / 13.86 MB Application: afterRenderModule mod_custom (Copyright and Address)

Time: 0.04 ms / 342.12 ms Memory: 0.001 MB / 13.86 MB Application: beforeRenderModule mod_menu (Terms and Conditions Menu)

Time: 0.55 ms / 342.68 ms Memory: 0.034 MB / 13.89 MB Application: afterRenderModule mod_menu (Terms and Conditions Menu)

Time: 2.45 ms / 345.13 ms Memory: 0.100 MB / 13.99 MB Application: beforeRenderModule mod_custom (Contact Header Bar)

Time: 0.21 ms / 345.34 ms Memory: 0.007 MB / 14.00 MB Application: afterRenderModule mod_custom (Contact Header Bar)

Time: 0.23 ms / 345.58 ms Memory: 0.002 MB / 14.00 MB Application: beforeRenderModule mod_menu (Top Menu)

Time: 1.16 ms / 346.73 ms Memory: 0.078 MB / 14.08 MB Application: afterRenderModule mod_menu (Top Menu)

Time: 4.48 ms / 351.22 ms Memory: 0.092 MB / 14.17 MB Application: beforeRenderModule mod_custom (Right Footer)

Time: 0.21 ms / 351.42 ms Memory: 0.007 MB / 14.18 MB Application: afterRenderModule mod_custom (Right Footer)

Time: 254.61 ms / 606.04 ms Memory: 0.653 MB / 14.83 MB Application: afterRender

Database queries total: 67.20 ms

Memory Usage

Database Queries

120 Queries Logged 67.20 ms

80 duplicate found!

2 duplicates: #28 #67

2 duplicates: #29 #68

2 duplicates: #30 #69

2 duplicates: #31 #70

2 duplicates: #32 #71

2 duplicates: #33 #72

2 duplicates: #34 #73

2 duplicates: #35 #74

2 duplicates: #36 #75

2 duplicates: #37 #76

2 duplicates: #38 #77

2 duplicates: #39 #78

2 duplicates: #40 #79

2 duplicates: #41 #80

2 duplicates: #42 #81

2 duplicates: #43 #82

2 duplicates: #44 #83

2 duplicates: #45 #84

2 duplicates: #46 #85

2 duplicates: #47 #86

2 duplicates: #48 #87

2 duplicates: #49 #88

2 duplicates: #50 #89

2 duplicates: #51 #90

2 duplicates: #52 #91

2 duplicates: #53 #92

2 duplicates: #54 #93

2 duplicates: #55 #94

2 duplicates: #56 #95

2 duplicates: #57 #96

2 duplicates: #58 #97

2 duplicates: #59 #98

2 duplicates: #60 #99

2 duplicates: #61 #100

2 duplicates: #62 #101

2 duplicates: #63 #102

2 duplicates: #64 #103

2 duplicates: #65 #104

2 duplicates: #66 #105

2 duplicates: #108 #115

Query Time: 1.17 ms Query memory: 0.021 MB Memory before query: 1.577 MB Rows returned: 0

SELECT `data`

  FROM `vci_session`

  WHERE `session_id` = 'i7rdbe1bjgdtmaetrhk1ppp6q2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1873	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.88 ms After last query: 0.41 ms Query memory: 0.013 MB Memory before query: 1.633 MB Rows returned: 0

SELECT `session_id`

  FROM `vci_session`

  WHERE `session_id` = 'i7rdbe1bjgdtmaetrhk1ppp6q2' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1873	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.73 ms After last query: 0.10 ms Query memory: 0.010 MB Memory before query: 1.649 MB

INSERT INTO `vci_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('i7rdbe1bjgdtmaetrhk1ppp6q2', 1, 1563392021, 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `vci_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('i7rdbe1bjgdtmaetrhk1ppp6q2', 1, 1563392021, 0, '')

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.47 ms After last query: 0.67 ms Query memory: 0.028 MB Memory before query: 1.726 MB Rows returned: 61

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `vci_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.70 ms Query memory: 0.015 MB Memory before query: 1.857 MB Rows returned: 9

SELECT id, rules

  FROM `vci_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.04 ms After last query: 0.11 ms Query memory: 0.015 MB Memory before query: 1.884 MB Rows returned: 2

SELECT b.id

  FROM vci_usergroups AS a

  LEFT JOIN vci_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	19	Using where
1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	19	Using where; Using join buffer (flat, BNL join)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.63 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 1.923 MB Rows returned: 188

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM vci_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5,7,8,9)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.42 ms After last query: 8.18 ms Query memory: 0.013 MB Memory before query: 3.399 MB Rows returned: 1

SELECT `enabled`

  FROM `vci_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:74
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 11.04 ms Query memory: 0.020 MB Memory before query: 3.890 MB Rows returned: 26

SELECT *

  FROM vci_rsform_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_rsform_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	26

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
12	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
11	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
10	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 2.26 ms Query memory: 0.028 MB Memory before query: 4.375 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `vci_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
21	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
20	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
17	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
16	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
15	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3941
11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:180
10	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:62
9	plgSystemHikashopgeolocation->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.25 ms After last query: 0.20 ms Query memory: 0.020 MB Memory before query: 4.385 MB

UPDATE `vci_extensions`

  SET `params` = '{\"mediaversion\":\"ca5a1d5b713309379c2e409f7a15f562\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `vci_extensions` SET `params` = '{\"mediaversion\":\"ca5a1d5b713309379c2e409f7a15f562\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
16	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
15	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3941
11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:180
10	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:62
9	plgSystemHikashopgeolocation->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 9.56 ms After last query: 3.08 ms Query memory: 0.270 MB Memory before query: 5.709 MB Rows returned: 8188

SELECT * 
  FROM vci_hikashop_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_hikashop_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8188

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
13	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1120
12	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3958
11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:180
10	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:62
9	plgSystemHikashopgeolocation->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.60 ms After last query: 12.33 ms Query memory: 0.035 MB Memory before query: 6.589 MB Rows returned: 46

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 vci_menu AS m

  LEFT JOIN vci_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	292	Using where; Using temporary; Using filesort
1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where; Using join buffer (flat, BNL join)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.50 ms After last query: 6.33 ms Query memory: 0.027 MB Memory before query: 7.187 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM vci_template_styles as s

  LEFT JOIN vci_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where
1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where; Using join buffer (flat, BNL join)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
20	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
19	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
18	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
13	JHtmlBehavior::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/browserupdatewarning/browserupdatewarning.php:65
9	plgSystemBrowserUpdateWarning->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 13.41 ms Query memory: 0.014 MB Memory before query: 7.968 MB Rows returned: 1

SELECT *

  FROM vci_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 1.88 ms Query memory: 0.027 MB Memory before query: 8.118 MB Rows returned: 61

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `vci_assets`

  WHERE `name` IN ('root.1','com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_fields','com_associations','com_privacy','com_actionlogs','com_rsform','com_rseventspro','com_hikashop','com_phocadownload','com_acymailing','com_akeeba','com_jce','com_universal_ajax_live_search','com_uniterevolution2','com_bdthemes_shortcodes','com_fastseller','com_j2xml','com_jxtceasyimage','com_projectfork','com_pfprojects','com_pfmilestones','com_pftasks','com_pftime','com_pfrepo','com_pfforum','com_pfusers','com_pfcomments','com_securitycheck','com_osmap','com_jantivirus','com_f2cimport','com_oscontent')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_assets	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	448	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.27 ms Query memory: 0.031 MB Memory before query: 8.234 MB Rows returned: 161

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `vci_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_assets	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	448	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.57 ms After last query: 0.88 ms Query memory: 0.026 MB Memory before query: 8.520 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `vci_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `vci_content`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.39 ms After last query: 1.12 ms Query memory: 0.024 MB Memory before query: 8.664 MB Rows returned: 1

SELECT *

  FROM vci_content

  WHERE `id` = '15'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_content	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	114	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.06 ms After last query: 0.13 ms Query memory: 0.014 MB Memory before query: 8.679 MB

UPDATE vci_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '15'

Explain

EXPLAIN not possible on query: UPDATE vci_content SET `hits` = (`hits` + 1) WHERE `id` = '15'

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.64 ms After last query: 0.43 ms Query memory: 0.028 MB Memory before query: 8.728 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM vci_content AS a

  INNER JOIN vci_categories AS c 
  on c.id = a.catid

  LEFT JOIN vci_users AS u 
  on u.id = a.created_by

  LEFT JOIN vci_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN vci_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 15 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-07-17 19:33:41') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-17 19:33:41') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	Using where
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	114	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	u	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	v	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.92 ms Query memory: 0.024 MB Memory before query: 8.824 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `vci_contentitem_tag_map` AS m 

  INNER JOIN `vci_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 15 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5,7,8,9)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	17	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.37 ms After last query: 1.43 ms Query memory: 0.020 MB Memory before query: 9.080 MB Rows returned: 1

SELECT MAX(ordering)

  FROM `vci_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
13	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.020 MB Memory before query: 9.100 MB Rows returned: 1

SELECT `ordering`

  FROM `vci_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content' 
  AND `element` = 'perfect_everything_in_everyway'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.23 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
13	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.94 ms Query memory: 0.034 MB Memory before query: 9.213 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `vci_categories` AS `s`

  INNER JOIN `vci_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5,7,8,9) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	Using where; Using temporary; Using filesort
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.09 ms After last query: 0.28 ms Query memory: 0.032 MB Memory before query: 9.275 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM vci_fields AS a

  LEFT JOIN `vci_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN vci_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN vci_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN vci_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN vci_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `vci_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5,7,8,9) 
  AND (a.group_id = 0 OR g.access IN (1,1,5,7,8,9)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using temporary; Using filesort
1	SIMPLE	l	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	fc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.06 ms After last query: 7.41 ms Query memory: 0.039 MB Memory before query: 9.903 MB Rows returned: 36

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM vci_modules AS m

  LEFT JOIN vci_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN vci_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-07-17 19:33:41') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-17 19:33:41') 
  AND m.access IN (1,1,5,7,8,9) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	265	Using where; Using temporary; Using filesort
1	SIMPLE	mm	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	327	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	509	Using where; Using join buffer (incremental, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.13 ms
Copying to tmp table	3.33 ms
Sorting result	0.07 ms
Sending data	0.03 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
Waiting for query cache lock	0.00 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/kirion/layouts/theme.config.php:29
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 2.74 ms Query memory: 0.034 MB Memory before query: 10.179 MB Rows returned: 1

Duplicate queries: #67

SELECT * 
  FROM vci_menu 
  WHERE id = '172' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	292	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2089
19	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:20
18	hikashopMenusClass->get()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:211
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.17 ms Query memory: 0.033 MB Memory before query: 10.220 MB Rows returned: 1

Duplicate queries: #68

SELECT * 
  FROM vci_menu 
  WHERE id = '475' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	292	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2089
19	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:20
18	hikashopMenusClass->get()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:211
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.15 ms Query memory: 0.033 MB Memory before query: 10.266 MB Rows returned: 1

Duplicate queries: #69

SELECT * 
  FROM vci_menu 
  WHERE id = '620' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vci_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	292	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2089
19	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:20
18	hikashopMenusClass->get()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:206
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 10.295 MB Rows returned: 35

Duplicate queries: #70

SELECT c.category_id AS id,c.category_name AS name,c.category_alias AS alias,c.category_parent_id AS parent

  FROM vci_hikashop_category AS c

  WHERE c.category_published=1 
  AND c.category_type = 'product' 
  AND c.category_id != 2

  ORDER BY c.category_ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	57	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:107
18	HKMegamenu->fetchCategory()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:219
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 2.32 ms Query memory: 0.027 MB Memory before query: 10.529 MB Rows returned: 1

Duplicate queries: #71

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 37

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.08 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 10.559 MB Rows returned: 1

Duplicate queries: #72

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 74

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.589 MB Rows returned: 1

Duplicate queries: #73

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 47

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.618 MB Rows returned: 1

Duplicate queries: #74

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 78

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.647 MB Rows returned: 1

Duplicate queries: #75

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 80

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.676 MB Rows returned: 1

Duplicate queries: #76

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 120

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.705 MB Rows returned: 1

Duplicate queries: #77

SELECT COUNT(*)

  FROM vci_hikashop_product AS p

  INNER JOIN vci_hikashop_product_category AS pc 
  ON pc.product_id = p.product_id

  WHERE p.product_published = 1 
  AND pc.category_id = 79

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	808	Using where
1	SIMPLE	p	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1569	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:181
18	HKMegamenu->getCountItem()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:267
17	HKMegamenu->parseMenu()	JROOT/modules/mod_jux_hk_megamenu/includes/menu/hk_megamenu.php:342
16	HKMegamenu->render()	JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php:26
15	require JROOT/modules/mod_jux_hk_megamenu/tmpl/default.php	JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php:67
14	include JROOT/modules/mod_jux_hk_megamenu/mod_jux_hk_megamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/kirion/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/kirion/layouts/theme.config.php:77
10	include JROOT/templates/kirion/layouts/theme.config.php	JROOT/templates/kirion/layouts/theme.php:9
9	include JROOT/templates/kirion/layouts/theme.php	JROOT/templates/kirion/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/kirion/index.php:16
7	require JROOT/templates/kirion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.735 MB Rows returned: 1