Query Time: 4.25 ms
DELETE
FROM `uz0jc_session`
WHERE `time` < '1576497663'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_session | range | time | time | 59 | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
6 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Application/CMSApplication.php:824 |
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.89 ms After last query: 0.63 ms
SELECT `data`
FROM `uz0jc_session`
WHERE `session_id` = 'b49njn73pkf4n6njim8hd664o3'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysql->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: 2.62 ms After last query: 1.28 ms
SELECT `session_id`
FROM `uz0jc_session`
WHERE `session_id` = 'b49njn73pkf4n6njim8hd664o3'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
8 | JDatabaseDriverMysql->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.82 ms After last query: 3.44 ms
INSERT INTO `uz0jc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('b49njn73pkf4n6njim8hd664o3', 1, '1576498563', 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `uz0jc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('b49njn73pkf4n6njim8hd664o3', 1, '1576498563', 0, '', 0)
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysql->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: 2.48 ms After last query: 5.11 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `uz0jc_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_extensions | ref | extension | extension | 82 | const | 43 | 100.00 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:450 |
9 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{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/Component/ComponentHelper.php:458 |
6 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:46 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:114 |
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: 2.90 ms After last query: 2.12 ms
SELECT id, rules
FROM `uz0jc_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysql->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.53 ms After last query: 0.73 ms
SELECT b.id
FROM uz0jc_usergroups AS a
LEFT JOIN uz0jc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->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: 3.38 ms After last query: 0.68 ms
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM uz0jc_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 | filtered | Extra |
---|
1 | SIMPLE | uz0jc_extensions | ref | extension | extension | 82 | const | 98 | 100.00 | Using index condition; Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->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: 0.26 ms After last query: 228.79 ms
SELECT *
FROM `uz0jc_rsseo_redirects`
WHERE `published` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsseo/rsseo.php:144 |
9 | plgSystemRsseo->onAfterInitialise() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:686 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.02 ms After last query: 9.73 ms
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 uz0jc_menu AS m
LEFT JOIN uz0jc_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 | filtered | Extra |
---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 49 | 100.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | wdg20170206.m.component_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysql->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: 5.10 ms After last query: 21.52 ms
SELECT `varname`, `value`, `default`
FROM uz0jc_mt_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 279 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_mtree/config.mtree.class.php:79 |
11 | mtConfig->mtConfig() | JROOT/administrator/components/com_mtree/config.mtree.class.php:31 |
10 | mtFactory::createConfig() | JROOT/administrator/components/com_mtree/config.mtree.class.php:23 |
9 | mtFactory::getConfig() | JROOT/components/com_mtree/init.php:17 |
8 | require_once JROOT/components/com_mtree/init.php | JROOT/components/com_mtree/router.php:12 |
7 | require_once JROOT/components/com_mtree/router.php | JROOT/libraries/src/Router/SiteRouter.php:770 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:130 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
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: 3.65 ms After last query: 4.05 ms
SELECT cat_id, cat_parent, alias
FROM uz0jc_mt_cats
WHERE cat_published='1'
AND cat_approved='1' && BINARY alias = 'flowers-
and-florist'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | dtree | dtree | 2 | const,const | 61 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/router.php:925 |
11 | findCatID() | JROOT/components/com_mtree/router.php:670 |
10 | MtreeParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
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.17 ms After last query: 0.27 ms
SELECT cat_id, cat_parent, metadata, lft, rgt
FROM uz0jc_mt_cats
WHERE cat_id = 20
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mtree/config.mtree.class.php:129 |
12 | mtConfig->setCategory() | JROOT/components/com_mtree/router.php:929 |
11 | findCatID() | JROOT/components/com_mtree/router.php:670 |
10 | MtreeParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
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.11 ms After last query: 0.16 ms
SELECT cat_id, metadata
FROM uz0jc_mt_cats
WHERE lft < 39 && rgt > 40 && cat_parent >= 0
ORDER BY lft ASC
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | range | cat_parent,lft_rgt,func_getPathWay | func_getPathWay | 4 | NULL | 15 | 100.00 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mtree/config.mtree.class.php:144 |
12 | mtConfig->setCategory() | JROOT/components/com_mtree/router.php:929 |
11 | findCatID() | JROOT/components/com_mtree/router.php:670 |
10 | MtreeParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
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: 4.35 ms After last query: 3.40 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `uz0jc_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:40 |
9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1156 |
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: 1.90 ms After last query: 5.11 ms
UPDATE `uz0jc_extensions`
SET `params` = '{\"mediaversion\":\"38ca787bd0192c154296460d9b4250e9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:40 |
9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1156 |
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.87 ms After last query: 4.07 ms
SELECT *
FROM uz0jc_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
13 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
12 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:305 |
11 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:56 |
10 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:45 |
9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1156 |
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: 3.58 ms After last query: 3.45 ms
SELECT id, home, template, s.params
FROM uz0jc_template_styles as s
LEFT JOIN uz0jc_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 | filtered | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 100.00 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 80.00 | Using where; Using join buffer (flat, BNL join) |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
20 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
19 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
18 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
14 | JHtmlJquery::framework() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:79 |
10 | K2HelperHTML::loadjQuery() | JROOT/plugins/system/k2/k2.php:45 |
9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1156 |
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.32 ms After last query: 23.30 ms
SELECT cat_id, cat_parent, metadata, lft, rgt
FROM uz0jc_mt_cats
WHERE cat_id = 20
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
9 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mtree/config.mtree.class.php:129 |
8 | mtConfig->setCategory() | JROOT/components/com_mtree/init.php:24 |
7 | require JROOT/components/com_mtree/init.php | JROOT/components/com_mtree/mtree.php:17 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.36 ms After last query: 0.16 ms
SELECT cat_id, metadata
FROM uz0jc_mt_cats
WHERE lft < 39 && rgt > 40 && cat_parent >= 0
ORDER BY lft ASC
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | range | cat_parent,lft_rgt,func_getPathWay | func_getPathWay | 4 | NULL | 15 | 100.00 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
9 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mtree/config.mtree.class.php:144 |
8 | mtConfig->setCategory() | JROOT/components/com_mtree/init.php:24 |
7 | require JROOT/components/com_mtree/init.php | JROOT/components/com_mtree/mtree.php:17 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.22 ms After last query: 3.48 ms
SELECT cat_name, cat_id, lft, rgt
FROM uz0jc_mt_cats
WHERE cat_id = '20'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
11 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_mtree/admin.mtree.class.php:169 |
10 | mtPathWay::getPathWay() | JROOT/administrator/components/com_mtree/admin.mtree.class.php:196 |
9 | mtPathWay->getPathWayWithCurrentCat() | JROOT/components/com_mtree/mtree.tools.php:760 |
8 | mtAppendCategoriesPathWay() | JROOT/components/com_mtree/mtree.tools.php:645 |
7 | mtAppendPathWay() | JROOT/components/com_mtree/mtree.php:83 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.12 ms After last query: 0.18 ms
SELECT cat_id
FROM uz0jc_mt_cats
WHERE lft < 39
AND rgt > 40
AND cat_id > 0
AND cat_parent >= 0
ORDER BY lft ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | range | cat_id,cat_parent,lft_rgt,func_getPathWay,cat_id_index | func_getPathWay | 4 | NULL | 15 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_mtree/admin.mtree.class.php:174 |
10 | mtPathWay::getPathWay() | JROOT/administrator/components/com_mtree/admin.mtree.class.php:196 |
9 | mtPathWay->getPathWayWithCurrentCat() | JROOT/components/com_mtree/mtree.tools.php:760 |
8 | mtAppendCategoriesPathWay() | JROOT/components/com_mtree/mtree.tools.php:645 |
7 | mtAppendPathWay() | JROOT/components/com_mtree/mtree.php:83 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.28 ms After last query: 0.21 ms
SHOW FULL COLUMNS
FROM `uz0jc_mt_cats`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `uz0jc_mt_cats`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
12 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
11 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
10 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_mtree/admin.mtree.class.php:260 |
9 | mtCats->__construct() | JROOT/components/com_mtree/mtree.tools.php:892 |
8 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:646 |
7 | mtAppendPathWay() | JROOT/components/com_mtree/mtree.php:83 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.17 ms After last query: 1.11 ms
SELECT *
FROM uz0jc_mt_cats
WHERE `cat_id` = '20'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
9 | Joomla\CMS\Table\Table->load() | JROOT/components/com_mtree/mtree.tools.php:893 |
8 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:646 |
7 | mtAppendPathWay() | JROOT/components/com_mtree/mtree.php:83 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.14 ms After last query: 0.29 ms
SELECT cat_id
FROM uz0jc_mt_cats
WHERE lft = 39 && rgt = 40 && cat_parent >= 0
ORDER BY lft ASC
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_parent,lft_rgt,func_getPathWay | func_getPathWay | 8 | const,const | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
9 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.tools.php:905 |
8 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:646 |
7 | mtAppendPathWay() | JROOT/components/com_mtree/mtree.php:83 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.14 ms After last query: 0.22 ms
SELECT *
FROM uz0jc_mt_cats
WHERE cat_id='20'
AND cat_published = 1
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,dtree,cat_id_index | cat_id | 5 | const,const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
8 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/mtree.php:426 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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: 120.65 ms After last query: 0.79 ms
SELECT COUNT(*)
FROM (uz0jc_mt_links AS l, uz0jc_mt_cl AS cl)
WHERE l.link_published = 1
AND cl.cl_published =1 && l.link_approved = 1 && cl.cat_id = '20'
AND ( l.publish_up = '0000-00-00 00:00:00' OR l.publish_up <= '2019-12-16 12:16:03' )
AND ( l.publish_down = '0000-00-00 00:00:00' OR l.publish_down >= '2019-12-16 12:16:03' )
AND cl.link_id = l.link_id
AND l.link_published='1'
AND link_approved='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | cat_id | 4 | const | 399 | 100.00 | Using where |
1 | SIMPLE | l | ref | publishing,count_listfeatured,count_viewowner,link_id_index | link_id_index | 4 | wdg20170206.cl.link_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
12 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.php:516 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.26 ms After last query: 0.57 ms
SELECT cat.*
FROM uz0jc_mt_cats AS cat
WHERE cat_published=1 && cat_approved=1 && cat_parent= '20'
ORDER BY cat_name asc
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cat | ref | cat_parent,dtree | cat_parent | 6 | const,const,const | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.php:536 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.18 ms After last query: 0.23 ms
SELECT r.rel_id
FROM uz0jc_mt_relcats AS r
LEFT JOIN uz0jc_mt_cats AS c
ON c.cat_id = r.rel_id
WHERE r.cat_id = '20'
AND c.cat_published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
12 | JDatabaseDriver->loadColumn() | JROOT/components/com_mtree/mtree.php:597 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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: 68.37 ms After last query: 0.32 ms
SELECT l.*, tlcat.cat_id AS tlcat_id, tlcat.cat_name AS tlcat_name, cl.*, cat.*, u.username AS username, u.name AS owner, img.filename AS link_image
FROM uz0jc_mt_links AS l
LEFT JOIN uz0jc_mt_cl AS cl
ON cl.link_id = l.link_id
LEFT JOIN uz0jc_users AS u
ON u.id = l.user_id
LEFT JOIN uz0jc_mt_cats AS cat
ON cl.cat_id = cat.cat_id
LEFT JOIN uz0jc_mt_cats AS tlcat
ON tlcat.lft <= cat.lft
AND tlcat.rgt >= cat.rgt
AND tlcat.cat_parent =0
LEFT JOIN uz0jc_mt_images AS img
ON img.link_id = l.link_id
AND img.ordering = 1
WHERE link_published='1' && link_approved='1' && cl.cl_published = 1 && cl.cat_id = '20'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-12-16 12:16:03' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-12-16 12:16:03' )
ORDER BY link_featured desc,l.year desc,l.price desc, link_name asc
LIMIT 81, 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | cat_id | 4 | const | 399 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | ref | publishing,count_listfeatured,count_viewowner,link_id_index | link_id_index | 4 | wdg20170206.cl.link_id | 1 | 100.00 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | wdg20170206.l.user_id | 1 | 100.00 | |
1 | SIMPLE | cat | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
1 | SIMPLE | tlcat | ref | cat_parent,lft_rgt,func_getPathWay | cat_parent | 4 | const | 9 | 100.00 | Using where |
1 | SIMPLE | img | ref | link_id_ordering | link_id_ordering | 8 | wdg20170206.cl.link_id,const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.php:699 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.28 ms After last query: 7.26 ms
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 uz0jc_fields AS a
LEFT JOIN `uz0jc_languages` AS l
ON l.lang_code = a.language
LEFT JOIN uz0jc_users AS uc
ON uc.id=a.checked_out
LEFT JOIN uz0jc_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN uz0jc_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN uz0jc_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_mtree.category'
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 ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | wdg20170206.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | wdg20170206.a.checked_out | 1 | 100.00 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | wdg20170206.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | wdg20170206.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | wdg20170206.a.group_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
19 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
18 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
17 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
16 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
15 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
14 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT/components/com_mtree/mtree.php:724 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.24 ms After last query: 1.93 ms
SELECT *
FROM uz0jc_mt_cats
WHERE `cat_id` = '58'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
15 | Joomla\CMS\Table\Table->load() | JROOT/components/com_mtree/mtree.tools.php:893 |
14 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:862 |
13 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:337 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.23 ms After last query: 0.99 ms
SELECT cf_id
FROM uz0jc_mt_fields_map
WHERE cat_id = 58
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_fields_map | index | NULL | PRIMARY | 8 | NULL | 76656 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
14 | JDatabaseDriver->loadColumn() | JROOT/components/com_mtree/mtree.tools.php:870 |
13 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:337 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.16 ms After last query: 0.35 ms
SELECT cf_id
FROM uz0jc_mt_customfields
WHERE cf_id IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81)
AND published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_customfields | ALL | PRIMARY,published_ordering | NO INDEX KEY COULD BE USED | NULL | NULL | 82 | 96.34 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
14 | JDatabaseDriver->loadColumn() | JROOT/components/com_mtree/mtree.tools.php:876 |
13 | getAssignedFieldsID() | JROOT/components/com_mtree/mtree.tools.php:337 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.20 ms After last query: 0.63 ms
SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS value, field_type
FROM uz0jc_mt_customfields
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_customfields | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 82 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.tools.php:348 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.22 ms After last query: 0.88 ms
SELECT cf.*, cfv.link_id, cfv.value, cfv.attachment, cfv.counter
FROM uz0jc_mt_customfields AS cf
LEFT JOIN uz0jc_mt_cfvalues AS cfv
ON cf.cf_id=cfv.cf_id
AND cfv.link_id IN (33331,18614,10982,12078,39081,10197,11479,21206,32655)
WHERE cf.published = '1'
AND cf.summary_view = '1'
AND cf.cf_id IN (1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,67,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,81)
ORDER BY cf.ordering ASC, link_id DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cf | ALL | PRIMARY,published_ordering | NO INDEX KEY COULD BE USED | NULL | NULL | 82 | 92.68 | Using where; Using temporary; Using filesort |
1 | SIMPLE | cfv | range | cf_id,link_id | link_id | 4 | NULL | 9 | 77.78 | Using where; Using join buffer (flat, BNL join) |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.tools.php:368 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.28 ms After last query: 2.56 ms
SELECT *
FROM uz0jc_mt_cats
WHERE `cat_id` = '20'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
14 | Joomla\CMS\Table\Table->load() | JROOT/components/com_mtree/mtree.tools.php:893 |
13 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:388 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.21 ms After last query: 0.39 ms
SELECT cat_id
FROM uz0jc_mt_cats
WHERE lft = 39 && rgt = 40 && cat_parent >= 0
ORDER BY lft ASC
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_parent,lft_rgt,func_getPathWay | func_getPathWay | 8 | const,const | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.tools.php:905 |
13 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.tools.php:388 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.16 ms After last query: 0.23 ms
SELECT cat_association
FROM uz0jc_mt_cats
where cat_id = 20
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/mtree.tools.php:393 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.41 ms After last query: 32.79 ms
SELECT r.link_id, COUNT( * ) AS total
FROM uz0jc_mt_cl AS cl
LEFT JOIN uz0jc_mt_reviews AS r
ON cl.link_id = r.link_id
WHERE cl.link_id IN ('33331','18614','10982','12078','39081','10197','11479','21206','32655')
AND r.rev_approved = '1'
AND cl.main = '1'
GROUP BY r.link_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | r | index | link_id | link_id | 10 | NULL | 6 | 83.33 | Using where; Using index |
1 | SIMPLE | cl | ref | link_id | link_id | 4 | wdg20170206.r.link_id | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/mtree.tools.php:812 |
13 | getReviews() | JROOT/components/com_mtree/mtree.tools.php:468 |
12 | assignCommonListlinksVar() | JROOT/components/com_mtree/mtree.php:730 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.25 ms After last query: 1.59 ms
SELECT *
FROM uz0jc_mt_cats
WHERE `cat_id` = '20'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_id,cat_id_index | cat_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
14 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
13 | Joomla\CMS\Table\Table->load() | JROOT/components/com_mtree/mtree.tools.php:893 |
12 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.php:751 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.20 ms After last query: 0.38 ms
SELECT cat_id
FROM uz0jc_mt_cats
WHERE lft = 39 && rgt = 40 && cat_parent >= 0
ORDER BY lft ASC
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | uz0jc_mt_cats | ref | cat_parent,lft_rgt,func_getPathWay | func_getPathWay | 8 | const,const | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
13 | JDatabaseDriver->loadResult() | JROOT/components/com_mtree/mtree.tools.php:905 |
12 | getTopLevelCatID() | JROOT/components/com_mtree/mtree.php:751 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.32 ms After last query: 1.80 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM uz0jc_modules AS m
LEFT JOIN uz0jc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN uz0jc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-16 12:16:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-16 12:16:03')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 61 | 100.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | wdg20170206.m.id | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | wdg20170206.m.module,const | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
17 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
16 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
15 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:12 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.26 ms After last query: 1.23 ms
SELECT params
FROM uz0jc_mt_templates
WHERE tem_name = 'weddingguide'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
16 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_mtree/config.mtree.class.php:175 |
15 | mtConfig->getTemParam() | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:108 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.23 ms After last query: 0.98 ms
SELECT cat.cat_id, cat.cat_name
FROM uz0jc_mt_cl cl
INNER JOIN uz0jc_mt_cats cat
ON cat.cat_id = cl.cat_id
WHERE cl.link_id = 33331
AND main = 1 ;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 2 | 100.00 | Using where |
1 | SIMPLE | cat | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.17 ms After last query: 2.02 ms
SELECT c.cat_id,c.cat_name,c.cat_parent
FROM uz0jc_mt_links l
INNER JOIN uz0jc_mt_cl cl
ON l.link_id = cl.link_id
INNER JOIN uz0jc_mt_cats c
ON c.cat_id = cl.cat_id
WHERE cl.cl_published =1
and l.link_id = 33331
order by cl.main DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 2 | 100.00 | Using where; Using filesort |
1 | SIMPLE | l | ref | link_id_index | link_id_index | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.21 ms After last query: 0.82 ms
SELECT cat.cat_id, cat.cat_name
FROM uz0jc_mt_cl cl
INNER JOIN uz0jc_mt_cats cat
ON cat.cat_id = cl.cat_id
WHERE cl.link_id = 18614
AND main = 1 ;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | cat | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.36 ms After last query: 1.37 ms
SELECT c.cat_id,c.cat_name,c.cat_parent
FROM uz0jc_mt_links l
INNER JOIN uz0jc_mt_cl cl
ON l.link_id = cl.link_id
INNER JOIN uz0jc_mt_cats c
ON c.cat_id = cl.cat_id
WHERE cl.cl_published =1
and l.link_id = 18614
order by cl.main DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 1 | 100.00 | Using where; Using filesort |
1 | SIMPLE | l | ref | link_id_index | link_id_index | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.20 ms After last query: 0.68 ms
SELECT cat.cat_id, cat.cat_name
FROM uz0jc_mt_cl cl
INNER JOIN uz0jc_mt_cats cat
ON cat.cat_id = cl.cat_id
WHERE cl.link_id = 10982
AND main = 1 ;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 2 | 100.00 | Using where |
1 | SIMPLE | cat | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.12 ms After last query: 1.34 ms
SELECT c.cat_id,c.cat_name,c.cat_parent
FROM uz0jc_mt_links l
INNER JOIN uz0jc_mt_cl cl
ON l.link_id = cl.link_id
INNER JOIN uz0jc_mt_cats c
ON c.cat_id = cl.cat_id
WHERE cl.cl_published =1
and l.link_id = 10982
order by cl.main DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 2 | 100.00 | Using where; Using filesort |
1 | SIMPLE | l | ref | link_id_index | link_id_index | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.18 ms After last query: 0.65 ms
SELECT cat.cat_id, cat.cat_name
FROM uz0jc_mt_cl cl
INNER JOIN uz0jc_mt_cats cat
ON cat.cat_id = cl.cat_id
WHERE cl.link_id = 12078
AND main = 1 ;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 5 | 100.00 | Using where |
1 | SIMPLE | cat | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.88 ms After last query: 1.64 ms
SELECT c.cat_id,c.cat_name,c.cat_parent
FROM uz0jc_mt_links l
INNER JOIN uz0jc_mt_cl cl
ON l.link_id = cl.link_id
INNER JOIN uz0jc_mt_cats c
ON c.cat_id = cl.cat_id
WHERE cl.cl_published =1
and l.link_id = 12078
order by cl.main DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 5 | 100.00 | Using where; Using filesort |
1 | SIMPLE | l | ref | link_id_index | link_id_index | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | c | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.21 ms After last query: 0.76 ms
SELECT cat.cat_id, cat.cat_name
FROM uz0jc_mt_cl cl
INNER JOIN uz0jc_mt_cats cat
ON cat.cat_id = cl.cat_id
WHERE cl.link_id = 39081
AND main = 1 ;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cl | ref | link_id,cat_id | link_id | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | cat | ref | cat_id,cat_id_index | cat_id | 4 | wdg20170206.cl.cat_id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74 |
16 | include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php | JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101 |
15 | include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php | JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119 |
14 | include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php | JROOT/components/com_mtree/Savant2.php:984 |
13 | Savant2->fetch() | JROOT/components/com_mtree/Savant2.php:1013 |
12 | Savant2->display() | JROOT/components/com_mtree/mtree.php:766 |
11 | showTree_cache() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
9 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
8 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_mtree/mtree.php:481 |
7 | showTree() | JROOT/components/com_mtree/mtree.php:387 |
6 | require_once JROOT/components/com_mtree/mtree.php | JROOT/libraries/src/Component/ComponentHelper.php:392 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:367 |
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.10 ms After last query: 1.32 ms