Showroom/visning:
Mån-Tors 10-15
Fre 10-14
Mån-Tors 10-15
Fre 10-14
Kundservice tel:
Mån -Tors 9:00 - 19:00
Fre 9:00 - 17:00
Lör 10:00 - 14:00
Chat: 8-22
NOBLETEAM AB
Granit-Marmor-Kalksten-Skiffer
- HEM
- INOMHUS
- UTOMHUS
Tillbehör
© NobleTeam 2024, Powered by Astroid. Design by Lombiz target="_blank">Lombiz - UTOMHUS
Joomlas felsökningskonsoll
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1728795198,
"last": 1728795198,
"now": 1728795198
},
"token": "dXbvtkZCY68Lep91FEm6Y1SVAdTxrsXx"
},
"registry": {
"com_virtuemart": {
"customfields": ""
}
},
"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
},
"plg_system_languagefilter": {
"language": "sv-SE"
}
},
"__vm": {
"manage": 0,
"vmlastvisitedItemid": 295,
"vmlastvisitedcategoryid": 19,
"vmlastvisitedmanuid": 0
}
}
Tid
Minne
Tid: 5.20 ms / 5.20 ms Minne: 0.411 MB / 0.76 MB Application: afterLoad
Tid: 30.41 ms / 35.61 ms Minne: 1.868 MB / 2.63 MB Application: afterInitialise
Tid: 12.28 ms / 47.89 ms Minne: 0.350 MB / 2.98 MB Application: afterRoute
Tid: 0.52 ms / 48.41 ms Minne: 0.013 MB / 2.99 MB Application: beforeRenderComponent com_virtuemart
Tid: 4.98 ms / 53.39 ms Minne: 0.432 MB / 3.42 MB Application: Before Access::preloadComponents (all components)
Tid: 0.64 ms / 54.03 ms Minne: 0.062 MB / 3.48 MB Application: After Access::preloadComponents (all components)
Tid: 0.02 ms / 54.05 ms Minne: -0.002 MB / 3.48 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Tid: 0.22 ms / 54.27 ms Minne: 0.008 MB / 3.49 MB Application: After Access::getAssetRules (id:1 name:root.1)
Tid: 0.02 ms / 54.29 ms Minne: 0.001 MB / 3.49 MB Application: Before Access::getAssetRules (id:69 name:com_virtuemart)
Tid: 0.01 ms / 54.30 ms Minne: 0.002 MB / 3.49 MB Application: After Access::getAssetRules (id:69 name:com_virtuemart)
Tid: 46.07 ms / 100.37 ms Minne: 1.975 MB / 5.47 MB Application: afterRenderComponent com_virtuemart
Tid: 1.15 ms / 101.52 ms Minne: 0.011 MB / 5.48 MB Application: afterDispatch
Tid: 739.66 ms / 841.18 ms Minne: 1.029 MB / 6.51 MB Application: afterRender
Databasfrågor totalt: 25.66 ms
7:61 MB (7 980 136 Bytes)
79 loggade SQL-frågor 25.66 ms
- Frågetid: 0.26 ms Frågeminne: 0.023 MB Minne före fråga: 1.038 MB Returnerade rader: 0
SELECT `data`
FROM `j3_session`
WHERE `session_id` = X'6235306432383265663162336336373962343763633161656133383036303330'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 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.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Samma som samtal i raden nedan. 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Frågetid: 0.19 ms Efter sista fråga: 0.45 ms Frågeminne: 0.020 MB Minne före fråga: 1.052 MB Returnerade rader: 0
SELECT `session_id`
FROM `j3_session`
WHERE `session_id` = X'6235306432383265663162336336373962343763633161656133383036303330'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_session const PRIMARY PRIMARY 194 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.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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Frågetid: 1.43 ms Efter sista fråga: 0.07 ms Frågeminne: 0.004 MB Minne före fråga: 1.057 MB
INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6235306432383265663162336336373962343763633161656133383036303330', 1, 1728795198, 0, '', 0)EXPLAIN inte möjlig i fråga: INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6235306432383265663162336336373962343763633161656133383036303330', 1, 1728795198, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init for update 0.01 ms Update 0.06 ms Waiting for query cache lock 0.00 ms Update 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 1.22 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Frågetid: 0.18 ms Efter sista fråga: 1.45 ms Frågeminne: 0.021 MB Minne före fråga: 1.134 MB Returnerade rader: 3
SELECT id, rules
FROM `j3_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_viewlevels ALL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 3 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.01 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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 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 # Uppringare Fil och radnummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.25 ms Efter sista fråga: 0.08 ms Frågeminne: 0.021 MB Minne före fråga: 1.145 MB Returnerade rader: 1
SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 Using where; Using index 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.06 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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 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:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.21 ms Efter sista fråga: 3.72 ms Frågeminne: 0.020 MB Minne före fråga: 1.555 MB Returnerade rader: 0
SELECT `query`
FROM `j3_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_admintools_wafexceptions system NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 0 Const row not found 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.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.00 ms # Uppringare Fil och radnummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/plugins/system/admintools/admintools/main.php:486 8 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:96 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.18 ms Efter sista fråga: 0.26 ms Frågeminne: 0.022 MB Minne före fråga: 1.569 MB Returnerade rader: 1
SELECT `value`
FROM `j3_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_admintools_storage const PRIMARY PRIMARY 767 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.03 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/models/storage.php:84 11 AdmintoolsModelStorage->load() JROOT/administrator/components/com_admintools/models/storage.php:49 10 AdmintoolsModelStorage->getValue() JROOT/plugins/system/admintools/feature/httpsizer.php:26 9 AtsystemFeatureHttpsizer->isEnabled() JROOT/plugins/system/admintools/admintools/main.php:352 8 plgSystemAdmintools->loadFeatures() JROOT/plugins/system/admintools/admintools/main.php:99 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.21 ms Efter sista fråga: 9.22 ms Frågeminne: 0.022 MB Minne före fråga: 2.062 MB Returnerade rader: 0
select email
from j3_users
where id=0
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/bfstop/helpers/db.php:246 12 BFStopDBHelper->getUserEmailWhere() JROOT/plugins/system/bfstop/helpers/db.php:253 11 BFStopDBHelper->getUserEmailByID() JROOT/plugins/system/bfstop/helpers/notify.php:23 10 BFStopNotifier->__construct() JROOT/plugins/system/bfstop/bfstop.php:197 9 plgSystembfstop->init() JROOT/plugins/system/bfstop/bfstop.php:367 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.21 ms Efter sista fråga: 0.07 ms Frågeminne: 0.021 MB Minne före fråga: 2.070 MB Returnerade rader: 0
SELECT id, ipaddress
from j3_bfstop_whitelist
WHERE (ipaddress='34.239.150.167'
AND LOCATE('/', ipaddress) = 0)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_bfstop_whitelist ALL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 Using where Status Duration Starting 0.05 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.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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:159 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:189 9 BFStopDBHelper->isIPWhiteListed() JROOT/plugins/system/bfstop/bfstop.php:386 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.24 ms Efter sista fråga: 0.05 ms Frågeminne: 0.021 MB Minne före fråga: 2.076 MB Returnerade rader: 0
SELECT id, ipaddress
from j3_bfstop_whitelist
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('34.239.150.167') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_bfstop_whitelist ALL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 Using where Status Duration Starting 0.06 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.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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:159 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:190 9 BFStopDBHelper->isIPWhiteListed() JROOT/plugins/system/bfstop/bfstop.php:386 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.27 ms Efter sista fråga: 0.05 ms Frågeminne: 0.021 MB Minne före fråga: 2.083 MB Returnerade rader: 0
SELECT id, ipaddress, crdate, duration
FROM j3_bfstop_bannedip b
WHERE (ipaddress='34.239.150.167'
AND LOCATE('/', ipaddress) = 0)
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-10-13 06:53:18')
AND NOT EXISTS (SELECT 1
FROM j3_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY b ALL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 Using where 2 DEPENDENT SUBQUERY u unique_subquery PRIMARY PRIMARY 4 func 1 Using index Status Duration Starting 0.05 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.03 ms Optimizing 0.03 ms Statistics 0.01 ms Preparing 0.01 ms Optimizing 0.00 ms Statistics 0.01 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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:159 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:179 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:390 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.31 ms Efter sista fråga: 0.04 ms Frågeminne: 0.021 MB Minne före fråga: 2.089 MB Returnerade rader: 0
SELECT id, ipaddress, crdate, duration
FROM j3_bfstop_bannedip b
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('34.239.150.167') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-10-13 06:53:18')
AND NOT EXISTS (SELECT 1
FROM j3_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY b ALL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 Using where 2 DEPENDENT SUBQUERY u unique_subquery PRIMARY PRIMARY 4 func 1 Using index Status Duration Starting 0.07 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.05 ms Statistics 0.01 ms Preparing 0.02 ms Optimizing 0.00 ms Statistics 0.01 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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Uppringare Fil och radnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:159 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:180 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:390 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.20 ms Efter sista fråga: 2.74 ms Frågeminne: 0.023 MB Minne före fråga: 2.382 MB Returnerade rader: 26
SELECT *
FROM j3_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_rsform_config ALL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 26 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.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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28 8 plgSystemRsformdeletesubmissions->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.14 ms Efter sista fråga: 1.25 ms Frågeminne: 0.020 MB Minne före fråga: 2.614 MB Returnerade rader: 1
SELECT count(*)
FROM `j3_cwgears_schedule`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL NULL Select tables optimized away 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 Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:96 8 plgSystemCwgears->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.14 ms Efter sista fråga: 0.06 ms Frågeminne: 0.020 MB Minne före fråga: 2.619 MB Returnerade rader: 1
SELECT count(*)
FROM `j3_cwgears_schedule`
WHERE time + '3600'<'1728795198'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:139 8 plgSystemCwgears->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.20 ms Efter sista fråga: 6.54 ms Frågeminne: 0.021 MB Minne före fråga: 2.792 MB Returnerade rader: 1
SELECT *
FROM `j3_jdbuilder_configs`
WHERE `type`='global'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_jdbuilder_configs system NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 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.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Helper.php:1954 10 JDPageBuilder\Helper::globalSettings() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Builder.php:45 9 JDPageBuilder\Builder::init() JROOT/plugins/system/jdbuilder/jdbuilder.php:26 8 plgSystemJDBuilder->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 1.71 ms Efter sista fråga: 4.21 ms Frågeminne: 0.007 MB Minne före fråga: 2.952 MB
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"6efec9740dd31de9f39b6862c231392e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN inte möjlig i fråga: UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"6efec9740dd31de9f39b6862c231392e\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.06 ms Updating 0.06 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 1.43 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 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 # Uppringare Fil och radnummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:195 8 plgSystemCwgears->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.17 ms Efter sista fråga: 0.40 ms Frågeminne: 0.021 MB Minne före fråga: 2.972 MB Returnerade rader: 1
SELECT count(*)
FROM `j3_extensions`
WHERE `element` = 'cwgears'
AND `extension_id` = ''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.01 ms Optimizing 0.01 ms Statistics 0.03 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 Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:1003 9 plgSystemCwgears->updateDownloadKeySub() JROOT/plugins/system/cwgears/cwgears.php:202 8 plgSystemCwgears->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 2.61 ms Efter sista fråga: 2.48 ms Frågeminne: 0.021 MB Minne före fråga: 3.350 MB Returnerade rader: 1
SHOW TABLES LIKE "j3_virtuemart_configs"
EXPLAIN inte möjlig i fråga: SHOW TABLES LIKE "j3_virtuemart_configs"Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.03 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 Filling schema table 0.00 ms checking permissions 2.40 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 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 Query end 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 # Uppringare Fil och radnummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:723 9 VmTable::checkTableExists() JROOT/administrator/components/com_virtuemart/models/config.php:565 8 VirtueMartModelConfig::checkConfigTableExists() JROOT/administrator/components/com_virtuemart/helpers/config.php:406 7 VmConfig::loadConfig() JROOT/components/com_virtuemart/virtuemart.php:24 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.19 ms Efter sista fråga: 0.12 ms Frågeminne: 0.020 MB Minne före fråga: 3.359 MB Returnerade rader: 1
SELECT `config`
FROM `j3_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_configs system PRIMARY INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Uppringare Fil och radnummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/config.php:446 7 VmConfig::loadConfig() JROOT/components/com_virtuemart/virtuemart.php:24 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.50 ms Efter sista fråga: 0.47 ms Frågeminne: 0.027 MB Minne före fråga: 3.428 MB Returnerade rader: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j3_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_associations','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_imagerecycle','com_installer','com_jaextmanager','com_jch_optimize','com_jdbuilder','com_joomlaupdate','com_jotcache','com_jspeed','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_searchsource','com_tags','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_assets ALL idx_asset_name INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 201 Using where Status Duration Starting 0.05 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.04 ms Optimizing 0.01 ms Statistics 0.09 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.20 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 14 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 13 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 12 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 11 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 10 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:145 9 vmAccess::manager() JROOT/administrator/components/com_virtuemart/helpers/config.php:85 8 VmConfig::echoAdmin() JROOT/administrator/components/com_virtuemart/helpers/config.php:468 7 VmConfig::loadConfig() JROOT/components/com_virtuemart/virtuemart.php:24 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.57 ms Efter sista fråga: 4.51 ms Frågeminne: 0.065 MB Minne före fråga: 3.627 MB Returnerade rader: 20
SELECT *
FROM `j3_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "sv-SE" )
AND ( access="1" )
ORDER BY `language` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_menu ALL idx_client_id_parent_id_alias_language,idx_language INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 117 Using where; Använder filsortering Status Duration Starting 0.04 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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.25 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 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 # Uppringare Fil och radnummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/router.php:1329 21 vmrouterHelper->setMenuItemId() JROOT/components/com_virtuemart/router.php:889 20 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:903 19 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:27 18 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 17 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 16 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 15 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_virtuemart/views/category/view.html.php:566 10 VirtuemartViewCategory->setCanonicalLink() JROOT/components/com_virtuemart/views/category/view.html.php:128 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.38 ms Efter sista fråga: 1.14 ms Frågeminne: 0.022 MB Minne före fråga: 3.726 MB Returnerade rader: 1
SELECT `j3_virtuemart_categories`.* ,`j3_virtuemart_categories_sv_se`.*
FROM `j3_virtuemart_categories`
INNER JOIN `j3_virtuemart_categories_sv_se` using (`virtuemart_category_id`)
WHERE `j3_virtuemart_categories`.`virtuemart_category_id` = "19"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_categories const PRIMARY PRIMARY 4 const 1 1 SIMPLE j3_virtuemart_categories_sv_se const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.08 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 12 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044 11 VmTable->load() JROOT/administrator/components/com_virtuemart/models/category.php:89 10 VirtueMartModelCategory->getCategory() JROOT/components/com_virtuemart/views/category/view.html.php:178 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.19 ms Efter sista fråga: 0.30 ms Frågeminne: 0.022 MB Minne före fråga: 3.762 MB Returnerade rader: 1
SELECT `virtuemart_media_id`
FROM `j3_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "19"
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_category_medias ref virtuemart_category_id,ordering ordering 4 const 1 Using where Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124 11 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/category.php:92 10 VirtueMartModelCategory->getCategory() JROOT/components/com_virtuemart/views/category/view.html.php:178 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.61 ms Efter sista fråga: 0.04 ms Frågeminne: 0.021 MB Minne före fråga: 3.769 MB Returnerade rader: 0
SELECT `category_child_id`
FROM `j3_virtuemart_category_categories`
WHERE `category_parent_id` = 19id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_category_categories ref category_parent_id category_parent_id 4 const 1 Using index Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.40 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.02 ms Unlocking tables 0.00 ms closing tables 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 12 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_virtuemart/models/category.php:680 11 VirtueMartModelCategory->hasChildren() JROOT/administrator/components/com_virtuemart/models/category.php:109 10 VirtueMartModelCategory->getCategory() JROOT/components/com_virtuemart/views/category/view.html.php:178 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.44 ms Efter sista fråga: 0.06 ms Frågeminne: 0.022 MB Minne före fråga: 3.776 MB Returnerade rader: 1
SELECT count(`p`.virtuemart_product_id) AS total
FROM `j3_virtuemart_product_categories` as `pc`
LEFT JOIN `j3_virtuemart_products` as `p`
ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
WHERE `pc`.`virtuemart_category_id` = "19"
AND `p`.`virtuemart_vendor_id` = "1"
AND `p`.`published` = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p ALL PRIMARY,virtuemart_vendor_id,published INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 136 Using where 1 SIMPLE pc eq_ref virtuemart_product_id virtuemart_product_id 8 nobletea_joom108.p.virtuemart_product_id,const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.04 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.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.19 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/models/category.php:406 11 VirtueMartModelCategory->countProducts() JROOT/administrator/components/com_virtuemart/models/category.php:118 10 VirtueMartModelCategory->getCategory() JROOT/components/com_virtuemart/views/category/view.html.php:178 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.22 ms Efter sista fråga: 0.91 ms Frågeminne: 0.024 MB Minne före fråga: 3.931 MB Returnerade rader: 1
SELECT *
FROM `j3_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 j3_virtuemart_shoppergroups ALL virtuemart_vendor_id,shared,published INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 6 Using where Status Duration Starting 0.02 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.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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100 15 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 14 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:177 13 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:111 12 VirtueMartModelUser->getCurrentUser() JROOT/administrator/components/com_virtuemart/models/product.php:933 11 VirtueMartModelProduct::getCurrentUserShopperGrps() JROOT/administrator/components/com_virtuemart/models/product.php:482 10 VirtueMartModelProduct->sortSearchListQuery() JROOT/components/com_virtuemart/views/category/view.html.php:273 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.16 ms Efter sista fråga: 0.06 ms Frågeminne: 0.025 MB Minne före fråga: 3.957 MB Returnerade rader: 1
SELECT `j3_virtuemart_shoppergroups`.*
FROM `j3_virtuemart_shoppergroups`
WHERE `j3_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_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.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 19 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044 18 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1033 17 VmModel->getData() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50 16 VirtueMartModelShopperGroup->getShopperGroup() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105 15 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 14 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:177 13 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:111 12 VirtueMartModelUser->getCurrentUser() JROOT/administrator/components/com_virtuemart/models/product.php:933 11 VirtueMartModelProduct::getCurrentUserShopperGrps() JROOT/administrator/components/com_virtuemart/models/product.php:482 10 VirtueMartModelProduct->sortSearchListQuery() JROOT/components/com_virtuemart/views/category/view.html.php:273 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.76 ms Efter sista fråga: 0.81 ms Frågeminne: 0.022 MB Minne före fråga: 3.978 MB Returnerade rader: 4
SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price
FROM `j3_virtuemart_products` as p
LEFT JOIN `j3_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `j3_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `j3_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` = 19
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `product_price` ASC, p.`virtuemart_product_id` ASC
LIMIT 0, 50id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ps system virtuemart_product_id INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 0 Const row not found; Using temporary; Använder filsortering 1 SIMPLE p ALL PRIMARY,published INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 136 Using where 1 SIMPLE pp ref virtuemart_product_id virtuemart_product_id 4 nobletea_joom108.p.virtuemart_product_id 1 1 SIMPLE pc eq_ref virtuemart_product_id virtuemart_product_id 8 nobletea_joom108.p.virtuemart_product_id,const 1 Using index Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.41 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:857 11 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:785 10 VirtueMartModelProduct->sortSearchListQuery() JROOT/components/com_virtuemart/views/category/view.html.php:273 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.09 ms Efter sista fråga: 0.05 ms Frågeminne: 0.022 MB Minne före fråga: 3.985 MB Returnerade rader: 1
SELECT FOUND_ROWS()
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL NULL No tables used Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms init 0.01 ms Optimizing 0.00 ms Executing 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:870 11 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:785 10 VirtueMartModelProduct->sortSearchListQuery() JROOT/components/com_virtuemart/views/category/view.html.php:273 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.28 ms Efter sista fråga: 0.57 ms Frågeminne: 0.023 MB Minne före fråga: 4.009 MB Returnerade rader: 1
SELECT `j3_virtuemart_products`.* ,`j3_virtuemart_products_sv_se`.*
FROM `j3_virtuemart_products`
INNER JOIN `j3_virtuemart_products_sv_se` using (`virtuemart_product_id`)
WHERE `j3_virtuemart_products`.`virtuemart_product_id` = "74"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_products const PRIMARY PRIMARY 4 const 1 1 SIMPLE j3_virtuemart_products_sv_se const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 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.04 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.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/product.php:1474 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.18 ms Efter sista fråga: 0.21 ms Frågeminne: 0.023 MB Minne före fråga: 4.035 MB Returnerade rader: 1
SELECT `virtuemart_media_id`
FROM `j3_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "74"
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_product_medias ref virtuemart_product_id,ordering ordering 4 const 1 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 Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124 13 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1479 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.16 ms Efter sista fråga: 0.14 ms Frågeminne: 0.024 MB Minne före fråga: 4.064 MB Returnerade rader: 0
SELECT `virtuemart_shoppergroup_id`
FROM `j3_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "74"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.02 ms Preparing 0.00 ms Executing 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.03 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124 13 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1482 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.28 ms Efter sista fråga: 0.14 ms Frågeminne: 0.023 MB Minne före fråga: 4.070 MB Returnerade rader: 1
SELECT *
FROM `j3_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "74"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-10-13 04:53:18" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-13 04:53:18" ) )
ORDER BY `product_price` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_product_prices ref virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down virtuemart_product_id 4 const 1 Using where; Använder filsortering 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.02 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:1288 14 VirtueMartModelProduct->loadProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:1307 13 VirtueMartModelProduct->getRawProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:1498 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.17 ms Efter sista fråga: 0.16 ms Frågeminne: 0.023 MB Minne före fråga: 4.090 MB Returnerade rader: 1
SELECT `virtuemart_manufacturer_id`
FROM `j3_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "74"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_product_manufacturers ref virtuemart_product_id virtuemart_product_id 5 const 1 Using index Status Duration Starting 0.02 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.01 ms Optimizing 0.01 ms Statistics 0.02 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124 13 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1502 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.30 ms Efter sista fråga: 0.12 ms Frågeminne: 0.023 MB Minne före fråga: 4.114 MB Returnerade rader: 1
SELECT `j3_virtuemart_manufacturers`.* ,`j3_virtuemart_manufacturers_sv_se`.*
FROM `j3_virtuemart_manufacturers`
INNER JOIN `j3_virtuemart_manufacturers_sv_se` using (`virtuemart_manufacturer_id`)
WHERE `j3_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_manufacturers system PRIMARY,virtuemart_manufacturercategories_id INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 1 SIMPLE j3_virtuemart_manufacturers_sv_se system PRIMARY INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.06 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 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.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/product.php:1507 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.15 ms Efter sista fråga: 0.08 ms Frågeminne: 0.023 MB Minne före fråga: 4.134 MB Returnerade rader: 1
SELECT *
FROM `j3_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 74id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_product_categories ref virtuemart_product_id virtuemart_product_id 4 const 1 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.02 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:1744 14 VirtueMartModelProduct::getProductCategoryIds() JROOT/administrator/components/com_virtuemart/models/product.php:1721 13 VirtueMartModelProduct->getProductCategories() JROOT/administrator/components/com_virtuemart/models/product.php:1518 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.30 ms Efter sista fråga: 0.33 ms Frågeminne: 0.022 MB Minne före fråga: 4.172 MB Returnerade rader: 0
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `j3_virtuemart_customs` AS c
LEFT JOIN `j3_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE field.`virtuemart_product_id` IN (74)
AND c.`published` = "1"
ORDER BY field.`ordering` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.06 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.04 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/models/customfields.php:154 12 VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields() JROOT/administrator/components/com_virtuemart/models/product.php:1159 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.30 ms Efter sista fråga: 0.38 ms Frågeminne: 0.025 MB Minne före fråga: 4.212 MB Returnerade rader: 1
SELECT *
FROM `j3_virtuemart_currencies` AS c
LEFT JOIN `j3_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 v system PRIMARY,vendor_currency INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.06 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.05 ms Preparing 0.00 ms Unlocking tables 0.00 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/vendor.php:313 17 VirtueMartModelVendor::getVendorCurrency() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 16 CurrencyDisplay->__construct() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106 15 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 14 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 13 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2740 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.17 ms Efter sista fråga: 0.38 ms Frågeminne: 0.025 MB Minne före fråga: 4.249 MB Returnerade rader: 1
SELECT `j3_virtuemart_currencies`.*
FROM `j3_virtuemart_currencies`
WHERE `j3_virtuemart_currencies`.`virtuemart_currency_id` = "124"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_currencies 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.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044 17 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1033 16 VmModel->getData() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122 15 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 14 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 13 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2740 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.73 ms Efter sista fråga: 0.45 ms Frågeminne: 0.036 MB Minne före fråga: 4.359 MB Returnerade rader: 32
SHOW FULL COLUMNS
FROM `j3_virtuemart_userfields`EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `j3_virtuemart_userfields`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.29 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 Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.11 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.10 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 26 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:684 25 VmTable->showFullColumns() JROOT/administrator/components/com_virtuemart/tables/userfields.php:41 24 TableUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210 23 VmTable::getInstance() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432 22 VmModel->_createTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394 21 VmModel->getTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:600 20 VmModel->setMainTable() JROOT/administrator/components/com_virtuemart/models/userfields.php:49 19 VirtueMartModelUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:552 18 VmModel::getModel() JROOT/components/com_virtuemart/helpers/cart.php:296 17 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:185 16 VirtueMartCart::getCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:270 15 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 14 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 13 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2740 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.47 ms Efter sista fråga: 0.13 ms Frågeminne: 0.038 MB Minne före fråga: 4.398 MB Returnerade rader: 24
SELECT *
FROM `j3_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_userfields ALL published,account INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 36 Using where; Använder filsortering 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.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.18 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497 20 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:601 19 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:483 18 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:337 17 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:185 16 VirtueMartCart::getCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:270 15 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 14 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 13 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2740 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.63 ms Efter sista fråga: 10.72 ms Frågeminne: 0.034 MB Minne före fråga: 4.805 MB Returnerade rader: 14
SELECT *
FROM `j3_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 orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_userfields ALL published,shipment INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 36 Using where; Använder filsortering Status Duration Starting 0.11 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.06 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Uppringare Fil och radnummer 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497 20 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:601 19 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:489 18 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:337 17 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:185 16 VirtueMartCart::getCart() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:270 15 calculationHelper->setCountryState() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 14 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 13 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2740 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.40 ms Efter sista fråga: 0.38 ms Frågeminne: 0.024 MB Minne före fråga: 4.874 MB Returnerade rader: 1
SELECT c.*
FROM j3_virtuemart_calcs as c
LEFT JOIN j3_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 <= "2024-10-13 04:53:18" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-13 04:53:18" )
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 c system virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 1 1 SIMPLE cs system virtuemart_calc_id INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL 0 Const row not found Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.08 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.05 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 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 # Uppringare Fil och radnummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 16 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:171 15 calculationHelper->setVendorId() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 14 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 13 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2740 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.14 ms Efter sista fråga: 0.09 ms Frågeminne: 0.023 MB Minne före fråga: 4.885 MB Returnerade rader: 0
SELECT `virtuemart_category_id`
FROM j3_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 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.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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1237 14 calculationHelper->gatherEffectingRulesForProductPrice() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:392 13 calculationHelper->getProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:2741 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.12 ms Efter sista fråga: 0.04 ms Frågeminne: 0.023 MB Minne före fråga: 4.893 MB Returnerade rader: 0
SELECT `virtuemart_shoppergroup_id`
FROM j3_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.01 ms Optimizing 0.00 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1250 14 calculationHelper->gatherEffectingRulesForProductPrice() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:392 13 calculationHelper->getProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:2741 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.12 ms Efter sista fråga: 0.02 ms Frågeminne: 0.023 MB Minne före fråga: 4.900 MB Returnerade rader: 0
SELECT `virtuemart_country_id`
FROM j3_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.01 ms init 0.01 ms Optimizing 0.00 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1262 14 calculationHelper->gatherEffectingRulesForProductPrice() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:392 13 calculationHelper->getProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:2741 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.12 ms Efter sista fråga: 0.02 ms Frågeminne: 0.023 MB Minne före fråga: 4.908 MB Returnerade rader: 0
SELECT `virtuemart_state_id`
FROM j3_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1269 14 calculationHelper->gatherEffectingRulesForProductPrice() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:392 13 calculationHelper->getProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:2741 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.14 ms Efter sista fråga: 0.03 ms Frågeminne: 0.023 MB Minne före fråga: 4.915 MB Returnerade rader: 0
SELECT `virtuemart_manufacturer_id`
FROM j3_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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.01 ms Optimizing 0.00 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1291 14 calculationHelper->gatherEffectingRulesForProductPrice() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:392 13 calculationHelper->getProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:2741 12 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1173 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.27 ms Efter sista fråga: 0.17 ms Frågeminne: 0.023 MB Minne före fråga: 4.938 MB Returnerade rader: 1
SELECT `j3_virtuemart_products`.* ,`j3_virtuemart_products_sv_se`.*
FROM `j3_virtuemart_products`
INNER JOIN `j3_virtuemart_products_sv_se` using (`virtuemart_product_id`)
WHERE `j3_virtuemart_products`.`virtuemart_product_id` = "72"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_products const PRIMARY PRIMARY 4 const 1 1 SIMPLE j3_virtuemart_products_sv_se const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 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.04 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.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/product.php:1474 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.18 ms Efter sista fråga: 0.12 ms Frågeminne: 0.023 MB Minne före fråga: 4.952 MB Returnerade rader: 1
SELECT `virtuemart_media_id`
FROM `j3_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "72"
ORDER BY `ordering`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_product_medias ref virtuemart_product_id,ordering ordering 4 const 1 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 Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124 13 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1479 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.13 ms Efter sista fråga: 0.05 ms Frågeminne: 0.023 MB Minne före fråga: 4.964 MB Returnerade rader: 0
SELECT `virtuemart_shoppergroup_id`
FROM `j3_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "72"id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INGEN INDEXNYCKEL KAN ANVÄNDAS 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124 13 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1482 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.31 ms Efter sista fråga: 0.04 ms Frågeminne: 0.023 MB Minne före fråga: 4.967 MB Returnerade rader: 1
SELECT *
FROM `j3_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "72"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-10-13 04:53:18" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-13 04:53:18" ) )
ORDER BY `product_price` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3_virtuemart_product_prices ref virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down virtuemart_product_id 4 const 1 Using where; Använder filsortering 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.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 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 # Uppringare Fil och radnummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:1288 14 VirtueMartModelProduct->loadProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:1307 13 VirtueMartModelProduct->getRawProductPrices() JROOT/administrator/components/com_virtuemart/models/product.php:1498 12 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1076 11 VirtueMartModelProduct->getProduct() JROOT/administrator/components/com_virtuemart/models/product.php:1892 10 VirtueMartModelProduct->getProducts() JROOT/components/com_virtuemart/views/category/view.html.php:277 9 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:54 8 VirtueMartControllerCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:120 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Frågetid: 0.16 ms Efter sista fråga: 0.10 ms Frågeminne: 0.023 MB Minne före fråga: 4.976 MB Returnerade rader: 1