No accepted currencies defined
No Shop Currency defined! Contact the administrator, if you are one go to https://test.qprinstitute.com/administrator/index.php?option=com_virtuemart&view=user&task=editshop
Online course pricing is based on World Bank Development Indicators. To calculate the cost of one or more courses, simply find your country in Zone 1, 2, 3, or 4, and apply the discount rate.
Notes:
Learn about the QPR Gatekeeper Instructor Certification Training - International Version
How to purchase a course:
If you would like to purchase course accounts in bulk, send the name of the course(s), together with your estimated payment in an email to Ms. Kathy White @ qinsitute@qwestoffice.net for payment directions.
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1761457558,
"last": 1761457558,
"now": 1761457558
},
"token": "pUMD2R4Iej2PkJGyIAQKxuvoEa80EHE9"
},
"registry": {
"com_fabrik": {
"package": "fabrik"
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"com_fabrik": {
"form": {
"12": {
"data": {
"formid": "12",
"option": "com_fabrik",
"view": "form",
"Itemid": null,
"ark_inine_enabled": false
}
}
}
},
"fabrik": {
"js": {
"scripts": null,
"jlayouts": null,
"shim": null,
"config": null,
"head": {
"scripts": null,
"cache": {
"1ba5e565c8f81fbcc83d07510e1565f2": "{\"\\\/media\\\/system\\\/js\\\/mootools-core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/system\\\/js\\\/core-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/mootools-more-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-noconflict.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/jui\\\/js\\\/jquery-migrate.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/bootstrap\\\/js\\\/bootstrap.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\\/media\\\/com_fabrik\\\/js\\\/lib\\\/jquery-ui\\\/jquery-ui.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/calendar-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/calendar-setup-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/polyfill.event-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"conditional\":\"lt IE 9\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/media\\\/system\\\/js\\\/keepalive-uncompressed.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/jquery.tap.min.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/script.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/menu.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/jquery.inview.min.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/jquery.parallax-1.1.3.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/jquery.placeholder.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/templates\\\/uber\\\/js\\\/script.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"\\\/plugins\\\/system\\\/t3\\\/base-bs3\\\/js\\\/nav-collapse.js\":{\"type\":\"text\\\/javascript\",\"options\":[]},\"https:\\\/\\\/test.qprinstitute.com\\\/media\\\/editors\\\/arkeditor\\\/js\\\/jquery.easing.min.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"https:\\\/\\\/test.qprinstitute.com\\\/media\\\/editors\\\/arkeditor\\\/js\\\/squeezebox.min.js\":{\"type\":\"text\\\/javascript\",\"options\":{\"framework\":false,\"relative\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/jquery-ui.min.js?vmver=1.9.2\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/jquery.ui.autocomplete.html.js\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/jquery.noconflict.js\":{\"mime\":\"text\\\/javascript\",\"async\":true,\"options\":[]},\"\\\/modules\\\/mod_virtuemart_cart\\\/assets\\\/js\\\/update_cart.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/chosen.jquery.min.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/vmprices.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"defer\":true,\"options\":[]},\"\\\/components\\\/com_virtuemart\\\/assets\\\/js\\\/vmsite.js?vmver=b5d132d7\":{\"mime\":\"text\\\/javascript\",\"options\":[]}}"
}
}
},
"clearCanonical": null
}
},
"__vm": {
"vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false}"
}
}
SELECT `data`
FROM `jgpqv_session`
WHERE `session_id` = 'b0c606d480f107db677777552ffbb255'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_session | const | PRIMARY | PRIMARY | 766 | const | 1 |
| Status | Duration |
|---|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 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:764 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 |
| 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:352 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `jgpqv_session`
WHERE `session_id` = 'b0c606d480f107db677777552ffbb255'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:161 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:766 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 |
| 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:352 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `jgpqv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('b0c606d480f107db677777552ffbb255', 1, '1761457558', 0, '', 0)
| Status | Duration |
|---|---|
| Starting | 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 |
| init for update | 0.01 ms |
| Update | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.46 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | 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:161 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:766 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 |
| 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:352 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jgpqv_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_extensions | ref | extension | extension | 82 | const | 45 | Using index condition |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:423 |
| 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:431 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
| 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:596 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `jgpqv_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 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:310 |
| 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:606 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM jgpqv_usergroups AS a
LEFT JOIN jgpqv_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 14
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 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:310 |
| 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:606 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jgpqv_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 422 | Using where; Using filesort |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 0.40 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 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:348 |
| 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:606 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT count(1)
FROM `jgpqv_session`
WHERE `session_id` = ''
AND client_id = 1
AND guest = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/arktypography/arktypography.php:53 |
| 9 | plgSystemARKtypography->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:632 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 jgpqv_menu AS m
LEFT JOIN jgpqv_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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 98 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | qprtest_qpr_courses.m.component_id | 1 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.04 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.38 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:383 |
| 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:497 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1079 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jgpqv_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | 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/LibraryHelper.php:175 |
| 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/arktypography/arktypography.php:115 |
| 9 | plgSystemARKtypography->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:1089 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `jgpqv_extensions`
SET `params` = '{\"mediaversion\":\"f0e75fda481419934de0b22a55074ede\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| Status | Duration |
|---|---|
| Starting | 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 |
| init for update | 0.03 ms |
| Updating | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.15 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/arktypography/arktypography.php:115 |
| 9 | plgSystemARKtypography->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:1089 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT params
FROM `jgpqv_extensions`
WHERE `element` = 'com_arkeditor'
AND `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/arktypography/arktypography.php:127 |
| 9 | plgSystemARKtypography->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:1089 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM jgpqv_template_styles as s
LEFT JOIN jgpqv_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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | qprtest_qpr_courses.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 11 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/t3/includes/core/t3.php:320 |
| 10 | T3::detect() | JROOT/plugins/system/t3/t3.php:81 |
| 9 | plgSystemT3->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:1089 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jgpqv_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 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:204 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jgpqv_modules AS m
LEFT JOIN jgpqv_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jgpqv_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 <= '2025-10-26 05:45:58')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-26 05:45:58')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 37 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | qprtest_qpr_courses.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | qprtest_qpr_courses.m.id | 2 | Using where; Using index |
| Status | Duration |
|---|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.28 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | 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/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
| 13 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 11 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
| 10 | T3Template->countModules() | JROOT/templates/uber/tpls/default-bookstore.php:18 |
| 9 | include JROOT/templates/uber/tpls/default-bookstore.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
| 8 | T3Template->loadLayout() | JROOT/templates/uber/index.php:34 |
| 7 | require JROOT/templates/uber/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:1036 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW TABLES LIKE "jgpqv_virtuemart_configs"
| Status | Duration |
|---|---|
| Starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| checking permissions | 0.58 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:717 |
| 13 | VmTable::checkTableExists() | JROOT/administrator/components/com_virtuemart/models/config.php:573 |
| 12 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:940 |
| 11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:14 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `config`
FROM `jgpqv_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_configs | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 12 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:988 |
| 11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:14 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jgpqv_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_arkeditor','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dashboard','com_fabrik','com_finder','com_installer','com_jaextmanager','com_jce','com_jlms_certificates','com_jlmsvm_integration','com_joomla_lms','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsappt_pro3','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_wrapper','com_zoo')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 171 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1349 |
| 13 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:643 |
| 12 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1010 |
| 11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:14 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `jgpqv_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_shoppergroups | ref | virtuemart_vendor_id,shared,published | published | 1 | const | 2 | Using where |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102 |
| 15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
| 14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
| 13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
| 12 | VirtueMartModelUser->getCurrentUser() | JROOT/components/com_virtuemart/helpers/cart.php:133 |
| 11 | VirtueMartCart::getCart() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `jgpqv_virtuemart_shoppergroups`.*
FROM `jgpqv_virtuemart_shoppergroups`
WHERE `jgpqv_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_shoppergroups | const | PRIMARY | PRIMARY | 4 | const | 1 |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1036 |
| 18 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 |
| 17 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52 |
| 16 | VirtueMartModelShopperGroup->getShopperGroup() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107 |
| 15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
| 14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
| 13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
| 12 | VirtueMartModelUser->getCurrentUser() | JROOT/components/com_virtuemart/helpers/cart.php:133 |
| 11 | VirtueMartCart::getCart() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `jgpqv_virtuemart_currencies` AS c
LEFT JOIN `jgpqv_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 19 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/vendor.php:264 |
| 18 | VirtueMartModelVendor::getVendorCurrency() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 |
| 17 | CurrencyDisplay->__construct() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103 |
| 16 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `jgpqv_virtuemart_userfields`
| Status | Duration |
|---|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| closing tables | 0.00 ms |
| Opening tables | 0.23 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.07 ms |
| closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.07 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 26 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:678 |
| 25 | VmTable->showFullColumns() | JROOT/administrator/components/com_virtuemart/tables/userfields.php:43 |
| 24 | TableUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:221 |
| 23 | VmTable::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434 |
| 22 | VmModel->_createTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396 |
| 21 | VmModel->getTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602 |
| 20 | VmModel->setMainTable() | JROOT/administrator/components/com_virtuemart/models/userfields.php:52 |
| 19 | VirtueMartModelUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554 |
| 18 | VmModel::getModel() | JROOT/components/com_virtuemart/helpers/cart.php:256 |
| 17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
| 16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `jgpqv_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_userfields | ALL | published,account | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where; Using filesort |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.10 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 |
| 20 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:619 |
| 19 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:504 |
| 18 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:267 |
| 17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
| 16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `fieldtitle`, `fieldvalue`
FROM `jgpqv_virtuemart_userfield_values`
WHERE `virtuemart_userfield_id` = 23
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_userfield_values | ref | virtuemart_userfield_id | virtuemart_userfield_id | 4 | const | 2 | Using where; Using filesort |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 |
| 19 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:1044 |
| 18 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:272 |
| 17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
| 16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `jgpqv_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_countries | ALL | published | NO INDEX KEY COULD BE USED | NULL | NULL | 246 | Using where; Using filesort |
| Status | Duration |
|---|---|
| Starting | 0.01 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.26 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859 |
| 21 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/country.php:113 |
| 20 | VirtueMartModelCountry->getCountries() | JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146 |
| 19 | shopFunctionsF::renderCountryList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:857 |
| 18 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:272 |
| 17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
| 16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `jgpqv_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_virtuemart_userfields | ALL | published,shipment | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where; Using filesort |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 |
| 20 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:619 |
| 19 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:510 |
| 18 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:267 |
| 17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
| 16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.*
FROM jgpqv_virtuemart_calcs as c
LEFT JOIN jgpqv_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-26 05:45:58" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-26 05:45:58" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.04 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 |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 17 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172 |
| 16 | calculationHelper->setVendorId() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 |
| 15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
| 14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jgpqv_virtuemart_calcs
LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-26 05:45:58" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-26 05:45:58" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 16 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 |
| 15 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:740 |
| 14 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1565 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jgpqv_virtuemart_calcs
LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-26 05:45:58" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-26 05:45:58" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 16 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 |
| 15 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:741 |
| 14 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1565 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jgpqv_virtuemart_calcs
LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-10-26 05:45:58" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-26 05:45:58" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 16 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351 |
| 15 | calculationHelper->gatherEffectingRulesForBill() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:742 |
| 14 | calculationHelper->getCheckoutPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1565 |
| 13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
| 12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
| 11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT p.`virtuemart_product_id`
FROM `jgpqv_virtuemart_products` as p
LEFT JOIN `jgpqv_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jgpqv_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jgpqv_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ((p.`product_parent_id` > "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`product_special`="1"
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND()
LIMIT 0, 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.04 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 |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 18 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855 |
| 17 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:772 |
| 16 | VirtueMartModelProduct->sortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:1732 |
| 15 | VirtueMartModelProduct->getProductListing() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:33 |
| 14 | mod_virtuemart_product_helper::getProductsListing() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:89 |
| 10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT p.`virtuemart_product_id`
FROM `jgpqv_virtuemart_products` as p
LEFT JOIN `jgpqv_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jgpqv_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jgpqv_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ((p.`product_parent_id` > "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`product_special`="1"
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND()
LIMIT 0, 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.03 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855 |
| 13 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:772 |
| 12 | VirtueMartModelProduct->sortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:1732 |
| 11 | VirtueMartModelProduct->getProductListing() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:101 |
| 10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `vendor_accepted_currencies`, `vendor_currency`
FROM `jgpqv_virtuemart_vendors`
WHERE `virtuemart_vendor_id`=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.01 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 12 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/models/currency.php:110 |
| 11 | VirtueMartModelCurrency->getVendorAcceptedCurrrenciesList() | JROOT/modules/mod_virtuemart_currencies/mod_virtuemart_currencies.php:45 |
| 10 | include JROOT/modules/mod_virtuemart_currencies/mod_virtuemart_currencies.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug, mc.`mf_category_name`,mmex.virtuemart_media_id
FROM `jgpqv_virtuemart_manufacturers` as m
LEFT JOIN `jgpqv_virtuemart_manufacturers_en_gb` as l
ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id`
LEFT JOIN `jgpqv_virtuemart_manufacturercategories_en_gb` AS mc
on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id`
LEFT JOIN `jgpqv_virtuemart_manufacturer_medias` as mmex
ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`
WHERE `m`.`published` = 1
GROUP BY `m`.`virtuemart_manufacturer_id`
ORDER BY mf_name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859 |
| 12 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/manufacturer.php:185 |
| 11 | VirtueMartModelManufacturer->getManufacturers() | JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php:30 |
| 10 | include JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jgpqv_lms_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_lms_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 153 |
| Status | Duration |
|---|---|
| Starting | 0.01 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 |
| init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_joomla_lms/includes/classes/lms.config.php:55 |
| 18 | JLMS_Config->initConfig() | JROOT/components/com_joomla_lms/includes/classes/lms.config.php:10 |
| 17 | JLMS_Config->__construct() | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:75 |
| 16 | JLMSFactory::_createConfig() | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17 |
| 15 | JLMSFactory::getConfig() | Same as call in the line below. |
| 14 | call_user_func() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:220 |
| 13 | LMS\Libraries\ServiceLocator::getService() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:71 |
| 12 | LMS\Libraries\ServiceLocator::get() | JROOT/modules/mod_jlms_menu/helper.php:18 |
| 11 | ModJlmsMenuHelper::getList() | JROOT/modules/mod_jlms_menu/mod_jlms_menu.php:6 |
| 10 | include JROOT/modules/mod_jlms_menu/mod_jlms_menu.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT cb_assoc AS profile_var, CONCAT('lms_cb_assoc', id) AS var_name, field_name AS lang_var
FROM jgpqv_lms_cb_assoc
ORDER BY id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_lms_cb_assoc | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | Const row not found |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.00 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_joomla_lms/legacy/includes/config_inc_base.php:95 |
| 18 | LMS\Legacy\Includes\Config_Inc_Base::init() | JROOT/components/com_joomla_lms/includes/config.inc.php:9 |
| 17 | require JROOT/components/com_joomla_lms/includes/config.inc.php | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:76 |
| 16 | JLMSFactory::_createConfig() | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17 |
| 15 | JLMSFactory::getConfig() | Same as call in the line below. |
| 14 | call_user_func() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:220 |
| 13 | LMS\Libraries\ServiceLocator::getService() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:71 |
| 12 | LMS\Libraries\ServiceLocator::get() | JROOT/modules/mod_jlms_menu/helper.php:18 |
| 11 | ModJlmsMenuHelper::getList() | JROOT/modules/mod_jlms_menu/mod_jlms_menu.php:6 |
| 10 | include JROOT/modules/mod_jlms_menu/mod_jlms_menu.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `session_id`
FROM `jgpqv_session`
WHERE `session_id` = 'b0c606d480f107db677777552ffbb255'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|---|
| Starting | 0.01 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 26 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 25 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:161 |
| 24 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:766 |
| 23 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:144 |
| 22 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 21 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/components/com_joomla_lms/includes/classes/lms.config.php:86 |
| 20 | JLMS_Config->getItemid() | JROOT/components/com_joomla_lms/includes/classes/lms.config.php:142 |
| 19 | JLMS_Config->get() | JROOT/components/com_joomla_lms/legacy/includes/config_inc_base.php:174 |
| 18 | LMS\Legacy\Includes\Config_Inc_Base::init() | JROOT/components/com_joomla_lms/includes/config.inc.php:9 |
| 17 | require JROOT/components/com_joomla_lms/includes/config.inc.php | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:76 |
| 16 | JLMSFactory::_createConfig() | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17 |
| 15 | JLMSFactory::getConfig() | Same as call in the line below. |
| 14 | call_user_func() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:220 |
| 13 | LMS\Libraries\ServiceLocator::getService() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:71 |
| 12 | LMS\Libraries\ServiceLocator::get() | JROOT/modules/mod_jlms_menu/helper.php:18 |
| 11 | ModJlmsMenuHelper::getList() | JROOT/modules/mod_jlms_menu/mod_jlms_menu.php:6 |
| 10 | include JROOT/modules/mod_jlms_menu/mod_jlms_menu.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id
FROM jgpqv_menu
WHERE link LIKE '%index.php?option=com_joomla_lms%'
AND type = 'component'
AND published = 1
AND client_id = 0
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jgpqv_menu | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 99 | Using where |
| Status | Duration |
|---|---|
| Starting | 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 |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Caller | File and line number |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 21 | JDatabaseDriver->loadResult() | JROOT/components/com_joomla_lms/includes/classes/lms.config.php:122 |
| 20 | JLMS_Config->getItemid() | JROOT/components/com_joomla_lms/includes/classes/lms.config.php:142 |
| 19 | JLMS_Config->get() | JROOT/components/com_joomla_lms/legacy/includes/config_inc_base.php:174 |
| 18 | LMS\Legacy\Includes\Config_Inc_Base::init() | JROOT/components/com_joomla_lms/includes/config.inc.php:9 |
| 17 | require JROOT/components/com_joomla_lms/includes/config.inc.php | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:76 |
| 16 | JLMSFactory::_createConfig() | JROOT/components/com_joomla_lms/includes/classes/lms.factory.php:17 |
| 15 | JLMSFactory::getConfig() | Same as call in the line below. |
| 14 | call_user_func() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:220 |
| 13 | LMS\Libraries\ServiceLocator::getService() | JROOT/components/com_joomla_lms/libraries/servicelocator.php:71 |
| 12 | LMS\Libraries\ServiceLocator::get() | JROOT/modules/mod_jlms_menu/helper.php:18 |
| 11 | ModJlmsMenuHelper::getList() | JROOT/modules/mod_jlms_menu/mod_jlms_menu.php:6 |
| 10 | include JROOT/modules/mod_jlms_menu/mod_jlms_menu.php | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT *
FROM jgpqv_virtuemart_calcs
LEFT JOIN jgpqv_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
2 × SELECT p.`virtuemart_product_id`
FROM `jgpqv_virtuemart_products` as p
LEFT JOIN `jgpqv_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jgpqv_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jgpqv_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
2 × SELECT *
FROM `jgpqv_virtuemart_userfields`
2 × SELECT `session_id`
FROM `jgpqv_session`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jgpqv_extensions`
1 × SELECT c.*
FROM jgpqv_virtuemart_calcs as c
LEFT JOIN jgpqv_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id
1 × SELECT `fieldtitle`, `fieldvalue`
FROM `jgpqv_virtuemart_userfield_values`
1 × SELECT *
FROM `jgpqv_virtuemart_currencies` AS c
LEFT JOIN `jgpqv_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
1 × SELECT *
FROM `jgpqv_virtuemart_countries`
1 × SELECT `vendor_accepted_currencies`, `vendor_currency`
FROM `jgpqv_virtuemart_vendors`
1 × SELECT id
FROM jgpqv_menu
1 × SELECT cb_assoc AS profile_var, CONCAT('lms_cb_assoc', id) AS var_name, field_name AS lang_var
FROM jgpqv_lms_cb_assoc
1 × SELECT *
FROM jgpqv_lms_confi
1 × SELECT `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug, mc.`mf_category_name`,mmex.virtuemart_media_id
FROM `jgpqv_virtuemart_manufacturers` as m
LEFT JOIN `jgpqv_virtuemart_manufacturers_en_gb` as l
ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id`
LEFT JOIN `jgpqv_virtuemart_manufacturercategories_en_gb` AS mc
on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id`
LEFT JOIN `jgpqv_virtuemart_manufacturer_medias` as mmex
ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`
1 × SELECT `jgpqv_virtuemart_shoppergroups`.*
FROM `jgpqv_virtuemart_shoppergroups`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jgpqv_assets`
1 × SELECT count(1)
FROM `jgpqv_session`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jgpqv_menu AS m
LEFT JOIN jgpqv_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jgpqv_extensions
1 × SELECT b.id
FROM jgpqv_usergroups AS a
LEFT JOIN jgpqv_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jgpqv_viewlevels
1 × SELECT params
FROM `jgpqv_extensions`
1 × SELECT id, home, template, s.params
FROM jgpqv_template_styles as s
LEFT JOIN jgpqv_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `data`
FROM `jgpqv_session`
1 × SELECT `config`
FROM `jgpqv_virtuemart_configs`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jgpqv_modules AS m
LEFT JOIN jgpqv_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jgpqv_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM jgpqv_languages
1 × SELECT *
FROM `jgpqv_virtuemart_shoppergroups`
1 × SHOW FULL COLUMNS
FROM `jgpqv_virtuemart_userfields
1 × SHOW TABLES LIKE "jgpqv_virtuemart_configs
1 × UPDATE `jgpqv_extensions`
SET `params` = '{\"mediaversion\":\"f0e75fda481419934de0b22a55074ede\"}'
1 × INSERT INTO `jgpqv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('b0c606d480f107db677777552ffbb255', 1, '1761457558', 0, '', 0