
Institutional Products

White Magik
Dairy Creamer
- Most preferred brand in tea and coffee premix industry
- All purpose dairy creamer with long shelf life
- High solubility and superior whitening ability
- Consistent quality and rich taste


Umang SMP
Skimmed Milk Powder
- Made with the finest quality buffalo milk
- High protein content (34%)
- Ideal for bakery products like biscuits, cookies and cakes
- Amongst the most popular brands overseas

Umang WMP
Whole Milk Powder
- High fat and protein content (26%+)
- Ideal for toppings and icings
- Trusted name in infant food, confectionery and nutraceuticals industry

Umang
Danedar Shudh Ghee
- Swadisht and khushbudar ghee - enhances the taste and aroma of every dish
- Special care is taken to make Umang as danedar as home-made ghee
- Preferred by all leading private label players like Big Bazaar, More Megastore and Spencer’s


JK DAIRY STAR
Premium Skimmed Milk Powder
- Made with the finest quality buffalo milk
- High protein content (35%+)
- High yield of khoya, chhena, paneer and curd
- Soft and white chhena with large granules

Umang Butter
Table Butter
- Table Butter contains minimum 80% fat
- Cooking Butter contains minimum 80% fat
- Unsalted Butter contains minimum 84% fat
- Rich in taste and flavor
- Ideal for spreads, toppings and cooking
- Preferred product for premium bakery products
- Trusted name in HORECA and bakery segment


Umang Dairy Creamer
All Purpose Dairy Creamer
- Contains 8% fat
- Great for making creamy delicious sweets, desserts, ice cream, milk shakes and curd
- God for tea &mps; coffee - preferred by tea vendors
**Joomla! Debug Console**
{ "__default": { "session": { "counter": 1, "timer": { "start": 1680024092, "last": 1680024092, "now": 1680024092 } }, "registry": {}, "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 } } }
**Time**
**Memory**
**Time**: 26.70 ms / 26.70 ms **Memory**: 1.777 MB / 2.01 MB Application: afterLoad
**Time**: 77.26 ms / 103.95 ms **Memory**: 8.700 MB / 10.71 MB Application: afterInitialise
**Time**: 14.72 ms / 118.68 ms **Memory**: 1.470 MB / 12.18 MB Application: afterRoute
**Time**: 12.91 ms / 131.58 ms **Memory**: 0.469 MB / 12.65 MB Application: beforeRenderComponent com_content
**Time**: 8.70 ms / 140.29 ms **Memory**: 0.667 MB / 13.32 MB Application: Before Access::preloadComponents (all components)
**Time**: 2.30 ms / 142.59 ms **Memory**: 0.109 MB / 13.42 MB Application: After Access::preloadComponents (all components)
**Time**: 0.07 ms / 142.65 ms **Memory**: 0.000 MB / 13.42 MB Application: Before Access::getAssetRules (id:8 name:com_content)
**Time**: 0.76 ms / 143.41 ms **Memory**: 0.046 MB / 13.47 MB Application: After Access::getAssetRules (id:8 name:com_content)
**Time**: 51.03 ms / 194.44 ms **Memory**: 3.419 MB / 16.88 MB Application: afterRenderComponent com_content
**Time**: 1.47 ms / 195.91 ms **Memory**: 0.185 MB / 17.07 MB Application: afterDispatch
**Time**: 26.29 ms / 222.20 ms **Memory**: 0.913 MB / 17.98 MB Application: afterRender
**Database queries total: 32.81 ms**
18**.**66 MB (19**,**566**,**664 **Bytes**)
**37 Queries Logged** 32.81 ms
- **Query Time: 0.51 ms** **Query memory: 0.021 MB Memory before query: 4.232 MB** **Rows returned: 0**
SELECT `data`
FROM `umng_session`
WHERE `session_id` = '1iumrg5jsbna2nf3m6uiiuo1a3'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() **Same as call in the line below.** 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:831 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **Query Time: 0.34 ms** **After last query: 1.84 ms** **Query memory: 0.012 MB Memory before query: 4.384 MB** **Rows returned: 0**
SELECT `session_id`
FROM `umng_session`
WHERE `session_id` = '1iumrg5jsbna2nf3m6uiiuo1a3'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 7 JDatabaseDriver->loadResult() JROOT/libraries/src/Application/CMSApplication.php:178 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **Query Time: 2.47 ms** **After last query: 0.22 ms** **Query memory: 0.009 MB Memory before query: 4.399 MB**
INSERT INTO `umng_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('1iumrg5jsbna2nf3m6uiiuo1a3', 1, '1680024092', 0, '', 0)**EXPLAIN not possible on query: INSERT INTO `umng_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('1iumrg5jsbna2nf3m6uiiuo1a3', 1, '1680024092', 0, '', 0)**Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.19 ms end 0.11 ms query end 1.91 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:218 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:833 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **Query Time: 1.03 ms** **After last query: 3.16 ms** **Query memory: 0.020 MB Memory before query: 4.720 MB** **Rows returned: 36**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `umng_extensions`
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_extensions NULL ref extension extension 82 const 36 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.41 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # **Caller** **File and line number** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:422 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() **Same as call in the line below.** 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:430 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:496 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:596 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.46 ms** **After last query: 3.03 ms** **Query memory: 0.014 MB Memory before query: 5.020 MB** **Rows returned: 5**
SELECT id, rules
FROM `umng_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_viewlevels NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 5 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.52 ms** **After last query: 0.21 ms** **Query memory: 0.015 MB Memory before query: 5.044 MB** **Rows returned: 2**
SELECT b.id
FROM umng_usergroups AS a
LEFT JOIN umng_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 1.45 ms** **After last query: 0.85 ms** **Query memory: 0.021 MB Memory before query: 5.139 MB** **Rows returned: 63**
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM umng_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_extensions NULL ref extension extension 82 const 77 0.60 Using index condition; Using where; **Using filesort** Status Duration starting 0.15 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.79 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() **Same as call in the line below.** 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:348 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 1.81 ms** **After last query: 31.36 ms** **Query memory: 0.037 MB Memory before query: 11.053 MB** **Rows returned: 56**
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 umng_menu AS m
LEFT JOIN umng_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 60 10.00 Using index condition; Using where; **Using filesort** 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 umangdai_umang.m.component_id 1 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.64 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # **Caller** **File and line number** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() **Same as call in the line below.** 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1146 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.66 ms** **After last query: 10.87 ms** **Query memory: 0.020 MB Memory before query: 12.253 MB** **Rows returned: 1**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `umng_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() **Same as call in the line below.** 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 2.81 ms** **After last query: 0.35 ms** **Query memory: 0.012 MB Memory before query: 12.270 MB**
UPDATE `umng_extensions`
SET `params` = '{\"mediaversion\":\"3c8e4b1c3ecb55ba0c17ee492a1e5e74\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE umng_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.06 ms Opening tables 0.02 ms init 0.02 ms System lock 0.08 ms updating 0.11 ms end 0.01 ms query end 2.33 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # **Caller** **File and line number** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.66 ms** **After last query: 5.45 ms** **Query memory: 0.014 MB Memory before query: 12.599 MB** **Rows returned: 1**
SELECT *
FROM umng_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_languages NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 1 100.00 Using where; **Using filesort** Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.05 ms Creating sort index 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.80 ms** **After last query: 1.02 ms** **Query memory: 0.010 MB Memory before query: 12.637 MB** **Rows returned: 3**
SELECT id, home, template, s.params
FROM umng_template_styles as s
LEFT JOIN umng_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template **NO INDEX KEY COULD BE USED** NULL NULL 5 20.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 umangdai_umang.s.template,const 1 4.59 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.16 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # **Caller** **File and line number** 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 1.75 ms** **After last query: 9.56 ms** **Query memory: 0.026 MB Memory before query: 13.347 MB** **Rows returned: 33**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `umng_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_applicants','com_associations','com_banners','com_cache','com_career','com_categories','com_checkin','com_config','com_contact_form','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_press_release','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_assets NULL ALL idx_asset_name **NO INDEX KEY COULD BE USED** NULL NULL 119 30.25 Using where Status Duration starting 0.19 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.15 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.40 ms preparing 0.03 ms executing 0.01 ms Sending data 0.69 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 1.30 ms** **After last query: 2.11 ms** **Query memory: 0.025 MB Memory before query: 13.572 MB** **Rows returned: 30**
SHOW FULL COLUMNS
FROM `umng_content`**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `umng_content`**Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.03 ms checking permissions 0.08 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.80 ms** **After last query: 4.17 ms** **Query memory: 0.034 MB Memory before query: 13.994 MB** **Rows returned: 1**
SELECT *
FROM umng_content
WHERE `id` = '3'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.22 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 2.49 ms** **After last query: 0.26 ms** **Query memory: 0.014 MB Memory before query: 14.045 MB**
UPDATE umng_content
SET `hits` = (`hits` + 1)
WHERE `id` = '3'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE umng_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.04 ms updating 0.07 ms end 0.01 ms query end 2.17 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # **Caller** **File and line number** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.82 ms** **After last query: 5.64 ms** **Query memory: 0.028 MB Memory before query: 14.292 MB** **Rows returned: 1**
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM umng_content AS a
INNER JOIN umng_categories AS c
on c.id = a.catid
LEFT JOIN umng_users AS u
on u.id = a.created_by
LEFT JOIN umng_categories as parent
ON parent.id = c.parent_id
LEFT JOIN umng_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 3
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-28 17:21:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-28 17:21:32')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.16 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # **Caller** **File and line number** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.57 ms** **After last query: 7.70 ms** **Query memory: 0.024 MB Memory before query: 14.580 MB** **Rows returned: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `umng_contentitem_tag_map` AS m
INNER JOIN `umng_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type **NO INDEX KEY COULD BE USED** NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 umangdai_umang.m.tag_id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # **Caller** **File and line number** 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:180 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.96 ms** **After last query: 11.21 ms** **Query memory: 0.034 MB Memory before query: 15.431 MB** **Rows returned: 2**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM umng_categories as c
LEFT JOIN umng_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=2
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 **Using filesort** 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right **NO INDEX KEY COULD BE USED** NULL NULL 6 37.03 Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:197 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:400 14 PlgSystemFields->onContentPrepare() **Same as call in the line below.** 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.90 ms** **After last query: 1.00 ms** **Query memory: 0.032 MB Memory before query: 15.557 MB** **Rows returned: 0**
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM umng_fields AS a
LEFT JOIN `umng_languages` AS l
ON l.lang_code = a.language
LEFT JOIN umng_users AS uc
ON uc.id=a.checked_out
LEFT JOIN umng_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN umng_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN umng_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `umng_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; **Using filesort** 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 umangdai_umang.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 umangdai_umang.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 umangdai_umang.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 umangdai_umang.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 umangdai_umang.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 umangdai_umang.a.id 1 100.00 Using where; Using index Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.04 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:400 14 PlgSystemFields->onContentPrepare() **Same as call in the line below.** 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.56 ms** **After last query: 14.18 ms** **Query memory: 0.013 MB Memory before query: 17.160 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 113id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:134 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.77 ms** **After last query: 0.10 ms** **Query memory: 0.014 MB Memory before query: 17.187 MB** **Rows returned: 7**
SELECT path, title, link
FROM umng_menu
WHERE parent_id = 113
AND published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 89 1.12 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.11 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.33 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 8 JDatabaseDriver->loadAssocList() JROOT/templates/umang/index.php:141 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.30 ms** **After last query: 0.11 ms** **Query memory: 0.013 MB Memory before query: 17.219 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 108id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:152 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.59 ms** **After last query: 0.07 ms** **Query memory: 0.014 MB Memory before query: 17.246 MB** **Rows returned: 9**
SELECT path, title
FROM umng_menu
WHERE parent_id = 108
AND published = 1
ORDER BY lft ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 89 1.12 Using where; **Using filesort** Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 8 JDatabaseDriver->loadAssocList() JROOT/templates/umang/index.php:159 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.36 ms** **After last query: 0.12 ms** **Query memory: 0.013 MB Memory before query: 17.271 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 109id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.12 ms cleaning up 0.02 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:180 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.40 ms** **After last query: 0.07 ms** **Query memory: 0.013 MB Memory before query: 17.298 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 169id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:187 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.58 ms** **After last query: 0.10 ms** **Query memory: 0.013 MB Memory before query: 17.325 MB** **Rows returned: 7**
SELECT path, title
FROM umng_menu
WHERE parent_id = 169
AND published = 1
ORDER BY lft ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 89 1.12 Using where; **Using filesort** Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 8 JDatabaseDriver->loadAssocList() JROOT/templates/umang/index.php:193 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.53 ms** **After last query: 0.09 ms** **Query memory: 0.013 MB Memory before query: 17.349 MB** **Rows returned: 2**
SELECT path, title
FROM umng_menu
WHERE parent_id = 109
AND published = 1
LIMIT 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 89 1.12 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 8 JDatabaseDriver->loadAssocList() JROOT/templates/umang/index.php:204 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.66 ms** **After last query: 0.07 ms** **Query memory: 0.013 MB Memory before query: 17.372 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 110id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.17 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:218 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.32 ms** **After last query: 0.11 ms** **Query memory: 0.013 MB Memory before query: 17.399 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 111id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:226 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.46 ms** **After last query: 0.08 ms** **Query memory: 0.013 MB Memory before query: 17.425 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE parent_id = 111
AND published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 89 1.12 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 8 JDatabaseDriver->loadAssocList() JROOT/templates/umang/index.php:233 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.27 ms** **After last query: 0.12 ms** **Query memory: 0.013 MB Memory before query: 17.450 MB** **Rows returned: 1**
SELECT path, title
FROM umng_menu
WHERE id = 112id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # **Caller** **File and line number** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/templates/umang/index.php:245 7 require JROOT/templates/umang/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 1.47 ms** **After last query: 3.91 ms** **Query memory: 0.020 MB Memory before query: 17.628 MB** **Rows returned: 4**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM umng_modules AS m
LEFT JOIN umng_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN umng_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 <= '2023-03-28 17:21:32')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-28 17:21:32')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 109 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds published 1 const 9 5.56 Using index condition; Using where; **Using filesort** 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 umangdai_umang.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 umangdai_umang.m.id 1 40.00 Using where; Using index Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.10 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.06 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.29 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # **Caller** **File and line number** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() **Same as call in the line below.** 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.53 ms** **After last query: 4.03 ms** **Query memory: 0.023 MB Memory before query: 17.844 MB** **Rows returned: 1**
SELECT `alias`
FROM `umng_content`
WHERE id = '13'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # **Caller** **File and line number** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() **Same as call in the line below.** 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 8 PlgSystemSef->onAfterRender() **Same as call in the line below.** 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 1.03 ms** **After last query: 0.56 ms** **Query memory: 0.032 MB Memory before query: 17.898 MB** **Rows returned: 0**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM umng_categories as c
LEFT JOIN umng_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=13
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL **NO INDEX KEY COULD BE USED** NULL NULL NULL NULL no matching row in const table Status Duration starting 0.24 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # **Caller** **File and line number** 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() **Same as call in the line below.** 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:124 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 8 PlgSystemSef->onAfterRender() **Same as call in the line below.** 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.29 ms** **After last query: 1.09 ms** **Query memory: 0.023 MB Memory before query: 17.945 MB** **Rows returned: 1**
SELECT `alias`
FROM `umng_content`
WHERE id = '52'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE umng_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # **Caller** **File and line number** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() **Same as call in the line below.** 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 8 PlgSystemSef->onAfterRender() **Same as call in the line below.** 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Query Time: 0.59 ms** **After last query: 0.34 ms** **Query memory: 0.032 MB Memory before query: 17.999 MB** **Rows returned: 0**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM umng_categories as c
LEFT JOIN umng_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=52
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL **NO INDEX KEY COULD BE USED** NULL NULL NULL NULL no matching row in const table Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # **Caller** **File and line number** 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() **Same as call in the line below.** 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:124 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 8 PlgSystemSef->onAfterRender() **Same as call in the line below.** 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
**23 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**
**11 × SELECT path, title
FROM umng_menu****3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM umng_categories as c
LEFT JOIN umng_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)****2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `umng_extensions`****2 × SELECT `alias`
FROM `umng_content`****1 × SELECT `m`.`tag_id`,`t`.*
FROM `umng_contentitem_tag_map` AS m
INNER JOIN `umng_tags` AS t
ON `m`.`tag_id` = `t`.`id`****1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM umng_content AS a
INNER JOIN umng_categories AS c
on c.id = a.catid
LEFT JOIN umng_users AS u
on u.id = a.created_by
LEFT JOIN umng_categories as parent
ON parent.id = c.parent_id
LEFT JOIN umng_content_rating AS v
ON a.id = v.content_id****1 × SELECT path, title, link
FROM umng_menu****1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM umng_modules AS m
LEFT JOIN umng_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN umng_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id****1 × SELECT *
FROM umng_content****1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM umng_fields AS a
LEFT JOIN `umng_languages` AS l
ON l.lang_code = a.language
LEFT JOIN umng_users AS uc
ON uc.id=a.checked_out
LEFT JOIN umng_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN umng_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN umng_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `umng_fields_categories` AS fc
ON fc.field_id = a.id****1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `umng_assets`****1 × SELECT b.id
FROM umng_usergroups AS a
LEFT JOIN umng_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt****1 × SELECT id, rules
FROM `umng_viewlevels****1 × SELECT `session_id`
FROM `umng_session`****1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM umng_extensions****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 umng_menu AS m
LEFT JOIN umng_extensions AS e
ON m.component_id = e.extension_id****1 × SELECT id, home, template, s.params
FROM umng_template_styles as s
LEFT JOIN umng_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id****1 × SELECT *
FROM umng_languages****1 × SELECT `data`
FROM `umng_session`**
**OTHER Tables:**
**1 × UPDATE umng_content
SET `hits` = (`hits` + 1)****1 × SHOW FULL COLUMNS
FROM `umng_content****1 × UPDATE `umng_extensions`
SET `params` = '{\"mediaversion\":\"3c8e4b1c3ecb55ba0c17ee492a1e5e74\"}'****1 × INSERT INTO `umng_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('1iumrg5jsbna2nf3m6uiiuo1a3', 1, '1680024092', 0, '', 0**
**0 messages logged**
**None**
- **Loaded** : JROOT/language/en-GB/en-GB.ini
- **Loaded** : JROOT/language/en-GB/en-GB.lib_joomla.ini
- **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_updatenotification.ini
- **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_fields.ini
- **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logout.ini
- **Not loaded** : JROOT/language/en-GB/en-GB.tpl_umang.ini
- **Not loaded** : JROOT/templates/umang/language/en-GB/en-GB.tpl_umang.ini
- **Loaded** : JROOT/language/en-GB/en-GB.com_content.ini
- **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_debug.ini
**None**