Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576498563,
                "last": 1576498563,
                "now": 1576498563
            },
            "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: 19.28 ms / 19.28 ms Memory: 0.807 MB / 1.02 MB Application: afterLoad

Time: 287.96 ms / 307.24 ms Memory: 1.754 MB / 2.77 MB Application: afterInitialise

Time: 68.35 ms / 375.59 ms Memory: 1.079 MB / 3.85 MB Application: afterRoute

Time: 5.67 ms / 381.27 ms Memory: 0.011 MB / 3.86 MB Application: beforeRenderComponent com_mtree

Time: 317.24 ms / 698.51 ms Memory: 3.649 MB / 7.51 MB Application: afterRenderComponent com_mtree

Time: 4.35 ms / 702.86 ms Memory: 0.062 MB / 7.57 MB Application: afterDispatch

Time: 4.57 ms / 707.43 ms Memory: 0.051 MB / 7.63 MB Application: beforeRenderModule mod_custom (Our verticle section)

Time: 1.42 ms / 708.85 ms Memory: 0.013 MB / 7.64 MB Application: afterRenderModule mod_custom (Our verticle section)

Time: 0.29 ms / 709.14 ms Memory: 0.000 MB / 7.64 MB Application: beforeRenderModule mod_mt_featured (Ads Listing Banner Bottom)

Time: 2.75 ms / 711.89 ms Memory: 0.033 MB / 7.67 MB Application: afterRenderModule mod_mt_featured (Ads Listing Banner Bottom)

Time: 0.37 ms / 712.26 ms Memory: 0.000 MB / 7.66 MB Application: beforeRenderModule mod_custom_relatedarticles (mod_custom_relatedarticles)

Time: 5.74 ms / 717.99 ms Memory: 0.045 MB / 7.71 MB Application: afterRenderModule mod_custom_relatedarticles (mod_custom_relatedarticles)

Time: 0.51 ms / 718.51 ms Memory: 0.000 MB / 7.69 MB Application: beforeRenderModule mod_mt_topads (MT Top Advertizers!)

Time: 100.76 ms / 819.27 ms Memory: 0.112 MB / 7.81 MB Application: afterRenderModule mod_mt_topads (MT Top Advertizers!)

Time: 0.51 ms / 819.78 ms Memory: 0.000 MB / 7.76 MB Application: beforeRenderModule mod_mt_featured (Ads Listing Banner Sidebar Top)

Time: 3.60 ms / 823.38 ms Memory: 0.025 MB / 7.79 MB Application: afterRenderModule mod_mt_featured (Ads Listing Banner Sidebar Top)

Time: 0.38 ms / 823.76 ms Memory: 0.000 MB / 7.78 MB Application: beforeRenderModule mod_mt_featured (Ads Listing Banner Top)

Time: 10.72 ms / 834.48 ms Memory: 0.025 MB / 7.81 MB Application: afterRenderModule mod_mt_featured (Ads Listing Banner Top)

Time: 0.47 ms / 834.94 ms Memory: 0.000 MB / 7.80 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.27 ms / 837.22 ms Memory: 0.024 MB / 7.83 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.40 ms / 837.61 ms Memory: 0.000 MB / 7.82 MB Application: beforeRenderModule mod_mt_search (Moset Tree Search for Other Page)

Time: 25.45 ms / 863.06 ms Memory: 0.273 MB / 8.09 MB Application: afterRenderModule mod_mt_search (Moset Tree Search for Other Page)

Time: 0.84 ms / 863.90 ms Memory: 0.000 MB / 8.05 MB Application: beforeRenderModule mod_smartmenus (mod_smartmenus)

Time: 40.84 ms / 904.75 ms Memory: 0.241 MB / 8.29 MB Application: afterRenderModule mod_smartmenus (mod_smartmenus)

Time: 330.66 ms / 1235.40 ms Memory: 0.163 MB / 8.46 MB Application: afterRender

Database queries total: 354.40 ms

Memory Usage

Database Queries

79 Queries Logged 354.40 ms

17 duplicate found!

2 duplicates: #11 #75

3 duplicates: #13 #19 #73

3 duplicates: #14 #20 #74

3 duplicates: #24 #37 #41

3 duplicates: #25 #38 #42

3 duplicates: #67 #71 #72

Query Time: 4.25 ms

DELETE 

  FROM `uz0jc_session`

  WHERE `time` < '1576497663'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_session	range	time	time	59	NULL	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.89 ms After last query: 0.63 ms

SELECT `data`

  FROM `uz0jc_session`

  WHERE `session_id` = 'b49njn73pkf4n6njim8hd664o3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_session	const	PRIMARY	PRIMARY	766	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:831
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 2.62 ms After last query: 1.28 ms

SELECT `session_id`

  FROM `uz0jc_session`

  WHERE `session_id` = 'b49njn73pkf4n6njim8hd664o3' 
  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.82 ms After last query: 3.44 ms

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

Explain

EXPLAIN not possible on query: INSERT INTO `uz0jc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b49njn73pkf4n6njim8hd664o3', 1, '1576498563', 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: 2.48 ms After last query: 5.11 ms

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

  FROM `uz0jc_extensions`

  WHERE `type` = 'component'

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: 2.90 ms After last query: 2.12 ms

SELECT id, rules

  FROM `uz0jc_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.73 ms

SELECT b.id

  FROM uz0jc_usergroups AS a

  LEFT JOIN uz0jc_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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: 3.38 ms After last query: 0.68 ms

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM uz0jc_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

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.26 ms After last query: 228.79 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.02 ms After last query: 9.73 ms

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM uz0jc_menu AS m

  LEFT JOIN uz0jc_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

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: 5.10 ms After last query: 21.52 ms

Duplicate queries: #75

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: 3.65 ms After last query: 4.05 ms

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

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:670
10	MtreeParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Duplicate queries: #19 #73

SELECT cat_id, cat_parent, metadata, lft, rgt 
  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
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:129
12	mtConfig->setCategory()	JROOT/components/com_mtree/router.php:929
11	findCatID()	JROOT/components/com_mtree/router.php:670
10	MtreeParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.16 ms

Duplicate queries: #20 #74

SELECT cat_id, metadata 
  FROM uz0jc_mt_cats 

  WHERE lft < 39 && rgt > 40 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	range	cat_parent,lft_rgt,func_getPathWay	func_getPathWay	4	NULL	15	100.00	Using index condition

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:144
12	mtConfig->setCategory()	JROOT/components/com_mtree/router.php:929
11	findCatID()	JROOT/components/com_mtree/router.php:670
10	MtreeParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.35 ms After last query: 3.40 ms

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

  FROM `uz0jc_extensions`

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

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: 1.90 ms After last query: 5.11 ms

UPDATE `uz0jc_extensions`

  SET `params` = '{\"mediaversion\":\"38ca787bd0192c154296460d9b4250e9\"}'

  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.87 ms After last query: 4.07 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.58 ms After last query: 3.45 ms

SELECT id, home, template, s.params

  FROM uz0jc_template_styles as s

  LEFT JOIN uz0jc_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

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: 0.32 ms After last query: 23.30 ms

Duplicate queries: #13 #73

SELECT cat_id, cat_parent, metadata, lft, rgt 
  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
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.36 ms After last query: 0.16 ms

Duplicate queries: #14 #74

SELECT cat_id, metadata 
  FROM uz0jc_mt_cats 

  WHERE lft < 39 && rgt > 40 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	range	cat_parent,lft_rgt,func_getPathWay	func_getPathWay	4	NULL	15	100.00	Using index condition

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:144
8	mtConfig->setCategory()	JROOT/components/com_mtree/init.php:24
7	require JROOT/components/com_mtree/init.php	JROOT/components/com_mtree/mtree.php:17
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 3.48 ms

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

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.12 ms After last query: 0.18 ms

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

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
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: 1.28 ms After last query: 0.21 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.17 ms After last query: 1.11 ms

Duplicate queries: #37 #41

SELECT *

  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
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.14 ms After last query: 0.29 ms

Duplicate queries: #38 #42

SELECT cat_id 
  FROM uz0jc_mt_cats 

  WHERE lft = 39 && rgt = 40 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	ref	cat_parent,lft_rgt,func_getPathWay	func_getPathWay	8	const,const	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
9	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.tools.php:905
8	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:646
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:83
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

SELECT * 
  FROM uz0jc_mt_cats 
  WHERE cat_id='20' 
  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: 120.65 ms After last query: 0.79 ms

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

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	399	100.00	Using where
1	SIMPLE	l	ref	publishing,count_listfeatured,count_viewowner,link_id_index	link_id_index	4	wdg20170206.cl.link_id	1	100.00	Using where

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: 0.26 ms After last query: 0.57 ms

SELECT cat.* 
  FROM uz0jc_mt_cats AS cat 
  WHERE cat_published=1 && cat_approved=1 && cat_parent= '20' 
  ORDER BY cat_name asc

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	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
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: 0.18 ms After last query: 0.23 ms

SELECT r.rel_id 
  FROM uz0jc_mt_relcats AS r 
  LEFT JOIN uz0jc_mt_cats AS c 
  ON c.cat_id = r.rel_id 
  WHERE r.cat_id = '20' 
  AND c.cat_published = 1

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: 68.37 ms After last query: 0.32 ms

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

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	399	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	l	ref	publishing,count_listfeatured,count_viewowner,link_id_index	link_id_index	4	wdg20170206.cl.link_id	1	100.00	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	wdg20170206.l.user_id	1	100.00
1	SIMPLE	cat	ref	cat_id,cat_id_index	cat_id	4	wdg20170206.cl.cat_id	1	100.00
1	SIMPLE	tlcat	ref	cat_parent,lft_rgt,func_getPathWay	cat_parent	4	const	9	100.00	Using where
1	SIMPLE	img	ref	link_id_ordering	link_id_ordering	8	wdg20170206.cl.link_id,const	1	100.00	Using where

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.28 ms After last query: 7.26 ms

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

  FROM uz0jc_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

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: 0.24 ms After last query: 1.93 ms

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

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

Query Time: 0.23 ms After last query: 0.99 ms

SELECT cf_id 
  FROM uz0jc_mt_fields_map 
  WHERE cat_id = 58

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_fields_map	index	NULL	PRIMARY	8	NULL	76656	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/components/com_mtree/mtree.tools.php:870
13	getAssignedFieldsID()	JROOT/components/com_mtree/mtree.tools.php:337
12	assignCommonListlinksVar()	JROOT/components/com_mtree/mtree.php:730
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

SELECT cf_id 
  FROM uz0jc_mt_customfields 
  WHERE cf_id IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81) 
  AND published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_customfields	ALL	PRIMARY,published_ordering	NO INDEX KEY COULD BE USED	NULL	NULL	82	96.34	Using where

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

[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.63 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.22 ms After last query: 0.88 ms

SELECT cf.*, cfv.link_id, cfv.value, cfv.attachment, cfv.counter 
  FROM uz0jc_mt_customfields AS cf 

  LEFT JOIN uz0jc_mt_cfvalues AS cfv 
  ON cf.cf_id=cfv.cf_id 

  AND cfv.link_id IN (33331,18614,10982,12078,39081,10197,11479,21206,32655) 

  WHERE cf.published = '1' 
  AND cf.summary_view = '1' 

  AND cf.cf_id IN (1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,67,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,68,69,70,71,72,73,74,75,76,77,78,79,80,81) 

  ORDER BY cf.ordering ASC, link_id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cf	ALL	PRIMARY,published_ordering	NO INDEX KEY COULD BE USED	NULL	NULL	82	92.68	Using where; Using temporary; Using filesort
1	SIMPLE	cfv	range	cf_id,link_id	link_id	4	NULL	9	77.78	Using where; Using join buffer (flat, BNL join)

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

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

Duplicate queries: #24 #41

SELECT *

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

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

Query Time: 0.21 ms After last query: 0.39 ms

Duplicate queries: #25 #42

SELECT cat_id 
  FROM uz0jc_mt_cats 

  WHERE lft = 39 && rgt = 40 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	ref	cat_parent,lft_rgt,func_getPathWay	func_getPathWay	8	const,const	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.tools.php:905
13	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:388
12	assignCommonListlinksVar()	JROOT/components/com_mtree/mtree.php:730
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Query Time: 0.41 ms After last query: 32.79 ms

SELECT r.link_id, COUNT( * ) AS total 
  FROM uz0jc_mt_cl AS cl 
 
  LEFT JOIN uz0jc_mt_reviews AS r 
  ON cl.link_id = r.link_id 
 
  WHERE cl.link_id IN ('33331','18614','10982','12078','39081','10197','11479','21206','32655') 
  AND r.rev_approved = '1' 
  AND cl.main = '1'
 
  GROUP BY r.link_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	index	link_id	link_id	10	NULL	6	83.33	Using where; Using index
1	SIMPLE	cl	ref	link_id	link_id	4	wdg20170206.r.link_id	1	100.00	Using index condition; Using where

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

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

Query Time: 0.25 ms After last query: 1.59 ms

Duplicate queries: #24 #37

SELECT *

  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
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: 0.20 ms After last query: 0.38 ms

Duplicate queries: #25 #38

SELECT cat_id 
  FROM uz0jc_mt_cats 

  WHERE lft = 39 && rgt = 40 && cat_parent >= 0

  ORDER BY lft ASC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	uz0jc_mt_cats	ref	cat_parent,lft_rgt,func_getPathWay	func_getPathWay	8	const,const	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.tools.php:905
12	getTopLevelCatID()	JROOT/components/com_mtree/mtree.php:751
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 1.80 ms

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM uz0jc_modules AS m

  LEFT JOIN uz0jc_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN uz0jc_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-16 12:16:03') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-16 12:16:03') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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.26 ms After last query: 1.23 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.23 ms After last query: 0.98 ms

SELECT cat.cat_id, cat.cat_name 
  FROM uz0jc_mt_cl cl 
							
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id 
							
  WHERE cl.link_id = 33331 
  AND main = 1 ;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 2.02 ms

SELECT c.cat_id,c.cat_name,c.cat_parent 
  FROM uz0jc_mt_links l
				 	
  INNER JOIN uz0jc_mt_cl cl 
  ON l.link_id = cl.link_id
				 	
  INNER JOIN uz0jc_mt_cats c 
  ON c.cat_id = cl.cat_id
					
  WHERE cl.cl_published =1 
  and  l.link_id = 33331 
  order by cl.main DESC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.82 ms

SELECT cat.cat_id, cat.cat_name 
  FROM uz0jc_mt_cl cl 
							
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id 
							
  WHERE cl.link_id = 18614 
  AND main = 1 ;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.36 ms After last query: 1.37 ms

SELECT c.cat_id,c.cat_name,c.cat_parent 
  FROM uz0jc_mt_links l
				 	
  INNER JOIN uz0jc_mt_cl cl 
  ON l.link_id = cl.link_id
				 	
  INNER JOIN uz0jc_mt_cats c 
  ON c.cat_id = cl.cat_id
					
  WHERE cl.cl_published =1 
  and  l.link_id = 18614 
  order by cl.main DESC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

SELECT cat.cat_id, cat.cat_name 
  FROM uz0jc_mt_cl cl 
							
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id 
							
  WHERE cl.link_id = 10982 
  AND main = 1 ;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.12 ms After last query: 1.34 ms

SELECT c.cat_id,c.cat_name,c.cat_parent 
  FROM uz0jc_mt_links l
				 	
  INNER JOIN uz0jc_mt_cl cl 
  ON l.link_id = cl.link_id
				 	
  INNER JOIN uz0jc_mt_cats c 
  ON c.cat_id = cl.cat_id
					
  WHERE cl.cl_published =1 
  and  l.link_id = 10982 
  order by cl.main DESC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

SELECT cat.cat_id, cat.cat_name 
  FROM uz0jc_mt_cl cl 
							
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id 
							
  WHERE cl.link_id = 12078 
  AND main = 1 ;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.88 ms After last query: 1.64 ms

SELECT c.cat_id,c.cat_name,c.cat_parent 
  FROM uz0jc_mt_links l
				 	
  INNER JOIN uz0jc_mt_cl cl 
  ON l.link_id = cl.link_id
				 	
  INNER JOIN uz0jc_mt_cats c 
  ON c.cat_id = cl.cat_id
					
  WHERE cl.cl_published =1 
  and  l.link_id = 12078 
  order by cl.main DESC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:142
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.76 ms

SELECT cat.cat_id, cat.cat_name 
  FROM uz0jc_mt_cl cl 
							
  INNER JOIN uz0jc_mt_cats cat 
  ON cat.cat_id = cl.cat_id 
							
  WHERE cl.link_id = 39081 
  AND main = 1 ;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php:74
16	include JROOT/components/com_mtree/templates/weddingguide/sub_listingSummary.tpl.php	JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php:101
15	include JROOT/components/com_mtree/templates/weddingguide/sub_listings.tpl.php	JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php:119
14	include JROOT/components/com_mtree/templates/weddingguide/page_subCatIndex.tpl.php	JROOT/components/com_mtree/Savant2.php:984
13	Savant2->fetch()	JROOT/components/com_mtree/Savant2.php:1013
12	Savant2->display()	JROOT/components/com_mtree/mtree.php:766
11	showTree_cache()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
9	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
8	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_mtree/mtree.php:481
7	showTree()	JROOT/components/com_mtree/mtree.php:387
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.10 ms After last query: 1.32 ms

Flowers and Florist (156)

May Myint [Ma]

Millioner

Mingalar Pann Kone

Mon Mon's Beauty Salon

Mya

Mya Kyi [Daw]

Mya Lay [Daw]

Mya Shin [Daw]

Mya Thuzar

Featured Business

MT Top Advertizers!

OSCAR

Hein Htet Zen

Royal Flowers

LOVE & RAIN

Latest Posts

Our Guides

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

79 Queries Logged 354.40 ms

17 duplicate found!

Flowers and Florist (156)

May Myint [Ma]

Millioner

Mingalar Pann Kone

Mon Mon's Beauty Salon

Mya

Mya Kyi [Daw]

Mya Lay [Daw]

Mya Shin [Daw]

Mya Thuzar

Featured Business

MT Top Advertizers!

OSCAR

Hein Htet Zen

Royal Flowers

LOVE & RAIN

Latest Posts

Related Articles

Our Guides

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

79 Queries Logged 354.40 ms

17 duplicate found!