Every effort has been made to avoid any mistake or omission. This publication is on the condition and understanding that neither the publisher, the Editors or the composer would be liable in any manner to any person by reason of any mistake
Narayani Publications
H.No.469/1, Doxirwaddo,
Assagao – Bardez Goa .
403-507
Telephone : 91 832 2268101
Mobile : 9921363943
Email: npublications.goa@gmail.com
{ "__default": { "session": { "counter": 2, "timer": { "start": 1718165458, "last": 1718165458, "now": 1718165458 }, "token": "MnbPFiZnQGreQ8ccjlfwaFgAFJmqpo5K" }, "registry": { "com_flexicontent": { "min_word_len": 4 } }, "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 } } }
SELECT `data`
FROM `yk9mw_session`
WHERE `session_id` = '18v03pdpgbvpb099oinho6d725'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_session | const | PRIMARY | PRIMARY | 575 | const | 1 |
Status | Duration |
---|---|
Starting | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.15 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
12 | JSessionStorageDatabase->read() | **Same as call in the line below.** |
11 | session_start() | JROOT/libraries/joomla/session/handler/native.php:259 |
10 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:49 |
9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:636 |
7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
6 | JSession->start() | JROOT/libraries/cms/application/cms.php:773 |
5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
1 | JFactory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yk9mw_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.11 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
9 | JDatabaseDriver->loadObjectList() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:448 |
6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:120 |
4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:589 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT b.id
FROM yk9mw_usergroups AS a
LEFT JOIN yk9mw_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 5 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:835 |
9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:904 |
8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `yk9mw_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_viewlevels | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 6 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:921 |
8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT folder AS type, element AS name, params
FROM yk9mw_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where; **Using filesort** |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.12 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:310 |
6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT lft,rgt
FROM yk9mw_categories
WHERE id=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.11 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
9 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_flexicontent/defineconstants.php:115 |
8 | require_once JROOT/administrator/components/com_flexicontent/defineconstants.php | JROOT/plugins/system/flexisystem/flexisystem.php:25 |
7 | require_once JROOT/plugins/system/flexisystem/flexisystem.php | JROOT/libraries/cms/plugin/helper.php:230 |
6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT template
FROM yk9mw_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_home | **NO INDEX KEY COULD BE USED** | NULL | NULL | 8 | Using where |
Status | Duration |
---|---|
Starting | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:96 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:255 |
6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT template
FROM yk9mw_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_home | **NO INDEX KEY COULD BE USED** | NULL | NULL | 8 | Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:96 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:255 |
6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT extension, file, type
FROM yk9mw_rokcommon_configs
ORDER BY priority
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_rokcommon_configs | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 2 | **Using filesort** |
Status | Duration |
---|---|
Starting | 0.13 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:132 |
8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:76 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:255 |
6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT DISTINCT userid
FROM yk9mw_session
WHERE guest=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_session | index | NULL | userid | 5 | NULL | 918 | Using where |
Status | Duration |
---|---|
Starting | 0.28 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 1.85 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.08 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
11 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/flexisystem/flexisystem.php:965 |
10 | plgSystemFlexisystem->checkinRecords() | JROOT/plugins/system/flexisystem/flexisystem.php:119 |
9 | plgSystemFlexisystem->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, checked_out, checked_out_time
FROM yk9mw_content
WHERE checked_out > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_content | range | idx_checkout | idx_checkout | 4 | NULL | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/flexisystem/flexisystem.php:977 |
10 | plgSystemFlexisystem->checkinRecords() | JROOT/plugins/system/flexisystem/flexisystem.php:119 |
9 | plgSystemFlexisystem->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, checked_out, checked_out_time
FROM yk9mw_categories
WHERE checked_out > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_categories | range | idx_checkout | idx_checkout | 4 | NULL | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/flexisystem/flexisystem.php:977 |
10 | plgSystemFlexisystem->checkinRecords() | JROOT/plugins/system/flexisystem/flexisystem.php:119 |
9 | plgSystemFlexisystem->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, checked_out, checked_out_time
FROM yk9mw_modules
WHERE checked_out > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_modules | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 235 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.12 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/flexisystem/flexisystem.php:977 |
10 | plgSystemFlexisystem->checkinRecords() | JROOT/plugins/system/flexisystem/flexisystem.php:119 |
9 | plgSystemFlexisystem->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, checked_out, checked_out_time
FROM yk9mw_menu
WHERE checked_out > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_menu | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 298 | Using where |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.12 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/flexisystem/flexisystem.php:977 |
10 | plgSystemFlexisystem->checkinRecords() | JROOT/plugins/system/flexisystem/flexisystem.php:119 |
9 | plgSystemFlexisystem->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `yk9mw_extensions`
Status | Duration |
---|---|
Starting | 0.30 ms |
checking permissions | 0.03 ms |
closing tables | 0.01 ms |
Opening tables | 0.77 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
checking permissions | 0.14 ms |
closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.26 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
16 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
15 | JTable->__construct() | JROOT/libraries/joomla/table/extension.php:31 |
14 | JTableExtension->__construct() | JROOT/libraries/joomla/table/table.php:308 |
13 | JTable::getInstance() | JROOT/administrator/components/com_simplerenew/library/joomla/addon.php:55 |
12 | SimplerenewAddon::load() | JROOT/administrator/components/com_simplerenew/include.php:31 |
11 | require_once JROOT/administrator/components/com_simplerenew/include.php | JROOT/plugins/system/simplerenew/simplerenew.php:112 |
10 | plgSystemSimplerenew->isInstalled() | JROOT/plugins/system/simplerenew/simplerenew.php:44 |
9 | plgSystemSimplerenew->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_axisubs_configurations
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_axisubs_configurations | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 17 |
Status | Duration |
---|---|
Starting | 0.23 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.17 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_axisubs/Helper/Config.php:31 |
13 | Flycart\Axisubs\Admin\Helper\Config->__construct() | JROOT/administrator/components/com_axisubs/Helper/Config.php:39 |
12 | Flycart\Axisubs\Admin\Helper\Config::getInstance() | JROOT/administrator/components/com_axisubs/Helper/Axisubs.php:30 |
11 | Flycart\Axisubs\Admin\Helper\Axisubs::config() | JROOT/plugins/system/axisexpirycontrol/axisexpirycontrol.php:270 |
10 | plgSystemAxisexpirycontrol->doIHaveToRun() | JROOT/plugins/system/axisexpirycontrol/axisexpirycontrol.php:137 |
9 | plgSystemAxisexpirycontrol->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `extension_id`
FROM `yk9mw_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
11 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/table/extension.php:109 |
10 | JTableExtension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:50 |
9 | plgSystemRokSprocket->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_extensions
WHERE `extension_id` = '10099'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
10 | JTable->load() | JROOT/plugins/system/roksprocket/roksprocket.php:55 |
9 | plgSystemRokSprocket->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `extension_id`
FROM `yk9mw_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.16 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.02 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
11 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/table/extension.php:109 |
10 | JTableExtension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:73 |
9 | plgSystemRokSprocket->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_extensions
WHERE `extension_id` = '10099'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
10 | JTable->load() | JROOT/plugins/system/roksprocket/roksprocket.php:77 |
9 | plgSystemRokSprocket->onAfterInitialise() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM yk9mw_menu AS m
LEFT JOIN yk9mw_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 199 | Using index condition; Using where; Using temporary; **Using filesort** |
1 | SIMPLE | e | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.25 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 22.82 ms |
Creating sort index | 0.82 ms |
Waiting for query cache lock | 0.02 ms |
Creating sort index | 0.84 ms |
Waiting for query cache lock | 0.08 ms |
Creating sort index | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.51 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.09 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.08 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.07 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.06 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.09 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 2.55 ms |
Removing tmp table | 2.69 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.19 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:145 |
11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:439 |
10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:57 |
8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:197 |
7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:535 |
6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:407 |
5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1115 |
4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yk9mw_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.30 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.31 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.18 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
18 | JDatabaseDriver->loadObject() | **Same as call in the line below.** |
17 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
16 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:156 |
15 | JLibraryHelper::_load() | JROOT/libraries/cms/library/helper.php:47 |
14 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:90 |
13 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:274 |
12 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
11 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
10 | JFactory::getDocument() | JROOT/plugins/system/flexisystem/flexisystem.php:156 |
9 | plgSystemFlexisystem->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1125 |
4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
UPDATE `yk9mw_extensions`
SET `params` = '{\"mediaversion\":\"02ef165f08beba3743bf8ffd6f81be38\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.13 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.03 ms |
Updating | 0.43 ms |
End of update loop | 0.08 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.87 ms |
Query end | 0.03 ms |
Commit | 0.94 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.15 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:119 |
14 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
13 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
12 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
11 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
10 | JFactory::getDocument() | JROOT/plugins/system/flexisystem/flexisystem.php:156 |
9 | plgSystemFlexisystem->onAfterRoute() | **Same as call in the line below.** |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1125 |
4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_languages | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 | Using where; **Using filesort** |
Status | Duration |
---|---|
Starting | 0.28 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:329 |
4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM yk9mw_template_styles as s
LEFT JOIN yk9mw_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template | **NO INDEX KEY COULD BE USED** | NULL | NULL | 8 | Using where |
1 | SIMPLE | e | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.21 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.14 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.12 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.00 ms |
Storing result in query cache | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:484 |
4 | JApplicationSite->getTemplate() | JROOT/libraries/cms/application/site.php:165 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT attribs, layout, template
FROM yk9mw_flexicontent_layouts_conf
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_flexicontent_layouts_conf | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 28 |
Status | Duration |
---|---|
Starting | 0.37 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.20 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.helper.php:4847 |
17 | flexicontent_tmpl::getLayoutparams() | JROOT/components/com_flexicontent/models/category.php:2128 |
16 | FlexicontentModelCategory->getLayoutparams() | JROOT/components/com_flexicontent/models/category.php:1934 |
15 | FlexicontentModelCategory->_loadCategoryParams() | JROOT/components/com_flexicontent/models/category.php:209 |
14 | FlexicontentModelCategory->populateCategoryState() | JROOT/components/com_flexicontent/models/category.php:142 |
13 | FlexicontentModelCategory->__construct() | JROOT/libraries/legacy/model/legacy.php:204 |
12 | JModelLegacy::getInstance() | JROOT/libraries/legacy/controller/legacy.php:547 |
11 | JControllerLegacy->createModel() | JROOT/libraries/legacy/controller/legacy.php:728 |
10 | JControllerLegacy->getModel() | JROOT/libraries/legacy/controller/legacy.php:622 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SHOW VARIABLES LIKE '%ft_min_word_len%'
Status | Duration |
---|---|
Starting | 0.20 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.58 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.15 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_flexicontent/models/category.php:230 |
14 | FlexicontentModelCategory->populateCategoryState() | JROOT/components/com_flexicontent/models/category.php:142 |
13 | FlexicontentModelCategory->__construct() | JROOT/libraries/legacy/model/legacy.php:204 |
12 | JModelLegacy::getInstance() | JROOT/libraries/legacy/controller/legacy.php:547 |
11 | JControllerLegacy->createModel() | JROOT/libraries/legacy/controller/legacy.php:728 |
10 | JControllerLegacy->getModel() | JROOT/libraries/legacy/controller/legacy.php:622 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug
FROM yk9mw_categories AS c
LEFT JOIN yk9mw_users AS u
ON u.id = c.created_user_id
WHERE c.published = 1
AND c.extension='com_content'
AND c.parent_id IN (92)
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | range | cat_idx,idx_access | cat_idx | 157 | NULL | 18 | Using index condition; Using where; **Using filesort** |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.15 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:310 |
13 | JModelLegacy->_getList() | JROOT/components/com_flexicontent/models/category.php:1385 |
12 | FlexicontentModelCategory->getChilds() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:75 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT c.id
FROM yk9mw_categories AS c
WHERE c.published = 1
AND c.access IN (0,1,1,5)
AND c.id IN (92)
ORDER BY c.lft ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.02 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
16 | JDatabaseDriver->loadColumn() | JROOT/components/com_flexicontent/models/category.php:639 |
15 | FlexicontentModelCategory->_getDataCats() | JROOT/components/com_flexicontent/models/category.php:822 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `yk9mw_assets`
Status | Duration |
---|---|
Starting | 0.16 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.71 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
checking permissions | 0.08 ms |
closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.22 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
21 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
20 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
19 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
18 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
15 | JUser->authorise() | JROOT/components/com_flexicontent/models/category.php:829 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_assets
WHERE `id` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_assets | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 10080 | Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
18 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
15 | JUser->authorise() | JROOT/components/com_flexicontent/models/category.php:829 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT a.rules
FROM yk9mw_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 10080 | Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
15 | JUser->authorise() | JROOT/components/com_flexicontent/models/category.php:829 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT element
FROM yk9mw_extensions
WHERE type = 'component'
AND enabled = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_extensions | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.35 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.13 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.20 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
19 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:413 |
18 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
15 | JUser->authorise() | JROOT/components/com_flexicontent/models/category.php:829 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT a.name, a.rules
FROM yk9mw_assets AS a
WHERE (a.name IN ('com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_flexicontent','com_djimageslider','com_jem','com_icagenda','com_roksprocket','com_phocagallery','com_simpleregistration','com_comprofiler','com_simplemembership','com_smartsub','com_rdsubs','com_phocaemail','com_osmap','com_anduser','com_axisubs','com_virtuemart','com_virtuemart_allinone','com_tcpdf','com_coalawebcontact','com_creativecontactform') OR a.name = 'root.1')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 10080 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
19 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
18 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
15 | JUser->authorise() | JROOT/components/com_flexicontent/models/category.php:829 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT fi.*
FROM yk9mw_flexicontent_fields AS fi
WHERE fi.published = 1
AND fi.isfilter = 1
AND fi.access IN (0,1,1,5)
ORDER BY fi.ordering, fi.name
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fi | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 58 | Using where; **Using filesort** |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:3640 |
16 | FlexicontentFields::getFilters() | JROOT/components/com_flexicontent/models/category.php:1041 |
15 | FlexicontentModelCategory->_buildFiltersWhere() | JROOT/components/com_flexicontent/models/category.php:873 |
14 | FlexicontentModelCategory->_buildItemWhere() | JROOT/components/com_flexicontent/models/category.php:459 |
13 | FlexicontentModelCategory->_buildQuery() | JROOT/components/com_flexicontent/models/category.php:301 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT FOUND_ROWS()
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | NULL | No tables used |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.01 ms |
Checking query cache for query | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.20 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 1.00 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
13 | JDatabaseDriver->loadResult() | JROOT/components/com_flexicontent/models/category.php:316 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT i.*, ie.*, u.name as author, ty.name AS typename, ty.alias AS typealias, rel.catid as rel_catid, c.title AS maincat_title, c.alias AS maincat_alias,
CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, c.access as category_access, ty.access as type_access, 1 AS has_access
FROM yk9mw_content AS i JOIN yk9mw_flexicontent_items_ext AS ie
ON ie.item_id = i.id JOIN yk9mw_flexicontent_types AS ty
ON ie.type_id = ty.id JOIN yk9mw_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id JOIN yk9mw_categories AS c
ON c.id = i.catid
LEFT JOIN yk9mw_users AS u
ON u.id = i.created_by
WHERE i.id IN (658,648,652,1573,657,794,663,664,1826,659,1128,1368,793,654,1287,1185,795)
GROUP BY i.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | range | PRIMARY,idx_catid | PRIMARY | 4 | NULL | 17 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.i.catid | 1 | Using where |
1 | SIMPLE | ie | eq_ref | PRIMARY,type_id | PRIMARY | 4 | admin_narayani.i.id | 1 | |
1 | SIMPLE | ty | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.ie.type_id | 1 | Using index condition |
1 | SIMPLE | rel | ref | itemid | itemid | 4 | admin_narayani.i.id | 1 | Using index condition |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.i.created_by | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.12 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/models/category.php:351 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT a.id as id, k.id as original_id
FROM yk9mw_associations AS a JOIN yk9mw_associations AS k
ON a.`key`=k.`key` JOIN yk9mw_content AS i
ON i.id = k.id
AND i.language = 'en-GB'
WHERE a.id IN (658,648,652,1573,657,794,663,664,1826,659,1128,1368,793,654,1287,1185,795)
AND a.context = "com_content.item"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 | Using where |
1 | SIMPLE | i | ref | PRIMARY,idx_language | idx_language | 21 | const | 1 | Using where; Using index |
1 | SIMPLE | k | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.13 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.37 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.35 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.19 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.55 ms |
Waiting for query cache lock | 0.02 ms |
Sending data | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.83 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.17 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.helper.php:6513 |
13 | flexicontent_db::getOriginalContentItemids() | JROOT/components/com_flexicontent/models/category.php:362 |
12 | FlexicontentModelCategory->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:77 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT DISTINCT LOWER(SUBSTRING(i.title
FROM 1 FOR 1)) AS alpha
FROM yk9mw_flexicontent_items_tmp AS i JOIN yk9mw_flexicontent_types AS ty
ON i.type_id = ty.id JOIN yk9mw_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id JOIN yk9mw_categories AS c
ON c.id = i.catid
WHERE 1
AND rel.catid IN ('92')
AND ( i.state IN (1, -5) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) )
AND ty.access IN (0,1,1,5)
AND c.access IN (0,1,1,5)
AND i.access IN (0,1,1,5)
ORDER BY alpha ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rel | ref | PRIMARY,catid,itemid | PRIMARY | 4 | const | 42 | Using index; Using temporary; **Using filesort** |
1 | SIMPLE | i | eq_ref | PRIMARY,state,catid,access,type_id | PRIMARY | 4 | admin_narayani.rel.itemid | 1 | Using index condition; Using where |
1 | SIMPLE | ty | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.i.type_id | 1 | Using where; Distinct |
1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | admin_narayani.i.catid | 1 | Using where; Distinct |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.15 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.05 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
13 | JDatabaseDriver->loadColumn() | JROOT/components/com_flexicontent/models/category.php:2157 |
12 | FlexicontentModelCategory->getAlphaindex() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_flexicontent/views/category/view.html.php:84 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT DISTINCT t.id, t.name, i.itemid,
CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
FROM yk9mw_flexicontent_tags AS t JOIN yk9mw_flexicontent_tags_item_relations AS i
ON i.tid = t.id
WHERE i.itemid IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
AND t.published = 1
ORDER BY t.name
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.95 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.15 ms |
Updating status | 0.02 ms |
Reset for next command | 0.03 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1019 |
13 | FlexicontentFields::_getTags() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:305 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT DISTINCT c.id, c.title, rel.itemid,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM yk9mw_categories AS c JOIN yk9mw_flexicontent_cats_item_relations AS rel
ON rel.catid = c.id
WHERE rel.itemid IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rel | range | PRIMARY,catid,itemid | itemid | 4 | NULL | 35 | Using index condition; Using temporary |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.rel.catid | 1 |
Status | Duration |
---|---|
Starting | 0.19 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1061 |
13 | FlexicontentFields::_getCategories() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:306 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT itemid, COUNT(id) AS favs
FROM yk9mw_flexicontent_favourites
WHERE itemid IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
GROUP BY itemid
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1089 |
13 | FlexicontentFields::_getFavourites() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:307 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT itemid, COUNT(id) AS fav
FROM yk9mw_flexicontent_favourites
WHERE itemid IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
AND userid = '0'
GROUP BY itemid
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.00 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1115 |
13 | FlexicontentFields::_getFavoured() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:308 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email
FROM yk9mw_content AS i
LEFT JOIN yk9mw_users AS u
ON u.id = i.created_by
WHERE i.id IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | range | PRIMARY | PRIMARY | 4 | NULL | 17 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.i.created_by | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.00 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.09 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1167 |
13 | FlexicontentFields::_getAuthors() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:309 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT i.id, u.name, u.username, u.email
FROM yk9mw_content AS i
LEFT JOIN yk9mw_users AS u
ON u.id = i.modified_by
WHERE i.id IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | range | PRIMARY | PRIMARY | 4 | NULL | 17 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.i.modified_by | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.11 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.00 ms |
Storing result in query cache | 0.12 ms |
Reset for next command | 0.02 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1141 |
13 | FlexicontentFields::_getModifiers() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:310 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, name
FROM yk9mw_flexicontent_types
WHERE id IN ('12')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_flexicontent_types | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.00 ms |
Checking query cache for query | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.16 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.33 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.03 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1191 |
13 | FlexicontentFields::_getTypenames() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:311 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_content_rating
WHERE content_id IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_content_rating | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 45 | Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1219 |
13 | FlexicontentFields::_getVotes() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:312 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *, field_id as extra_id
FROM yk9mw_flexicontent_items_extravote
WHERE content_id IN ('658','648','652','1573','657','794','663','664','1826','659','1128','1368','793','654','1287','1185','795')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.11 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1225 |
13 | FlexicontentFields::_getVotes() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:312 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT field_id, value, item_id, valueorder, suborder
FROM yk9mw_flexicontent_fields_item_relations
WHERE item_id IN (658,648,652,1573,657,794,663,664,1826,659,1128,1368,793,654,1287,1185,795)
AND value > ""
ORDER BY item_id, field_id, valueorder, suborder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_flexicontent_fields_item_relations | range | item_id,value | item_id | 4 | NULL | 60 | Using index condition; Using where; **Using filesort** |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:954 |
13 | FlexicontentFields::_getCustomValues() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:313 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT fi.*,
CASE WHEN fi.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_access
FROM yk9mw_flexicontent_fields AS fi JOIN yk9mw_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
AND ftrel.type_id = 12
WHERE fi.published = 1
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | ftrel | ref | PRIMARY,field_id,type_id | type_id | 4 | const | 41 | Using temporary; **Using filesort** |
1 | SIMPLE | fi | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.ftrel.field_id | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.15 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:350 |
12 | FlexicontentFields::getItemFields() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM yk9mw_flexicontent_templates
WHERE template = 'default'
AND layout = 'category'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_flexicontent_templates | ref | PRIMARY | PRIMARY | 152 | const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.18 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.helper.php:4937 |
13 | flexicontent_tmpl::getFieldsByPositions() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:819 |
12 | FlexicontentFields::renderPositions() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:181 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT field_type
FROM yk9mw_flexicontent_fields
WHERE iscore=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_flexicontent_fields | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 58 | Using where |
Status | Duration |
---|---|
Starting | 0.20 ms |
Waiting for query cache lock | 0.06 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.02 ms |
# | **Caller** | **File and line number** |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
16 | JDatabaseDriver->loadColumn() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1346 |
15 | FlexicontentFields::_getTypeToCoreFieldParams() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1264 |
14 | FlexicontentFields::loadFieldConfig() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:554 |
13 | FlexicontentFields::renderField() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:843 |
12 | FlexicontentFields::renderPositions() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:181 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT t.attribs, t.name, t.alias
FROM yk9mw_flexicontent_types AS t
WHERE t.id = 12
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
16 | JDatabaseDriver->loadObject() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1356 |
15 | FlexicontentFields::_getTypeToCoreFieldParams() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1264 |
14 | FlexicontentFields::loadFieldConfig() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:554 |
13 | FlexicontentFields::renderField() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:843 |
12 | FlexicontentFields::renderPositions() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:181 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT attribs, published
FROM yk9mw_flexicontent_fields
WHERE name='text_rules under constitution of india-cover'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_flexicontent_fields | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 58 | Using where |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1313 |
14 | FlexicontentFields::loadFieldConfig() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:554 |
13 | FlexicontentFields::renderField() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:843 |
12 | FlexicontentFields::renderPositions() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:181 |
11 | FlexicontentFields::getFields() | JROOT/components/com_flexicontent/views/category/view.html.php:163 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT t.id, t.attribs
FROM yk9mw_flexicontent_types AS t
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 32 |
Status | Duration |
---|---|
Starting | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.02 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.16 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.helper.php:5822 |
11 | flexicontent_db::getTypeAttribs() | JROOT/components/com_flexicontent/views/category/view.html.php:435 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, title
FROM yk9mw_viewlevels
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_viewlevels | index | NULL | idx_assetgroup_title_lookup | 302 | NULL | 6 | Using index |
Status | Duration |
---|---|
Starting | 0.19 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.29 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.helper.php:5784 |
12 | flexicontent_db::getAccessNames() | JROOT/components/com_flexicontent/classes/flexicontent.helper.php:4097 |
11 | flexicontent_html::calculateItemMarkups() | JROOT/components/com_flexicontent/views/category/view.html.php:516 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT f.*
FROM yk9mw_flexicontent_fields AS f
WHERE f.published = 1
AND f.field_type = "fieldgroup"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 58 | Using where |
Status | Duration |
---|---|
Starting | 0.16 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/classes/flexicontent.fields.php:4092 |
20 | FlexicontentFields::getFieldsPerGroup() | JROOT/components/com_flexicontent/tmpl_common/filters.php:24 |
19 | include JROOT/components/com_flexicontent/tmpl_common/filters.php | JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php:16 |
18 | include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php | JROOT/components/com_flexicontent/tmpl_common/listings_filter_form.php:7 |
17 | include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form.php | JROOT/components/com_flexicontent/templates/default/category_items.php:44 |
16 | include JROOT/components/com_flexicontent/templates/default/category_items.php | JROOT/libraries/legacy/view/legacy.php:677 |
15 | JViewLegacy->loadTemplate() | JROOT/components/com_flexicontent/tmpl_common/category.php:133 |
14 | include JROOT/components/com_flexicontent/tmpl_common/category.php | JROOT/components/com_flexicontent/templates/default/category.php:3 |
13 | include JROOT/components/com_flexicontent/templates/default/category.php | JROOT/libraries/legacy/view/legacy.php:677 |
12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:216 |
11 | JViewLegacy->display() | JROOT/components/com_flexicontent/views/category/view.html.php:906 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT t.attribs, t.id
FROM yk9mw_flexicontent_types AS t
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 32 |
Status | Duration |
---|---|
Starting | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.14 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/helpers/route.php:313 |
18 | FlexicontentHelperRoute::_getTypeParams() | JROOT/components/com_flexicontent/helpers/route.php:397 |
17 | FlexicontentHelperRoute::getItemRoute() | JROOT/components/com_flexicontent/templates/default/category_items.php:209 |
16 | include JROOT/components/com_flexicontent/templates/default/category_items.php | JROOT/libraries/legacy/view/legacy.php:677 |
15 | JViewLegacy->loadTemplate() | JROOT/components/com_flexicontent/tmpl_common/category.php:133 |
14 | include JROOT/components/com_flexicontent/tmpl_common/category.php | JROOT/components/com_flexicontent/templates/default/category.php:3 |
13 | include JROOT/components/com_flexicontent/templates/default/category.php | JROOT/libraries/legacy/view/legacy.php:677 |
12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:216 |
11 | JViewLegacy->display() | JROOT/components/com_flexicontent/views/category/view.html.php:906 |
10 | FlexicontentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_flexicontent/controller.php:1036 |
8 | FlexicontentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_flexicontent/flexicontent.php:199 |
6 | require_once JROOT/components/com_flexicontent/flexicontent.php | JROOT/libraries/cms/component/helper.php:405 |
5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yk9mw_modules AS m
LEFT JOIN yk9mw_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yk9mw_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-06-12 04:10:58')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-06-12 04:10:58')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 536 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where; Using temporary; **Using filesort** |
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | newsfeeds | 154 | admin_narayani.e.element,const | 1 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | admin_narayani.m.id | 1 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.16 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
17 | JDatabaseDriver->loadObjectList() | **Same as call in the line below.** |
16 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
15 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:425 |
14 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:361 |
13 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
12 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:501 |
11 | JDocumentHtml->countModules() | JROOT/plugins/system/helix3/core/helix3.php:502 |
10 | Helix3::countModules() | JROOT/plugins/system/helix3/core/helix3.php:458 |
9 | Helix3::rowColumns() | JROOT/plugins/system/helix3/core/helix3.php:222 |
8 | Helix3::generatelayout() | JROOT/templates/lt_law/index.php:267 |
7 | require JROOT/templates/lt_law/index.php | JROOT/libraries/joomla/document/html.php:578 |
6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:640 |
5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:455 |
4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1072 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SHOW TABLES LIKE "yk9mw_virtuemart_configs"
Status | Duration |
---|---|
Starting | 0.19 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 1.89 ms |
Creating sort index | 0.12 ms |
Removing tmp table | 0.24 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.19 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:724 |
13 | VmTable::checkTableExists() | JROOT/administrator/components/com_virtuemart/models/config.php:574 |
12 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:415 |
11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:22 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `config`
FROM `yk9mw_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_virtuemart_configs | system | PRIMARY | **NO INDEX KEY COULD BE USED** | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.26 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
checking permissions | 0.68 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
12 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:455 |
11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:22 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id
FROM yk9mw_assets
WHERE parent_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_assets | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 10080 | Using where |
Status | Duration |
---|---|
Starting | 0.20 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.11 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/table/nested.php:1210 |
16 | JTableNested->getRootId() | JROOT/libraries/joomla/access/access.php:158 |
15 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
14 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:145 |
13 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:85 |
12 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:477 |
11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:22 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT a.rules
FROM yk9mw_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 10080 | Using where |
Status | Duration |
---|---|
Starting | 0.27 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
16 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:176 |
15 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
14 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:145 |
13 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/helpers/config.php:85 |
12 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:477 |
11 | VmConfig::loadConfig() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:22 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT *
FROM `yk9mw_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 | yk9mw_virtuemart_shoppergroups | ref | virtuemart_vendor_id,shared,published | published | 1 | const | 2 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100 |
17 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 |
16 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:180 |
15 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
14 | VirtueMartModelUser->getCurrentUser() | JROOT/administrator/components/com_virtuemart/models/product.php:951 |
13 | VirtueMartModelProduct::getCurrentUserShopperGrps() | JROOT/administrator/components/com_virtuemart/models/product.php:500 |
12 | VirtueMartModelProduct->sortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:1837 |
11 | VirtueMartModelProduct->getProductListing() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:99 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `yk9mw_virtuemart_shoppergroups`.*
FROM `yk9mw_virtuemart_shoppergroups`
WHERE `yk9mw_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | yk9mw_virtuemart_shoppergroups | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.18 ms |
Waiting for query cache lock | 0.02 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.09 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
21 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1045 |
20 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1033 |
19 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50 |
18 | VirtueMartModelShopperGroup->getShopperGroup() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105 |
17 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 |
16 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:180 |
15 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
14 | VirtueMartModelUser->getCurrentUser() | JROOT/administrator/components/com_virtuemart/models/product.php:951 |
13 | VirtueMartModelProduct::getCurrentUserShopperGrps() | JROOT/administrator/components/com_virtuemart/models/product.php:500 |
12 | VirtueMartModelProduct->sortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:1837 |
11 | VirtueMartModelProduct->getProductListing() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:99 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT p.`virtuemart_product_id`, l.product_name
FROM `yk9mw_virtuemart_products` as p
LEFT JOIN `yk9mw_virtuemart_products_en_gb` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `yk9mw_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `yk9mw_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `yk9mw_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ((p.`product_parent_id` = "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")
AND ((p.`product_parent_id` > "0"
AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`product_special`="1"
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` ASC, `product_name` ASC
LIMIT 0, 6
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | p | ref | product_parent_id,product_special,published | product_special | 1 | const | 1 | Using where; Using temporary; **Using filesort** |
1 | SIMPLE | l | eq_ref | PRIMARY | PRIMARY | 4 | admin_narayani.p.virtuemart_product_id | 1 | |
1 | SIMPLE | ps | ref | virtuemart_product_id | virtuemart_product_id | 4 | admin_narayani.p.virtuemart_product_id | 1 | Using where; Using index |
1 | SIMPLE | pc | ref | virtuemart_product_id | virtuemart_product_id | 4 | admin_narayani.p.virtuemart_product_id | 1 | Using where |
1 | SIMPLE | pp | ref | virtuemart_product_id | virtuemart_product_id | 4 | admin_narayani.p.virtuemart_product_id | 2 | Using index |
Status | Duration |
---|---|
Starting | 0.21 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
14 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:857 |
13 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:803 |
12 | VirtueMartModelProduct->sortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/product.php:1837 |
11 | VirtueMartModelProduct->getProductListing() | JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:99 |
10 | include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug, mc.`mf_category_name`,mmex.virtuemart_media_id
FROM `yk9mw_virtuemart_manufacturers` as m
LEFT JOIN `yk9mw_virtuemart_manufacturers_en_gb` as l
ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id`
LEFT JOIN `yk9mw_virtuemart_manufacturercategories_en_gb` AS mc
on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id`
LEFT JOIN `yk9mw_virtuemart_manufacturer_medias` as mmex
ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`
WHERE `m`.`published` = 1
GROUP BY `m`.`virtuemart_manufacturer_id`
ORDER BY mf_name ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.21 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **Caller** | **File and line number** |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:861 |
12 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/manufacturer.php:183 |
11 | VirtueMartModelManufacturer->getManufacturers() | JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php:29 |
10 | include JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php | JROOT/libraries/cms/module/helper.php:199 |
9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT m.*
FROM yk9mw_modules AS m
LEFT JOIN yk9mw_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.client_id = 0
AND m.id = 44
AND m.access IN (1,1,5)
AND m.published = 1
AND e.enabled = 1
ORDER BY m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | const | PRIMARY,published,newsfeeds | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | e | ALL | NULL | **NO INDEX KEY COULD BE USED** | NULL | NULL | 386 | Using where |
Status | Duration |
---|---|
Starting | 0.22 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.13 ms |
Updating status | 0.01 ms |
Reset for next command | 0.02 ms |
# | **Caller** | **File and line number** |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
15 | JDatabaseDriver->loadObject() | JROOT/plugins/system/modulesanywhere/helper.php:568 |
14 | PlgSystemModulesAnywhereHelper->processModule() | JROOT/plugins/system/modulesanywhere/helper.php:468 |
13 | PlgSystemModulesAnywhereHelper->processMatch() | JROOT/plugins/system/modulesanywhere/helper.php:350 |
12 | PlgSystemModulesAnywhereHelper->replace() | JROOT/plugins/system/modulesanywhere/helper.php:306 |
11 | PlgSystemModulesAnywhereHelper->processModules() | JROOT/plugins/system/modulesanywhere/helper.php:223 |
10 | PlgSystemModulesAnywhereHelper->replaceTags() | JROOT/plugins/system/modulesanywhere/helper.php:160 |
9 | PlgSystemModulesAnywhereHelper->onAfterRender() | JROOT/plugins/system/modulesanywhere/modulesanywhere.php:63 |
8 | PlgSystemModulesAnywhere->onAfterRender() | **Same as call in the line below.** |
7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1092 |
3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
**2 × SELECT `extension_id`
FROM `yk9mw_extensions`**
**2 × SELECT a.rules
FROM yk9mw_assets AS a**
**2 × SELECT template
FROM yk9mw_template_styles as s**
**2 × SELECT *
FROM yk9mw_extensions**
**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `yk9mw_extensions`**
**1 × SELECT field_id, value, item_id, valueorder, suborder
FROM yk9mw_flexicontent_fields_item_relations**
**1 × SELECT fi.*,
CASE WHEN fi.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_access
FROM yk9mw_flexicontent_fields AS fi JOIN yk9mw_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
AND ftrel.type_id = 12**
**1 × SELECT *
FROM yk9mw_flexicontent_templates**
**1 × SELECT field_type
FROM yk9mw_flexicontent_fields**
**1 × SELECT *, field_id as extra_id
FROM yk9mw_flexicontent_items_extravote**
**1 × SELECT *
FROM yk9mw_content_rating**
**1 × SELECT itemid, COUNT(id) AS fav
FROM yk9mw_flexicontent_favourites**
**1 × SELECT itemid, COUNT(id) AS favs
FROM yk9mw_flexicontent_favourites**
**1 × SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email
FROM yk9mw_content AS i
LEFT JOIN yk9mw_users AS u
ON u.id = i.created_by**
**1 × SELECT i.id, u.name, u.username, u.email
FROM yk9mw_content AS i
LEFT JOIN yk9mw_users AS u
ON u.id = i.modified_by**
**1 × SELECT id, name
FROM yk9mw_flexicontent_types**
**1 × SELECT t.attribs, t.name, t.alias
FROM yk9mw_flexicontent_types AS t**
**1 × SELECT attribs, published
FROM yk9mw_flexicontent_fields**
**1 × SELECT id
FROM yk9mw_assets**
**1 × SELECT `config`
FROM `yk9mw_virtuemart_configs`**
**1 × SELECT *
FROM `yk9mw_virtuemart_shoppergroups`**
**1 × SELECT `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug, mc.`mf_category_name`,mmex.virtuemart_media_id
FROM `yk9mw_virtuemart_manufacturers` as m
LEFT JOIN `yk9mw_virtuemart_manufacturers_en_gb` as l
ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id`
LEFT JOIN `yk9mw_virtuemart_manufacturercategories_en_gb` AS mc
on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id`
LEFT JOIN `yk9mw_virtuemart_manufacturer_medias` as mmex
ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`**
**1 × SELECT `yk9mw_virtuemart_shoppergroups`.*
FROM `yk9mw_virtuemart_shoppergroups`**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yk9mw_modules AS m
LEFT JOIN yk9mw_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yk9mw_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT t.attribs, t.id
FROM yk9mw_flexicontent_types AS**
**1 × SELECT DISTINCT c.id, c.title, rel.itemid,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM yk9mw_categories AS c JOIN yk9mw_flexicontent_cats_item_relations AS rel
ON rel.catid = c.id**
**1 × SELECT t.id, t.attribs
FROM yk9mw_flexicontent_types AS**
**1 × SELECT m.*
FROM yk9mw_modules AS m
LEFT JOIN yk9mw_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT id, title
FROM yk9mw_viewlevel**
**1 × SELECT f.*
FROM yk9mw_flexicontent_fields AS f**
**1 × SELECT p.`virtuemart_product_id`, l.product_name
FROM `yk9mw_virtuemart_products` as p
LEFT JOIN `yk9mw_virtuemart_products_en_gb` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `yk9mw_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `yk9mw_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `yk9mw_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`**
**1 × SELECT i.*, ie.*, u.name as author, ty.name AS typename, ty.alias AS typealias, rel.catid as rel_catid, c.title AS maincat_title, c.alias AS maincat_alias,
CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, c.access as category_access, ty.access as type_access, 1 AS has_access
FROM yk9mw_content AS i JOIN yk9mw_flexicontent_items_ext AS ie
ON ie.item_id = i.id JOIN yk9mw_flexicontent_types AS ty
ON ie.type_id = ty.id JOIN yk9mw_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id JOIN yk9mw_categories AS c
ON c.id = i.catid
LEFT JOIN yk9mw_users AS u
ON u.id = i.created_by**
**1 × SELECT id, checked_out, checked_out_time
FROM yk9mw_modules**
**1 × SELECT id, checked_out, checked_out_time
FROM yk9mw_categories**
**1 × SELECT id, checked_out, checked_out_time
FROM yk9mw_menu**
**1 × SELECT *
FROM yk9mw_axisubs_configuration**
**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM yk9mw_menu AS m
LEFT JOIN yk9mw_extensions AS e
ON m.component_id = e.extension_id**
**1 × SELECT id, checked_out, checked_out_time
FROM yk9mw_content**
**1 × SELECT DISTINCT userid
FROM yk9mw_session**
**1 × SELECT id, rules
FROM `yk9mw_viewlevels**
**1 × SELECT b.id
FROM yk9mw_usergroups AS a
LEFT JOIN yk9mw_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt**
**1 × SELECT folder AS type, element AS name, params
FROM yk9mw_extensions**
**1 × SELECT lft,rgt
FROM yk9mw_categories**
**1 × SELECT extension, file, type
FROM yk9mw_rokcommon_configs**
**1 × SELECT *
FROM yk9mw_languages**
**1 × SELECT id, home, template, s.params
FROM yk9mw_template_styles as s
LEFT JOIN yk9mw_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT FOUND_ROWS(**
**1 × SELECT fi.*
FROM yk9mw_flexicontent_fields AS fi**
**1 × SELECT `data`
FROM `yk9mw_session`**
**1 × SELECT a.id as id, k.id as original_id
FROM yk9mw_associations AS a JOIN yk9mw_associations AS k
ON a.`key`=k.`key` JOIN yk9mw_content AS i
ON i.id = k.id
AND i.language = 'en-GB'**
**1 × SELECT DISTINCT LOWER(SUBSTRING(i.title
FROM 1 FOR 1)) AS alpha
FROM yk9mw_flexicontent_items_tmp AS i JOIN yk9mw_flexicontent_types AS ty
ON i.type_id = ty.id JOIN yk9mw_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id JOIN yk9mw_categories AS c
ON c.id = i.catid**
**1 × SELECT a.name, a.rules
FROM yk9mw_assets AS a**
**1 × SELECT element
FROM yk9mw_extensions**
**1 × SELECT attribs, layout, template
FROM yk9mw_flexicontent_layouts_con**
**1 × SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug
FROM yk9mw_categories AS c
LEFT JOIN yk9mw_users AS u
ON u.id = c.created_user_id**
**1 × SELECT c.id
FROM yk9mw_categories AS c**
**1 × SELECT *
FROM yk9mw_assets**
**1 × SELECT DISTINCT t.id, t.name, i.itemid,
CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
FROM yk9mw_flexicontent_tags AS t JOIN yk9mw_flexicontent_tags_item_relations AS i
ON i.tid = t.id**
**1 × SHOW TABLES LIKE "yk9mw_virtuemart_configs**
**1 × SHOW FULL COLUMNS
FROM `yk9mw_assets**
**1 × SHOW VARIABLES LIKE '%ft_min_word_len%**
**1 × UPDATE `yk9mw_extensions`
SET `params` = '{\"mediaversion\":\"02ef165f08beba3743bf8ffd6f81be38\"}'**
**1 × SHOW FULL COLUMNS
FROM `yk9mw_extensions**
# JROOT/administrator/components/com_virtuemart/helpers/vmtable.php COM_VIRTUEMART_VIRTUEMART_USER_ID="VIRTUEMART VIRTUEMART USER ID??" COM_VIRTUEMART_VIRTUEMART_USER_ID="VIRTUEMART VIRTUEMART USER ID" # JROOT/components/com_flexicontent/models/category.php AMENDMENTS="Amendments" EXTENSION="Extension" NOTIFICATIONS="Notifications" RULES="Rules" # JROOT/components/com_flexicontent/classes/flexicontent.fields.php DESCRIPTION="Description" MAIN_DESCRIPTION_TEXT_INTROTEXTFULLTEXT="description text (introtext/fulltext)" # JROOT/libraries/cms/pagination/pagination.php FIRST="First" LAST="Last" NEXT="Next" PREV="Prev" # JROOT/libraries/legacy/view/legacy.php FLEXI_HIDE="HIDE" FLEXI_TMPL_DEFAULT_COLUMNS_FE="TMPL DEFAULT COLUMNS FE" # JROOT/components/com_flexicontent/templates/default/category_items.php FLEXI_NOT_AN_IMAGE_FILE="NOT AN IMAGE FILE" # JROOT/components/com_flexicontent/classes/flexicontent.helper.php GUEST="Guest" PAYTOVIEW="paytoview" PUBLIC="Public" REGISTERED="Registered" SPECIAL="Special" SUPER_USERS="Users" # JROOT/libraries/rokcommon/RokCommon/I18N/Joomla.php LOADING_CONTAINER_CONFIG_FILE_FOR_S_FROM_S="container config file for %s from %s" REGISTERING_LIBRARY_PATH_S_FOR_S="library path %s for %s"