Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576498500,
                "last": 1576498500,
                "now": 1576498500
            },
            "client": {
                "forwarded": "100.26.176.182"
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 9.84 ms / 9.84 ms Memory: 0.807 MB / 1.02 MB Application: afterLoad

Time: 147.06 ms / 156.90 ms Memory: 1.745 MB / 2.77 MB Application: afterInitialise

Time: 82.74 ms / 239.64 ms Memory: 1.079 MB / 3.85 MB Application: afterRoute

Time: 1.36 ms / 241.00 ms Memory: 0.011 MB / 3.86 MB Application: beforeRenderComponent com_mtree

Time: 144.02 ms / 385.02 ms Memory: 2.593 MB / 6.45 MB Application: afterRenderComponent com_mtree

Time: 15.99 ms / 401.01 ms Memory: 0.059 MB / 6.51 MB Application: afterDispatch

Time: 8.92 ms / 409.93 ms Memory: 0.051 MB / 6.56 MB Application: beforeRenderModule mod_custom (Our verticle section)

Time: 1.75 ms / 411.68 ms Memory: 0.011 MB / 6.57 MB Application: afterRenderModule mod_custom (Our verticle section)

Time: 0.32 ms / 412.00 ms Memory: 0.001 MB / 6.57 MB Application: beforeRenderModule mod_mt_featured (Ads Listing Banner Bottom)

Time: 10.68 ms / 422.68 ms Memory: 0.069 MB / 6.64 MB Application: afterRenderModule mod_mt_featured (Ads Listing Banner Bottom)

Time: 0.51 ms / 423.20 ms Memory: 0.000 MB / 6.64 MB Application: beforeRenderModule mod_custom_relatedarticles (mod_custom_relatedarticles)

Time: 7.61 ms / 430.81 ms Memory: 0.044 MB / 6.68 MB Application: afterRenderModule mod_custom_relatedarticles (mod_custom_relatedarticles)

Time: 0.34 ms / 431.15 ms Memory: 0.000 MB / 6.67 MB Application: beforeRenderModule mod_mt_topads (MT Top Advertizers!)

Time: 2190.92 ms / 2622.08 ms Memory: 0.127 MB / 6.79 MB Application: afterRenderModule mod_mt_topads (MT Top Advertizers!)

Time: 0.57 ms / 2622.65 ms Memory: 0.000 MB / 6.73 MB Application: beforeRenderModule mod_mt_featured (Ads Listing Banner Sidebar Top)

Time: 45.71 ms / 2668.36 ms Memory: 0.025 MB / 6.76 MB Application: afterRenderModule mod_mt_featured (Ads Listing Banner Sidebar Top)

Time: 2.56 ms / 2670.92 ms Memory: 0.000 MB / 6.75 MB Application: beforeRenderModule mod_mt_featured (Ads Listing Banner Top)

Time: 8.59 ms / 2679.50 ms Memory: 0.025 MB / 6.78 MB Application: afterRenderModule mod_mt_featured (Ads Listing Banner Top)

Time: 0.40 ms / 2679.91 ms Memory: 0.000 MB / 6.78 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 22.80 ms / 2702.70 ms Memory: 0.025 MB / 6.80 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.47 ms / 2703.18 ms Memory: 0.000 MB / 6.79 MB Application: beforeRenderModule mod_mt_search (Moset Tree Search for Other Page)

Time: 32.29 ms / 2735.47 ms Memory: 0.255 MB / 7.05 MB Application: afterRenderModule mod_mt_search (Moset Tree Search for Other Page)

Time: 0.61 ms / 2736.07 ms Memory: 0.000 MB / 7.01 MB Application: beforeRenderModule mod_smartmenus (mod_smartmenus)

Time: 83.06 ms / 2819.13 ms Memory: 0.237 MB / 7.25 MB Application: afterRenderModule mod_smartmenus (mod_smartmenus)

Time: 415.51 ms / 3234.64 ms Memory: 0.141 MB / 7.39 MB Application: afterRender

Database queries total: 2272.84 ms

Memory Usage

Database Queries

74 Queries Logged 2272.84 ms

10 duplicate found!

2 duplicates: #10 #70

3 duplicates: #12 #17 #69

2 duplicates: #21 #29

3 duplicates: #62 #67 #68

Query Time: 1.47 ms

SELECT `data`

  FROM `uz0jc_session`

  WHERE `session_id` = 'nslg4gvhqqm7r34vvvkn8fhdq7'

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: 1.39 ms After last query: 1.64 ms

SELECT `session_id`

  FROM `uz0jc_session`

  WHERE `session_id` = 'nslg4gvhqqm7r34vvvkn8fhdq7' 
  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: 2.44 ms After last query: 0.44 ms

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

Explain

EXPLAIN not possible on query: INSERT INTO `uz0jc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('nslg4gvhqqm7r34vvvkn8fhdq7', 1, '1576498500', 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: 1.44 ms After last query: 2.04 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: 0.21 ms After last query: 2.07 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: 0.14 ms After last query: 0.39 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: 2.13 ms After last query: 0.63 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: 0.48 ms After last query: 77.63 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: 2.00 ms After last query: 9.42 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: 0.35 ms After last query: 9.46 ms

Duplicate queries: #70

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: 1.21 ms After last query: 9.87 ms

SELECT cat_id, cat_parent, alias 
  FROM uz0jc_mt_cats 
  WHERE cat_published='1' 
  AND cat_approved='1' && BINARY alias = 'venues-
  and-decoration'

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: 0.82 ms After last query: 0.31 ms

Duplicate queries: #17 #69

SELECT cat_id, cat_parent, metadata, lft, rgt 
  FROM uz0jc_mt_cats 
  WHERE cat_id = 58 
  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/administrator/components/com_mtree/config.mtree.class.php:129
12	mtConfig->setCategory()	JROOT/components/com_mtree/router.php:929
11	findCatID()	JROOT/components/com_mtree/router.php: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: 8.35 ms After last query: 5.25 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: 23.29 ms After last query: 0.89 ms

UPDATE `uz0jc_extensions`

  SET `params` = '{\"mediaversion\":\"e0c077cd6a850342d5e986f42dc94c04\"}'

  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: 0.28 ms After last query: 2.72 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: 3.69 ms After last query: 9.64 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: 1.46 ms After last query: 11.93 ms

Duplicate queries: #12 #69

SELECT cat_id, cat_parent, metadata, lft, rgt 
  FROM uz0jc_mt_cats 
  WHERE cat_id = 58 
  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:1652
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:129
8	mtConfig->setCategory()	JROOT/components/com_mtree/init.php:24
7	require JROOT/components/com_mtree/init.php	JROOT/components/com_mtree/mtree.php:17
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 7.59 ms

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

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
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
10	mtPathWay::getPathWay()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:196
9	mtPathWay->getPathWayWithCurrentCat()	JROOT/components/com_mtree/mtree.tools.php:760
8	mtAppendCategoriesPathWay()	JROOT/components/com_mtree/mtree.tools.php:645
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:83
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.22 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 28 
  AND rgt > 47 
  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	11	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/administrator/components/com_mtree/admin.mtree.class.php:174
10	mtPathWay::getPathWay()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:196
9	mtPathWay->getPathWayWithCurrentCat()	JROOT/components/com_mtree/mtree.tools.php:760
8	mtAppendCategoriesPathWay()	JROOT/components/com_mtree/mtree.tools.php:645
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:83
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.31 ms After last query: 0.37 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
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:260
9	mtCats->__construct()	JROOT/components/com_mtree/mtree.tools.php:892
8	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:646
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:83
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 5.59 ms

Duplicate queries: #29

SELECT *

  FROM uz0jc_mt_cats

  WHERE `cat_id` = '58'

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:1455
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_mtree/mtree.tools.php:893
8	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:646
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:83
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.44 ms

SELECT * 
  FROM uz0jc_mt_cats 
  WHERE cat_id='58' 
  AND cat_published = 1 
  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,dtree,cat_id_index	cat_id	5	const,const	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:426
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.87 ms After last query: 1.16 ms

SELECT COUNT(*) 
  FROM (uz0jc_mt_links AS l, uz0jc_mt_cl AS cl) 
  WHERE l.link_published = 1 
  AND cl.cl_published =1 && l.link_approved = 1 && cl.cat_id = '58'
 
  AND ( l.publish_up = '0000-00-00 00:00:00' OR l.publish_up <= '2019-12-16 12:15:00'  ) 
 
  AND ( l.publish_down = '0000-00-00 00:00:00' OR l.publish_down >= '2019-12-16 12:15:00' ) 
 
  AND cl.link_id = l.link_id 
 
  AND l.link_published='1' 
  AND link_approved='1'

Explain

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

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:516
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 0.41 ms

SELECT cat.* 
  FROM uz0jc_mt_cats AS cat 
  WHERE cat_published=1 && cat_approved=1 && cat_parent= '58' 
  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	cat_parent	6	const,const,const	8	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
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.php:536
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.35 ms After last query: 0.53 ms

SELECT r.rel_id 
  FROM uz0jc_mt_relcats AS r 
  LEFT JOIN uz0jc_mt_cats AS c 
  ON c.cat_id = r.rel_id 
  WHERE r.cat_id = '58' 
  AND c.cat_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
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
12	JDatabaseDriver->loadColumn()	JROOT/components/com_mtree/mtree.php:597
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.65 ms After last query: 0.48 ms

SELECT l.*, tlcat.cat_id AS tlcat_id, tlcat.cat_name AS tlcat_name, cl.*, cat.*, u.username AS username, u.name AS owner, img.filename AS link_image 
  FROM uz0jc_mt_links AS l
 
  LEFT JOIN uz0jc_mt_cl AS cl 
  ON cl.link_id = l.link_id 
 
  LEFT JOIN uz0jc_users AS u 
  ON u.id = l.user_id 
 
  LEFT JOIN uz0jc_mt_cats AS cat 
  ON cl.cat_id = cat.cat_id 
 
  LEFT JOIN uz0jc_mt_cats AS tlcat 
  ON tlcat.lft <= cat.lft 
  AND tlcat.rgt >= cat.rgt 
  AND tlcat.cat_parent =0 
 
  LEFT JOIN uz0jc_mt_images AS img 
  ON img.link_id = l.link_id 
  AND img.ordering = 1 
 
  WHERE link_published='1' && link_approved='1' && cl.cl_published = 1 && cl.cat_id = '58' 
 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-12-16 12:15:00'  ) 
 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-12-16 12:15:00' ) 
 
  ORDER BY link_featured desc,l.year desc,l.price desc, link_name asc
 
  LIMIT 0, 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cl	ref	link_id,cat_id	cat_id	4	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	l	ref	publishing,count_listfeatured,count_viewowner,link_id_index	link_id_index	4	wdg20170206.cl.link_id	1	100.00	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	wdg20170206.l.user_id	1	100.00
1	SIMPLE	cat	ref	cat_id,cat_id_index	cat_id	4	wdg20170206.cl.cat_id	1	100.00
1	SIMPLE	tlcat	ref	cat_parent,lft_rgt,func_getPathWay	cat_parent	4	const	9	100.00	Using where
1	SIMPLE	img	ref	link_id_ordering	link_id_ordering	8	wdg20170206.cl.link_id,const	1	100.00	Using where

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:699
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 10.02 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM uz0jc_fields AS a

  LEFT JOIN `uz0jc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN uz0jc_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN uz0jc_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN uz0jc_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN uz0jc_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_mtree.category' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_mtree/mtree.php:724
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.27 ms After last query: 1.04 ms

SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS value, field_type 
  FROM uz0jc_mt_customfields

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_customfields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	82	100.00

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:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.tools.php:348
12	assignCommonListlinksVar()	JROOT/components/com_mtree/mtree.php:730
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 4.13 ms

Duplicate queries: #21

SELECT *

  FROM uz0jc_mt_cats

  WHERE `cat_id` = '58'

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
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_mtree/mtree.tools.php:893
12	getTopLevelCatID()	JROOT/components/com_mtree/mtree.php:751
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.44 ms After last query: 2.16 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:15:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-16 12:15:00') 
  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

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

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_subCatIndex.tpl.php:12
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 1.43 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

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:1730
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/config.mtree.class.php:175
15	mtConfig->getTemParam()	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:108
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 16.94 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.30 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 31 
  AND rgt > 32 
  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	12	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 4.53 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '58' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:838
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.50 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '4' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 1.06 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.30 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 29 
  AND rgt > 30 
  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	11	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.36 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '5' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.92 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.19 ms After last query: 0.32 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 33 
  AND rgt > 34 
  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	13	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.52 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '14' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 1.01 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.30 ms

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

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	15	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.71 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '20' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 1.00 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.30 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 35 
  AND rgt > 36 
  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	14	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.36 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '25' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 1.14 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.31 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 41 
  AND rgt > 42 
  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	16	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.42 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '29' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 0.98 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.05 ms After last query: 0.51 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 43 
  AND rgt > 44 
  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	16	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.59 ms After last query: 0.44 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '32' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 1.24 ms

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

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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
30	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:169
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.30 ms

SELECT cat_id 
  FROM uz0jc_mt_cats 
  WHERE lft < 37 
  AND rgt > 38 
  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	14	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
31	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:174
29	mtPathWay::getPathWay()	JROOT/components/com_mtree/router.php:741
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.39 ms

SELECT alias 
  FROM uz0jc_mt_cats 
  WHERE cat_id = '34' 
  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
32	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:226
30	mtPathWay->getCatAlias()	JROOT/components/com_mtree/router.php:843
29	appendCat_cached()	JROOT/components/com_mtree/router.php:788
28	appendCat()	JROOT/components/com_mtree/router.php:110
27	MtreeBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
26	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
25	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
24	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
21	Joomla\CMS\Router\Route::_()	JROOT/components/com_mtree/Savant2/Savant2_Plugin_ahref.php:95
20	Savant2_Plugin_ahref->plugin()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1153
18	Savant2->splugin()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_mtree/Savant2.php:1180
16	Savant2->plugin()	JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php:27
15	include JROOT/components/com_mtree/templates/weddingguide/sub_subCats.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:113
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.94 ms

Venues and Decoration

Featured Business

MT Top Advertizers!

Aerial May Floral Service & Bouquet

Taw Win Pan

Pwint Phu

JINLONG

Latest Posts

Our Guides

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

74 Queries Logged 2272.84 ms

10 duplicate found!

Venues and Decoration

Featured Business

MT Top Advertizers!

Aerial May Floral Service & Bouquet

Taw Win Pan

Pwint Phu

JINLONG

Latest Posts

Related Articles

Our Guides

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

74 Queries Logged 2272.84 ms

10 duplicate found!