Arts

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1554312491,
                "last": 1554312491,
                "now": 1554312491
            },
            "client": {
                "forwarded": "207.241.229.150"
            }
        },
        "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: 6.12 ms / 6.12 ms Memory: 0.513 MB / 0.88 MB Application: afterLoad

Time: 36.10 ms / 42.22 ms Memory: 1.240 MB / 2.12 MB Application: afterInitialise

Time: 26.92 ms / 69.14 ms Memory: 0.981 MB / 3.11 MB Application: afterRoute

Time: 4.78 ms / 73.92 ms Memory: 0.185 MB / 3.29 MB Application: beforeRenderComponent com_mtree

Time: 109.62 ms / 183.54 ms Memory: 1.020 MB / 4.31 MB Application: afterRenderComponent com_mtree

Time: 0.69 ms / 184.23 ms Memory: 0.006 MB / 4.32 MB Application: afterDispatch

Time: 26.91 ms / 211.14 ms Memory: 0.280 MB / 4.60 MB Application: beforeRenderModule mod_menu (Fellowship Groups)

Time: 1.19 ms / 212.33 ms Memory: 0.034 MB / 4.63 MB Application: afterRenderModule mod_menu (Fellowship Groups)

Time: 1.75 ms / 214.08 ms Memory: 0.004 MB / 4.63 MB Application: beforeRenderModule mod_articles_latest (Latest News)

Time: 1.22 ms / 215.30 ms Memory: 0.039 MB / 4.67 MB Application: Before Access::preloadComponents (all components)

Time: 3.96 ms / 219.26 ms Memory: 0.077 MB / 4.75 MB Application: After Access::preloadComponents (all components)

Time: 0.08 ms / 219.34 ms Memory: 0.000 MB / 4.75 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.34 ms / 219.67 ms Memory: 0.009 MB / 4.76 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 2.02 ms / 221.70 ms Memory: 0.000 MB / 4.75 MB Application: afterRenderModule mod_articles_latest (Latest News)

Time: 0.93 ms / 222.63 ms Memory: 0.001 MB / 4.75 MB Application: beforeRenderModule mod_menu (General Assembly Office)

Time: 1.08 ms / 223.70 ms Memory: 0.027 MB / 4.78 MB Application: afterRenderModule mod_menu (General Assembly Office)

Time: 0.85 ms / 224.55 ms Memory: 0.001 MB / 4.78 MB Application: beforeRenderModule mod_menu (Assemblies Resources)

Time: 1.08 ms / 225.63 ms Memory: 0.033 MB / 4.81 MB Application: afterRenderModule mod_menu (Assemblies Resources)

Time: 0.87 ms / 226.50 ms Memory: 0.002 MB / 4.82 MB Application: beforeRenderModule mod_menu (General Assembly)

Time: 0.74 ms / 227.24 ms Memory: 0.019 MB / 4.83 MB Application: afterRenderModule mod_menu (General Assembly)

Time: 5.43 ms / 232.67 ms Memory: 0.057 MB / 4.89 MB Application: beforeRenderModule mod_search (Search)

Time: 0.83 ms / 233.50 ms Memory: 0.013 MB / 4.90 MB Application: afterRenderModule mod_search (Search)

Time: 0.04 ms / 233.54 ms Memory: 0.000 MB / 4.90 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 2.28 ms / 235.82 ms Memory: 0.048 MB / 4.95 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.15 ms / 235.97 ms Memory: 0.000 MB / 4.94 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.52 ms / 236.49 ms Memory: 0.006 MB / 4.95 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.07 ms / 236.56 ms Memory: 0.000 MB / 4.95 MB Application: beforeRenderModule mod_menu (Quick Links)

Time: 0.78 ms / 237.34 ms Memory: 0.024 MB / 4.97 MB Application: afterRenderModule mod_menu (Quick Links)

Time: 0.07 ms / 237.41 ms Memory: 0.000 MB / 4.97 MB Application: beforeRenderModule mod_menu (Agencies)

Time: 0.87 ms / 238.28 ms Memory: 0.024 MB / 4.99 MB Application: afterRenderModule mod_menu (Agencies)

Time: 0.06 ms / 238.35 ms Memory: 0.000 MB / 4.99 MB Application: beforeRenderModule mod_menu (Fellowship Groups)

Time: 0.73 ms / 239.08 ms Memory: 0.007 MB / 4.99 MB Application: afterRenderModule mod_menu (Fellowship Groups)

Time: 0.07 ms / 239.15 ms Memory: 0.000 MB / 4.99 MB Application: beforeRenderModule mod_mt_browse (mod_mt_browse)

Time: 30.13 ms / 269.28 ms Memory: 0.278 MB / 5.27 MB Application: afterRenderModule mod_mt_browse (mod_mt_browse)

Time: 0.16 ms / 269.44 ms Memory: 0.000 MB / 5.26 MB Application: beforeRenderModule mod_search (Search)

Time: 0.30 ms / 269.75 ms Memory: 0.022 MB / 5.28 MB Application: beforeRenderModule mod_tags_popular (Frequently Search Tags)

Time: 5.23 ms / 274.97 ms Memory: 0.039 MB / 5.32 MB Application: afterRenderModule mod_tags_popular (Frequently Search Tags)

Time: 0.05 ms / 275.02 ms Memory: 0.000 MB / 5.32 MB Application: beforeRenderModule mod_sppagebuilder (Get in Touch)

Time: 74.91 ms / 349.93 ms Memory: 1.666 MB / 6.98 MB Application: afterRenderModule mod_sppagebuilder (Get in Touch)

Time: 0.07 ms / 350.00 ms Memory: 0.000 MB / 6.96 MB Application: afterRenderModule mod_sppagebuilder (Get in Touch)

Time: 4.70 ms / 354.70 ms Memory: 0.511 MB / 7.47 MB Application: afterRender

Database queries total: 137.78 ms

Memory Usage

Database Queries

145 Queries Logged 137.78 ms

93 duplicate found!

8 duplicates: #11 #28 #31 #34 #54 #66 #69 #72

4 duplicates: #13 #19 #51 #55

3 duplicates: #23 #25 #41

2 duplicates: #29 #67

2 duplicates: #30 #68

2 duplicates: #32 #70

2 duplicates: #33 #71

2 duplicates: #35 #73

2 duplicates: #36 #74

63 duplicates: #76 #77 #78 #79 #80 #81 #82 #86 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #119 #122 #123 #124 #125 #126 #127 #128 #129 #130 #131 #132 #133 #134 #135 #136 #137 #138 #139 #140 #141 #142 #143 #144

3 duplicates: #84 #85 #87

Query Time: 0.70 ms Query memory: 0.007 MB Memory before query: 1.205 MB Rows returned: 0

SELECT `data`

  FROM `yemkz_session`

  WHERE `session_id` = 'd97f8451c5bd0390ef3d1677a4dbd0bd'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.59 ms After last query: 0.42 ms Query memory: 0.004 MB Memory before query: 1.221 MB Rows returned: 0

SELECT `session_id`

  FROM `yemkz_session`

  WHERE `session_id` = 'd97f8451c5bd0390ef3d1677a4dbd0bd' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_session	const	PRIMARY	PRIMARY	194	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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.86 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.226 MB

INSERT INTO `yemkz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('d97f8451c5bd0390ef3d1677a4dbd0bd', 1, 1554312491, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `yemkz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('d97f8451c5bd0390ef3d1677a4dbd0bd', 1, 1554312491, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.12 ms After last query: 0.87 ms Query memory: 0.006 MB Memory before query: 1.261 MB Rows returned: 45

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

  FROM `yemkz_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_extensions	ref	extension	extension	82	const	46	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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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:196
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.57 ms After last query: 0.80 ms Query memory: 0.005 MB Memory before query: 1.379 MB Rows returned: 6

SELECT id, rules

  FROM `yemkz_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:604
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.08 ms Query memory: 0.005 MB Memory before query: 1.392 MB Rows returned: 0

SELECT b.id

  FROM yemkz_usergroups AS a

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

  WHERE a.id = 13

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:604
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:196
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.76 ms After last query: 0.17 ms Query memory: 0.005 MB Memory before query: 1.413 MB Rows returned: 208

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

  FROM yemkz_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_extensions	ref	extension	extension	82	const	233	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
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:604
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:196
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.67 ms After last query: 11.80 ms Query memory: 0.005 MB Memory before query: 2.107 MB Rows returned: 1

SELECT `lastupdate`

  FROM `yemkz_ak_storage`

  WHERE `tag` = 'akeebaupdatecheck_lastrun'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:116
8	plgSystemAkeebaupdatecheck->onAfterInitialise()	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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:196
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.57 ms After last query: 0.31 ms Query memory: 0.005 MB Memory before query: 2.117 MB Rows returned: 1

SELECT count(1)

  FROM `yemkz_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
8	plgSystemARKtypography->onAfterInitialise()	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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:196
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.24 ms After last query: 1.08 ms Query memory: 0.009 MB Memory before query: 2.155 MB Rows returned: 104

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 yemkz_menu AS m

  LEFT JOIN yemkz_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	344	86.92	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	pceacqov_assembly.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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:375
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:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 4.44 ms Query memory: 0.007 MB Memory before query: 2.708 MB Rows returned: 313

Duplicate queries: #28 #31 #34 #54 #66 #69 #72

SELECT `varname`, `value`, `default` 
  FROM yemkz_mt_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_mtree/config.mtree.class.php:78
11	mtConfig->mtConfig()	JROOT/administrator/components/com_mtree/config.mtree.class.php:30
10	mtFactory::createConfig()	JROOT/administrator/components/com_mtree/config.mtree.class.php:22
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:775
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:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
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.74 ms After last query: 1.76 ms Query memory: 0.006 MB Memory before query: 2.956 MB Rows returned: 1

SELECT cat_id, cat_parent, alias 
  FROM yemkz_mt_cats 
  WHERE cat_published='1' 
  AND cat_approved='1' && BINARY alias = 'arts'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	ALL	dtree	NO INDEX KEY COULD BE USED	NULL	NULL	45	86.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/router.php:978
11	findCatID()	JROOT/components/com_mtree/router.php:725
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:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
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.50 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 2.962 MB Rows returned: 1

Duplicate queries: #19 #51 #55

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id	PRIMARY	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:138
12	mtConfig->setCategory()	JROOT/components/com_mtree/router.php:982
11	findCatID()	JROOT/components/com_mtree/router.php:725
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:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 3.74 ms Query memory: 0.009 MB Memory before query: 3.085 MB Rows returned: 1

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

  FROM `yemkz_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
8	plgSystemARKtypography->onAfterRoute()	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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.43 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 3.078 MB

UPDATE `yemkz_extensions`

  SET `params` = '{\"mediaversion\":\"8ab7ab14c47d69da5a21040cf76d68a4\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
8	plgSystemARKtypography->onAfterRoute()	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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.93 ms Query memory: 0.005 MB Memory before query: 3.100 MB Rows returned: 1

SELECT params

  FROM `yemkz_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
8	plgSystemARKtypography->onAfterRoute()	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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:196
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.14 ms After last query: 0.93 ms Query memory: 0.004 MB Memory before query: 3.111 MB Rows returned: 1

SELECT *

  FROM yemkz_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	yemkz_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
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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: 0.35 ms Query memory: 0.003 MB Memory before query: 3.123 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM yemkz_template_styles as s

  LEFT JOIN yemkz_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	6	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	pceacqov_assembly.e.element	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
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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.66 ms After last query: 38.38 ms Query memory: 0.006 MB Memory before query: 3.420 MB Rows returned: 1

Duplicate queries: #13 #51 #55

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id	PRIMARY	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:138
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.61 ms After last query: 12.38 ms Query memory: 0.006 MB Memory before query: 3.557 MB Rows returned: 1

SELECT cat_name, cat_id, lft, rgt 
  FROM yemkz_mt_cats 
  WHERE cat_id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id	PRIMARY	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:189
10	mtPathWay::getPathWay()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:216
9	mtPathWay->getPathWayWithCurrentCat()	JROOT/components/com_mtree/mtree.tools.php:764
8	mtAppendCategoriesPathWay()	JROOT/components/com_mtree/mtree.tools.php:648
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:82
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.69 ms After last query: 0.06 ms Query memory: 0.006 MB Memory before query: 3.563 MB Rows returned: 0

SELECT cat_id 
  FROM yemkz_mt_cats 
  WHERE lft < 80 
  AND rgt > 89 
  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	yemkz_mt_cats	range	PRIMARY,cat_id,cat_parent,lft_rgt,func_getPathWay	func_getPathWay	4	NULL	40	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:194
10	mtPathWay::getPathWay()	JROOT/administrator/components/com_mtree/admin.mtree.class.php:216
9	mtPathWay->getPathWayWithCurrentCat()	JROOT/components/com_mtree/mtree.tools.php:764
8	mtAppendCategoriesPathWay()	JROOT/components/com_mtree/mtree.tools.php:648
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:82
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.57 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 3.572 MB Rows returned: 24

SHOW FULL COLUMNS 
  FROM `yemkz_mt_cats`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
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:280
9	mtCats->__construct()	JROOT/components/com_mtree/mtree.tools.php:896
8	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:649
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:82
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.62 ms After last query: 0.48 ms Query memory: 0.006 MB Memory before query: 3.618 MB Rows returned: 1

Duplicate queries: #25 #41

SELECT *

  FROM yemkz_mt_cats

  WHERE `cat_id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id	PRIMARY	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_mtree/mtree.tools.php:897
8	getTopLevelCatID()	JROOT/components/com_mtree/mtree.tools.php:649
7	mtAppendPathWay()	JROOT/components/com_mtree/mtree.php:82
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.61 ms After last query: 0.14 ms Query memory: 0.005 MB Memory before query: 3.616 MB Rows returned: 1

SELECT * 
  FROM yemkz_mt_cats 
  WHERE cat_id='1' 
  AND cat_published = 1 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id,dtree	PRIMARY	4	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
8	JDatabaseDriver->loadObject()	JROOT/components/com_mtree/mtree.php:535
7	showTree()	JROOT/components/com_mtree/mtree.php:471
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.58 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 3.632 MB Rows returned: 1

Duplicate queries: #23 #41

SELECT *

  FROM yemkz_mt_cats

  WHERE `cat_id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id	PRIMARY	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_mtree/mtree.tools.php:897
8	getTopLevelCatID()	JROOT/components/com_mtree/mtree.php:548
7	showTree()	JROOT/components/com_mtree/mtree.php:471
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.25 ms After last query: 0.48 ms Query memory: 0.006 MB Memory before query: 3.650 MB Rows returned: 1

SELECT COUNT(*) 
  FROM (yemkz_mt_links AS l, yemkz_mt_cl AS cl) 
  WHERE l.link_published = 1 
  AND l.link_approved = 1 && cl.cat_id = '1'
 
  AND ( l.publish_up = '0000-00-00 00:00:00' OR l.publish_up <= '2019-04-03 17:28:11'  ) 
 
  AND ( l.publish_down = '0000-00-00 00:00:00' OR l.publish_down >= '2019-04-03 17:28:11' ) 
 
  AND cl.link_id = l.link_id

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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/components/com_mtree/mtree.php:618
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:585
7	showTree()	JROOT/components/com_mtree/mtree.php:471
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.90 ms After last query: 0.15 ms Query memory: 0.006 MB Memory before query: 3.656 MB Rows returned: 3

SELECT cat.* 
  FROM yemkz_mt_cats AS cat 
  WHERE cat_published=1 && cat_approved=1 && cat_parent= '1' 
  ORDER BY cat_name asc, cat_created 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	3	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_mtree/mtree.php:638
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:585
7	showTree()	JROOT/components/com_mtree/mtree.php:471
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.06 ms After last query: 0.10 ms Query memory: 0.008 MB Memory before query: 3.673 MB Rows returned: 313

Duplicate queries: #11 #31 #34 #54 #66 #69 #72

SELECT `varname`, `value`, `default` 
  FROM yemkz_mt_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_mtree/config.mtree.class.php:78
15	mtConfig->mtConfig()	JROOT/administrator/components/com_mtree/config.mtree.class.php:30
14	mtFactory::createConfig()	JROOT/components/com_mtree/mtree.tools.php:990
13	isAuthorisedToViewCategory()	Same as call in the line below.
12	array_filter()	JROOT/components/com_mtree/mtree.php:641
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:585
7	showTree()	JROOT/components/com_mtree/mtree.php:471
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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.56 ms After last query: 0.68 ms Query memory: 0.007 MB Memory before query: 3.898 MB Rows returned: 1

Duplicate queries: #67

SELECT cat_id, cat_parent, metadata, lft, rgt 
  FROM yemkz_mt_cats 
  WHERE cat_id = 8 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yemkz_mt_cats	const	PRIMARY,cat_id	PRIMARY	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	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_mtree/config.mtree.class.php:138
14	mtConfig->setCategory()	JROOT/components/com_mtree/mtree.tools.php:991
13	isAuthorisedToViewCategory()	Same as call in the line below.
12	array_filter()	JROOT/components/com_mtree/mtree.php:641
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:585
7	showTree()	JROOT/components/com_mtree/mtree.php:471
6	require_once JROOT/components/com_mtree/mtree.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:196
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:

Frequently Search Tags

Get in Touch

Email Address

Phone Number

mod_mt_browse

Fellowship Groups

Agencies

Quick Links

Contact Us

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

145 Queries Logged 137.78 ms

93 duplicate found!