Yoon Shwe Yee

Silk Wear

Address: 312, Top West(A) Shed, Bogyoke Aung San Market,(အမွတ္ ၃၁၂၊ အေနာက္(ေအ) ထိပ္-႐ံု၊ ဗိုလ္ခ်ဳပ္ေအာင္ဆန္းေဈး၊)
Township: Pabedan(ပန္းဘဲတန္းၿမိဳ႕နယ္)
Phone: 01-374740, 09-5198413, 09-965198413, 09-765198413
Email: [email protected]

Opening Hours

Business Categories

Traditional Dress Shops [Fashion and Beauty]

Brands / Services

Silk & Cotton
Traditional Suit

Social Media Links

Gallery

Map

Our Guides

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576500929,
                "last": 1576500929,
                "now": 1576500929
            },
            "client": {
                "forwarded": "100.26.176.182"
            },
            "token": "484rkUtAjtnlHlTJs2SVlFIQgxQNCi9b"
        },
        "registry": {

        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [

            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "link_id": "38741"
    }
}

Profile Information

Memory Usage

Database Queries

61 Queries Logged 1174.65 ms

6 duplicate found!

2 duplicates: #11 #57

2 duplicates: #28 #43

2 duplicates: #29 #44

Query Time: 4.40 ms

DELETE 

  FROM `uz0jc_session`

  WHERE `time` < '1576500029'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.57 ms After last query: 1.12 ms

SELECT `data`

  FROM `uz0jc_session`

  WHERE `session_id` = 'frb90lrdbb11g0nrte0qnkeen7'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.55 ms After last query: 1.26 ms

SELECT `session_id`

  FROM `uz0jc_session`

  WHERE `session_id` = 'frb90lrdbb11g0nrte0qnkeen7' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 11.56 ms After last query: 0.62 ms

INSERT INTO `uz0jc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('frb90lrdbb11g0nrte0qnkeen7', 1, '1576500929', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `uz0jc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('frb90lrdbb11g0nrte0qnkeen7', 1, '1576500929', 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 10.16 ms After last query: 2.05 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `uz0jc_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.20 ms After last query: 2.12 ms

SELECT id, rules

  FROM `uz0jc_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.57 ms After last query: 4.94 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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.59 ms After last query: 0.95 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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.12 ms After last query: 144.39 ms

SELECT *

  FROM `uz0jc_rsseo_redirects`

  WHERE `published` = 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.33 ms After last query: 10.92 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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.39 ms After last query: 35.96 ms

Duplicate queries: #57

SELECT `varname`, `value`, `default` 
  FROM uz0jc_mt_config

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.73 ms After last query: 15.42 ms

SELECT cat_id, cat_parent, alias 
  FROM uz0jc_mt_cats 
  WHERE cat_published='1' 
  AND cat_approved='1' && BINARY alias = 'L113201_L020150617_yoon-shwe-yee'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:672
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.83 ms After last query: 0.39 ms

SELECT cat_id, cat_parent, alias 
  FROM uz0jc_mt_cats 
  WHERE cat_published='1' 
  AND cat_approved='1' && BINARY alias = 'yangon-region' && cat_parent = 0 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	ref	cat_parent,dtree	cat_parent	6	const,const,const	7	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/router.php:994
11	findCatID()	JROOT/components/com_mtree/router.php:672
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.75 ms After last query: 0.39 ms

SELECT cat_id, cat_parent, alias 
  FROM uz0jc_mt_cats 
  WHERE cat_published='1' 
  AND cat_approved='1' && BINARY alias = 'pabedan'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/router.php:994
11	findCatID()	JROOT/components/com_mtree/router.php:672
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.56 ms After last query: 0.29 ms

SELECT cat_id, cat_parent, alias 
  FROM uz0jc_mt_cats 
  WHERE cat_published='1' 
  AND cat_approved='1' && BINARY alias = '57-traditional-dress-shops'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/router.php:994
11	findCatID()	JROOT/components/com_mtree/router.php:672
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.74 ms After last query: 3.00 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `uz0jc_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.34 ms After last query: 5.07 ms

UPDATE `uz0jc_extensions`

  SET `params` = '{\"mediaversion\":\"6531677b0b10a746832c31343555908f\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 9.93 ms After last query: 1.92 ms

SELECT *

  FROM uz0jc_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.26 ms After last query: 5.86 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

Explain

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)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 8.18 ms After last query: 24.13 ms

SELECT l.link_id ,l.link_name, ca.cat_name , ca.cat_parent  
  FROM uz0jc_mt_links l  
  INNER JOIN uz0jc_mt_cl cl 
  ON cl.link_id = l.link_id 
  INNER JOIN uz0jc_mt_cats ca 
  ON ca.cat_id = cl.cat_id 
  WHERE l.client_no='L113201' 
  AND l.ads_no='L020150617' 
  AND l.alias ="yoon-shwe-yee" 
  AND cl.cat_id = "57" 
  order by `year` desc, `main` desc 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	ref	client_no_index,link_id_index	client_no_index	138	const	2	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	cl	ref	link_id,cat_id	link_id	4	wdg20170206.l.link_id	1	100.00	Using where
1	SIMPLE	ca	ref	cat_id,cat_id_index	cat_id	4	wdg20170206.cl.cat_id	1	100.00

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
7	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/mtree.php:131
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.27 ms

SELECT cat_name 
  FROM uz0jc_mt_cats 
  WHERE cat_id=17

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
7	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/mtree.php:139
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.66 ms After last query: 0.20 ms

SELECT cat.cat_id, cat.cat_name ,cat.cat_parent ,l.link_name 
  FROM uz0jc_mt_cl cl 
       
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id 
       
  INNER JOIN uz0jc_mt_links l 
  ON l.link_id = cl.link_id 
       
  WHERE cl.link_id = 38741  ;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered
1	SIMPLE	l	ref	link_id_index	link_id_index	4	const	1	100.00
1	SIMPLE	cl	ref	link_id,cat_id	link_id	4	const	4	100.00
1	SIMPLE	cat	ref	cat_id,cat_id_index	cat_id	4	wdg20170206.cl.cat_id	1	100.00

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
8	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/mtree.php:2727
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 8.87 ms After last query: 0.40 ms

SELECT l.*, tlcat.cat_id AS tlcat_id, tlcat.cat_name AS tlcat_name, u.username AS username, u.name AS owner, u.email AS owner_email, cl.cat_id AS cat_id, c.cat_name AS cat_name, c.cat_association, img.filename AS link_image, img.img_id 
  FROM (uz0jc_mt_links AS l, uz0jc_mt_cl AS cl)
 
  LEFT JOIN uz0jc_users AS u 
  ON u.id = l.user_id
 
  LEFT JOIN uz0jc_mt_cats AS c 
  ON c.cat_id = cl.cat_id
 
  LEFT JOIN uz0jc_mt_cats AS tlcat 
  ON tlcat.lft <= c.lft 
  AND tlcat.rgt >= c.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' 
  AND link_approved > 0 
  AND l.link_id='38741' 
 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-12-16 12:55:29'  ) 
 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-12-16 12:55:29' ) 
 
  AND l.link_id = cl.link_id
 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	ref	publishing,count_listfeatured,count_viewowner,link_id_index	link_id_index	4	const	1	100.00	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	wdg20170206.l.user_id	1	100.00
1	SIMPLE	cl	ref	link_id	link_id	4	wdg20170206.l.link_id	1	100.00
1	SIMPLE	c	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.l.link_id,const	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
9	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/mtree.tools.php:35
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.50 ms After last query: 0.47 ms

SELECT cat_id, cat_parent, metadata, lft, rgt 
  FROM uz0jc_mt_cats 
  WHERE cat_id = 50 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:129
9	mtConfig->setCategory()	JROOT/components/com_mtree/mtree.tools.php:39
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.56 ms After last query: 0.36 ms

SELECT cat_id, metadata 
  FROM uz0jc_mt_cats 

  WHERE lft < 87 && rgt > 88 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

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	32	100.00	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:144
9	mtConfig->setCategory()	JROOT/components/com_mtree/mtree.tools.php:39
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.43 ms After last query: 0.59 ms

SELECT cat_template 
  FROM uz0jc_mt_cats 
  WHERE cat_id='50' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:50
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 12.90 ms After last query: 0.98 ms

SHOW FULL COLUMNS 
  FROM `uz0jc_mt_cats`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `uz0jc_mt_cats`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:260
12	mtCats->__construct()	JROOT/components/com_mtree/mtree.tools.php:892
11	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:862
10	getAssignedFieldsID()	JROOT/components/com_mtree/mtree.tools.php:111
9	loadFields()	JROOT/components/com_mtree/mtree.tools.php:60
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.54 ms After last query: 1.67 ms

Duplicate queries: #43

SELECT *

  FROM uz0jc_mt_cats

  WHERE `cat_id` = '50'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_mtree/mtree.tools.php:893
11	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:862
10	getAssignedFieldsID()	JROOT/components/com_mtree/mtree.tools.php:111
9	loadFields()	JROOT/components/com_mtree/mtree.tools.php:60
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.97 ms After last query: 0.50 ms

Duplicate queries: #44

SELECT cat_id 
  FROM uz0jc_mt_cats 

  WHERE lft = 87 && rgt = 88 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.tools.php:905
11	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:862
10	getAssignedFieldsID()	JROOT/components/com_mtree/mtree.tools.php:111
9	loadFields()	JROOT/components/com_mtree/mtree.tools.php:60
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.67 ms After last query: 4.05 ms

SELECT cf_id 
  FROM uz0jc_mt_fields_map 
  WHERE cat_id = 50

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/components/com_mtree/mtree.tools.php:870
10	getAssignedFieldsID()	JROOT/components/com_mtree/mtree.tools.php:111
9	loadFields()	JROOT/components/com_mtree/mtree.tools.php:60
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.40 ms After last query: 0.44 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 = 38741

  WHERE cf.published = '1' 

  AND cf.cf_id IN (1) && details_view = '1' 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cf	const	PRIMARY,published_ordering	PRIMARY	4	const	1	100.00
1	SIMPLE	cfv	ref	cf_id,link_id	cf_id	8	const,const	1	100.00

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.tools.php:133
9	loadFields()	JROOT/components/com_mtree/mtree.tools.php:60
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.49 ms After last query: 4.89 ms

SELECT CONCAT('cust_',cf_id) as varname, value 
  FROM uz0jc_mt_cfvalues 
  WHERE link_id = '38741'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cfvalues	ref	link_id	link_id	4	const	1	100.00

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.tools.php:64
8	loadLink()	JROOT/components/com_mtree/mtree.php:2761
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.76 ms After last query: 2.03 ms

SHOW FULL COLUMNS 
  FROM `uz0jc_mt_links`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `uz0jc_mt_links`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:993
15	mtLinks->__construct()	JROOT/components/com_mtree/router.php:128
14	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
13	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/mtree.php:2867
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 17.70 ms After last query: 1.96 ms

SELECT l.*, cl.cat_id AS cat_id 
  FROM uz0jc_mt_links AS l, uz0jc_mt_cl AS cl 
  WHERE l.link_id = cl.link_id 
  AND l.link_id = '38741' 
  AND main = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	ref	link_id_index	link_id_index	4	const	1	100.00
1	SIMPLE	cl	ref	link_id	link_id	4	wdg20170206.l.link_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:1064
15	mtLinks->load()	JROOT/components/com_mtree/router.php:129
14	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
13	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/mtree.php:2867
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.97 ms After last query: 1.11 ms

SELECT cat_name, cat_id, lft, rgt 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '50'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
16	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
15	appendCat()	JROOT/components/com_mtree/router.php:130
14	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
13	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/mtree.php:2867
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.57 ms After last query: 0.41 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 87 
  AND rgt > 88 
  AND cat_id > 0 
  AND cat_parent >= 0 
  ORDER BY lft ASC

Explain

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	32	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
16	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
15	appendCat()	JROOT/components/com_mtree/router.php:130
14	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
13	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/mtree.php:2867
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.47 ms After last query: 0.54 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '17' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
17	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:838
16	appendCat_cached()	JROOT/components/com_mtree/router.php:788
15	appendCat()	JROOT/components/com_mtree/router.php:130
14	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
13	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/mtree.php:2867
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.53 ms After last query: 0.46 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '50' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
17	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
16	appendCat_cached()	JROOT/components/com_mtree/router.php:788
15	appendCat()	JROOT/components/com_mtree/router.php:130
14	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
13	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/mtree.php:2867
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 876.11 ms After last query: 2.01 ms

UPDATE uz0jc_mt_links 
  SET link_hits=link_hits+1 
  WHERE link_id='38741'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_links	range	link_id_index	link_id_index	4	NULL	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/components/com_mtree/mtree.php:2929
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.50 ms

SELECT COUNT(*) 
  FROM uz0jc_mt_reviews AS r 
  WHERE link_id = '38741' 
  AND r.rev_approved = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	ref	link_id	link_id	5	const,const	1	100.00	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.php:2936
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.60 ms After last query: 0.35 ms

SELECT r.*, u.username, log.value AS rating 
  FROM uz0jc_mt_reviews AS r
 
  LEFT JOIN uz0jc_users AS u 
  ON u.id = r.user_id
 
  LEFT JOIN uz0jc_mt_log AS log 
  ON log.user_id = r.user_id 
  AND log.link_id = r.link_id 
  AND log_type = 'vote' 
  AND log.rev_id = r.rev_id
 
  WHERE r.link_id = '38741' 
  AND r.rev_approved = 1 
 
  ORDER BY rev_date desc, vote_total desc, rev_date desc
 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	ref	link_id	link_id	5	const,const	1	100.00	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	wdg20170206.r.user_id	1	100.00
1	SIMPLE	log	ref	link_id2,link_id1,log_type,user_id	link_id2	4	wdg20170206.r.link_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.php:2956
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.59 ms After last query: 0.43 ms

SELECT img_id AS id, filename 
  FROM uz0jc_mt_images 
  WHERE link_id = '38741' 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_images	ref	link_id_ordering	link_id_ordering	4	const	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.php:2976
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.32 ms After last query: 1.10 ms

Duplicate queries: #28

SELECT *

  FROM uz0jc_mt_cats

  WHERE `cat_id` = '50'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:191
12	assignCommonViewlinkVar()	JROOT/components/com_mtree/mtree.php:2987
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.44 ms After last query: 0.48 ms

Duplicate queries: #29

SELECT cat_id 
  FROM uz0jc_mt_cats 

  WHERE lft = 87 && rgt = 88 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:191
12	assignCommonViewlinkVar()	JROOT/components/com_mtree/mtree.php:2987
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.95 ms After last query: 0.32 ms

SELECT * 
  FROM uz0jc_mt_cats 
  WHERE cat_id = 50 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:193
12	assignCommonViewlinkVar()	JROOT/components/com_mtree/mtree.php:2987
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 8.27 ms After last query: 0.39 ms

SELECT COUNT(*) 
  FROM uz0jc_mt_favourites 
  WHERE link_id = '38741'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:223
12	assignCommonViewlinkVar()	JROOT/components/com_mtree/mtree.php:2987
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.55 ms After last query: 0.36 ms

SELECT COUNT(*) 
  FROM uz0jc_mt_images 
  WHERE link_id = '38741'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_images	ref	link_id_ordering	link_id_ordering	4	const	1	100.00	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:237
12	assignCommonViewlinkVar()	JROOT/components/com_mtree/mtree.php:2987
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.55 ms After last query: 22.67 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.listing' 
  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

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
17	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:255
16	PlgSystemFields->onContentAfterTitle()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_mtree/mtree.tools.php:304
12	assignCommonViewlinkVar()	JROOT/components/com_mtree/mtree.php:2987
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.59 ms After last query: 9.26 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE cat_association = 17 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	64	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.php:3090
12	getAssociatedListings()	JROOT/components/com_mtree/mtree.php:3006
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.02 ms After last query: 0.52 ms

SELECT params 
  FROM uz0jc_mt_templates 
  WHERE tem_name = 'weddingguide' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	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_listing.tpl.php:5
14	include JROOT/components/com_mtree/templates/weddingguide/page_listing.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:3055
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.32 ms After last query: 0.36 ms

SELECT c.cat_name 
  FROM uz0jc_mt_links l
	
  inner join uz0jc_mt_cl cl 
  on cl.link_id = l.link_id
	
  inner join uz0jc_mt_cats c 
  on cl.cat_id = c.cat_id
	
  where cl.main = 1 
  and l.link_id = 38741

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	ref	link_id_index	link_id_index	4	const	1	100.00	Using index
1	SIMPLE	cl	ref	link_id,cat_id	link_id	4	const	4	100.00	Using where
1	SIMPLE	c	ref	cat_id,cat_id_index	cat_id	4	wdg20170206.cl.cat_id	1	100.00

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/templates/weddingguide/sub_listingDetails.tpl.php:9
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listingDetails.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_listing.tpl.php:10
14	include JROOT/components/com_mtree/templates/weddingguide/page_listing.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:3055
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 9.12 ms After last query: 10.79 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:55:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-16 12:55:29') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 112 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.14 ms
preparing	0.10 ms
executing	0.01 ms
Sorting result	0.68 ms
Sending data	1.08 ms
Waiting for query cache lock	0.02 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	4.11 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.66 ms
cleaning up	0.02 ms

Call Stack

#	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_listing.tpl.php:35
14	include JROOT/components/com_mtree/templates/weddingguide/page_listing.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:3055
11	viewlink_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:2902
7	viewlink()	JROOT/components/com_mtree/mtree.php:142
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 9.37 ms After last query: 16.71 ms

SELECT `params`

  FROM `uz0jc_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_rsseo'

Explain

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	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsseo/helpers/rsseo.php:25
10	rsseoHelper::getConfig()	JROOT/plugins/system/rsseo/rsseo.php:865
9	plgSystemRsseo->sitemap()	JROOT/plugins/system/rsseo/rsseo.php:78
8	plgSystemRsseo->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.03 ms After last query: 1.17 ms

SELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`robots`,`custom`

  FROM `uz0jc_rsseo_pages`

  WHERE `url` = 'wedding-service/yangon-region/pabedan/57-traditional-dress-shops/L113201_L020150617_yoon-shwe-yee' 
  AND `published` = 1 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.24 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
storing result in query cache	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:420
9	plgSystemRsseo->meta()	JROOT/plugins/system/rsseo/rsseo.php:117
8	plgSystemRsseo->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.70 ms After last query: 20.87 ms

SELECT cat_name, cat_id, lft, rgt 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '17'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
20	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
19	appendCat()	JROOT/components/com_mtree/router.php:110
18	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.62 ms After last query: 0.36 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 70 
  AND rgt > 97 
  AND cat_id > 0 
  AND cat_parent >= 0 
  ORDER BY lft ASC

Explain

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	26	100.00	Using where; Using index

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
21	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
20	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
19	appendCat()	JROOT/components/com_mtree/router.php:110
18	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 8.22 ms After last query: 23.60 ms

Duplicate queries: #11

SELECT `varname`, `value`, `default` 
  FROM uz0jc_mt_config

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_mtree/config.mtree.class.php:79
12	mtConfig->mtConfig()	JROOT/modules/mod_mt_search/helper.php:16
11	modMTSearchHelper::getCategories()	JROOT/modules/mod_mt_search/mod_mt_search.php:27
10	include JROOT/modules/mod_mt_search/mod_mt_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.56 ms After last query: 3.63 ms

SELECT cat_id, cat_parent, metadata, lft, rgt 
  FROM uz0jc_mt_cats 
  WHERE cat_id = 0 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	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/modules/mod_mt_search/helper.php:21
11	modMTSearchHelper::getCategories()	JROOT/modules/mod_mt_search/mod_mt_search.php:27
10	include JROOT/modules/mod_mt_search/mod_mt_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.44 ms After last query: 0.55 ms

SELECT cat_id, cat_name 
  FROM uz0jc_mt_cats AS cat  
  WHERE cat_approved=1 
  AND cat_published=1 
  AND cat_parent !=0 
  AND cat_parent !=-1 
  ORDER BY cat_name asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat	ref	cat_parent,dtree	dtree	2	const,const	61	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_mt_search/helper.php:37
11	modMTSearchHelper::getCategories()	JROOT/modules/mod_mt_search/mod_mt_search.php:27
10	include JROOT/modules/mod_mt_search/mod_mt_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.63 ms After last query: 11.71 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '0' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
21	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
20	appendCat_cached()	JROOT/components/com_mtree/router.php:788
19	appendCat()	JROOT/components/com_mtree/router.php:314
18	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/templates/weddingguide/html/mod_mt_search/default.php:7
11	require JROOT/templates/weddingguide/html/mod_mt_search/default.php	JROOT/modules/mod_mt_search/mod_mt_search.php:54
10	include JROOT/modules/mod_mt_search/mod_mt_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.49 ms After last query: 438.18 ms

SELECT *

  FROM `uz0jc_rsseo_keywords`

  ORDER BY CHAR_LENGTH(keyword) DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_rsseo_keywords	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsseo/rsseo.php:245
8	plgSystemRsseo->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

46 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT cat_id 
  FROM uz0jc_mt_cats

4 × SELECT cat_id, cat_parent, alias 
  FROM uz0jc_mt_cats

3 × SELECT alias 
  FROM uz0jc_mt_cats

```
3 × SELECT * 
  FROM uz0jc_mt_cats
```

2 × SELECT cat_id, cat_parent, metadata, lft, rgt 
  FROM uz0jc_mt_cats

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `uz0jc_extensions`

2 × SELECT `varname`, `value`, `default` 
  FROM uz0jc_mt_confi

2 × SELECT cat_name, cat_id, lft, rgt 
  FROM uz0jc_mt_cats

1 × SELECT COUNT(*) 
  FROM uz0jc_mt_favourites

1 × SELECT img_id AS id, filename 
  FROM uz0jc_mt_images

1 × SELECT r.*, u.username, log.value AS rating 
  FROM uz0jc_mt_reviews AS r  
  LEFT JOIN uz0jc_users AS u 
  ON u.id = r.user_id  
  LEFT JOIN uz0jc_mt_log AS log 
  ON log.user_id = r.user_id 
  AND log.link_id = r.link_id 
  AND log_type = 'vote' 
  AND log.rev_id = r.rev_id

1 × SELECT COUNT(*) 
  FROM uz0jc_mt_images

1 × SELECT COUNT(*) 
  FROM uz0jc_mt_reviews AS r

1 × SELECT `session_id` 
  FROM `uz0jc_session`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM 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

1 × SELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`robots`,`custom` 
  FROM `uz0jc_rsseo_pages`

1 × SELECT cat_id, cat_name 
  FROM uz0jc_mt_cats AS cat

1 × SELECT * 
  FROM `uz0jc_rsseo_keywords`

1 × SELECT `params` 
  FROM `uz0jc_extensions`

1 × 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

1 × SELECT params 
  FROM uz0jc_mt_templates

1 × SELECT c.cat_name 
  FROM uz0jc_mt_links l
  
  inner join uz0jc_mt_cl cl 
  on cl.link_id = l.link_id
  
  inner join uz0jc_mt_cats c 
  on cl.cat_id = c.cat_id

1 × SELECT l.*, cl.cat_id AS cat_id 
  FROM uz0jc_mt_links AS l, uz0jc_mt_cl AS cl

1 × SELECT cf_id 
  FROM uz0jc_mt_fields_map

```
1 × SELECT * 
  FROM uz0jc_languages
```

1 × 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

1 × SELECT l.link_id ,l.link_name, ca.cat_name , ca.cat_parent  
  FROM uz0jc_mt_links l  
  INNER JOIN uz0jc_mt_cl cl 
  ON cl.link_id = l.link_id 
  INNER JOIN uz0jc_mt_cats ca 
  ON ca.cat_id = cl.cat_id

1 × SELECT id, rules 
  FROM `uz0jc_viewlevels

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM uz0jc_menu AS m 
  LEFT JOIN uz0jc_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM uz0jc_extensions

1 × SELECT * 
  FROM `uz0jc_rsseo_redirects`

1 × SELECT cat_name 
  FROM uz0jc_mt_cats

1 × SELECT cat.cat_id, cat.cat_name ,cat.cat_parent ,l.link_name 
  FROM uz0jc_mt_cl cl         
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id         
  INNER JOIN uz0jc_mt_links l 
  ON l.link_id = cl.link_id

1 × SELECT b.id 
  FROM uz0jc_usergroups AS a 
  LEFT JOIN uz0jc_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × 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 = 38741

1 × SELECT `data` 
  FROM `uz0jc_session`

1 × SELECT cat_template 
  FROM uz0jc_mt_cats

1 × SELECT l.*, tlcat.cat_id AS tlcat_id, tlcat.cat_name AS tlcat_name, u.username AS username, u.name AS owner, u.email AS owner_email, cl.cat_id AS cat_id, c.cat_name AS cat_name, c.cat_association, img.filename AS link_image, img.img_id 
  FROM (uz0jc_mt_links AS l, uz0jc_mt_cl AS cl)  
  LEFT JOIN uz0jc_users AS u 
  ON u.id = l.user_id  
  LEFT JOIN uz0jc_mt_cats AS c 
  ON c.cat_id = cl.cat_id  
  LEFT JOIN uz0jc_mt_cats AS tlcat 
  ON tlcat.lft <= c.lft 
  AND tlcat.rgt >= c.rgt 
  AND tlcat.cat_parent =0   
  LEFT JOIN uz0jc_mt_images AS img 
  ON img.link_id = l.link_id 
  AND img.ordering = 1

1 × SELECT cat_id, metadata 
  FROM uz0jc_mt_cats

1 × SELECT CONCAT('cust_',cf_id) as varname, value 
  FROM uz0jc_mt_cfvalues

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `uz0jc_mt_links

1 × UPDATE uz0jc_mt_links 
  SET link_hits=link_hits+1

1 × SHOW FULL COLUMNS 
  FROM `uz0jc_mt_cats

1 × UPDATE `uz0jc_extensions` 
  SET `params` = '{\"mediaversion\":\"6531677b0b10a746832c31343555908f\"}'

1 × INSERT INTO `uz0jc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('frb90lrdbb11g0nrte0qnkeen7', 1, '1576500929', 0, '', 0

```
1 × DELETE  
  FROM `uz0jc_session`
```