Layanan Pertanian

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1558691101,
                "last": 1558691101,
                "now": 1558691101
            },
            "client": {
                "forwarded": "54.91.41.87"
            },
            "token": "G4W76f8bcsDJN7esj3oa4VvcjaCVfyPd"
        },
        "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**: 22.55 ms / 22.55 ms **Memory**: 1.913 MB / 2.14 MB Application: afterLoad

**Time**: 112.51 ms / 135.07 ms **Memory**: 5.646 MB / 7.78 MB Application: afterInitialise

**Time**: 41.83 ms / 176.90 ms **Memory**: 2.591 MB / 10.38 MB Application: afterRoute

**Time**: 1.89 ms / 178.79 ms **Memory**: 0.049 MB / 10.42 MB Application: beforeRenderComponent com_content

**Time**: 10.81 ms / 189.59 ms **Memory**: 1.077 MB / 11.50 MB Application: Before Access::preloadComponents (all components)

**Time**: 2.23 ms / 191.82 ms **Memory**: 0.093 MB / 11.59 MB Application: After Access::preloadComponents (all components)

**Time**: 0.07 ms / 191.90 ms **Memory**: 0.000 MB / 11.59 MB Application: Before Access::preloadPermissions (com_content)

**Time**: 2.43 ms / 194.33 ms **Memory**: 0.365 MB / 11.95 MB Application: After Access::preloadPermissions (com_content)

**Time**: 0.12 ms / 194.45 ms **Memory**: 0.000 MB / 11.93 MB Application: Before Access::getAssetRules (id:325 name:com_content.category.44)

**Time**: 0.99 ms / 195.44 ms **Memory**: 0.050 MB / 11.98 MB Application: After Access::getAssetRules (id:325 name:com_content.category.44)

**Time**: 6.15 ms / 201.59 ms **Memory**: 0.385 MB / 12.37 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Time**: 0.04 ms / 201.63 ms **Memory**: 0.003 MB / 12.37 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Time**: 60.47 ms / 262.10 ms **Memory**: 6.689 MB / 19.06 MB Application: afterRenderComponent com_content

**Time**: 0.85 ms / 262.95 ms **Memory**: 0.011 MB / 19.07 MB Application: afterDispatch

**Time**: 13.79 ms / 276.74 ms **Memory**: 0.766 MB / 19.84 MB Application: beforeRenderModule mod_custom (bottom1)

**Time**: 1.19 ms / 277.93 ms **Memory**: 0.048 MB / 19.89 MB Application: afterRenderModule mod_custom (bottom1)

**Time**: 0.10 ms / 278.02 ms **Memory**: 0.000 MB / 19.88 MB Application: beforeRenderModule mod_custom (copyright)

**Time**: 0.25 ms / 278.28 ms **Memory**: 0.007 MB / 19.89 MB Application: afterRenderModule mod_custom (copyright)

**Time**: 0.10 ms / 278.38 ms **Memory**: 0.004 MB / 19.89 MB Application: beforeRenderModule mod_bt_googlemaps (Lokasi Kantor)

**Time**: 1.97 ms / 280.34 ms **Memory**: 0.067 MB / 19.96 MB Application: afterRenderModule mod_bt_googlemaps (Lokasi Kantor)

**Time**: 0.11 ms / 280.45 ms **Memory**: 0.000 MB / 19.94 MB Application: beforeRenderModule mod_sp_simple_youtube (Rumah Kedelai Grobogan)

**Time**: 0.69 ms / 281.14 ms **Memory**: 0.012 MB / 19.96 MB Application: afterRenderModule mod_sp_simple_youtube (Rumah Kedelai Grobogan)

**Time**: 0.05 ms / 281.19 ms **Memory**: 0.000 MB / 19.95 MB Application: beforeRenderModule mod_sp_simple_youtube (Kedelai Grobogan)

**Time**: 0.27 ms / 281.46 ms **Memory**: 0.009 MB / 19.96 MB Application: afterRenderModule mod_sp_simple_youtube (Kedelai Grobogan)

**Time**: 0.08 ms / 281.54 ms **Memory**: 0.013 MB / 19.97 MB Application: beforeRenderModule mod_cwnews (Straight News)

**Time**: 64.17 ms / 345.71 ms **Memory**: 3.070 MB / 23.04 MB Application: afterRenderModule mod_cwnews (Straight News)

**Time**: 0.55 ms / 346.26 ms **Memory**: 0.000 MB / 22.08 MB Application: beforeRenderModule mod_banners (twitter)

**Time**: 13.59 ms / 359.85 ms **Memory**: 0.224 MB / 22.30 MB Application: afterRenderModule mod_banners (twitter)

**Time**: 0.08 ms / 359.93 ms **Memory**: 0.000 MB / 22.29 MB Application: beforeRenderModule mod_banners (sms center)

**Time**: 10.79 ms / 370.72 ms **Memory**: 0.068 MB / 22.36 MB Application: afterRenderModule mod_banners (sms center)

**Time**: 0.07 ms / 370.79 ms **Memory**: 0.000 MB / 22.35 MB Application: beforeRenderModule mod_banners (layanan publik)

**Time**: 11.33 ms / 382.11 ms **Memory**: 0.068 MB / 22.42 MB Application: afterRenderModule mod_banners (layanan publik)

**Time**: 0.10 ms / 382.21 ms **Memory**: 0.000 MB / 22.41 MB Application: beforeRenderModule mod_banners (RKG)

**Time**: 13.56 ms / 395.77 ms **Memory**: 0.069 MB / 22.48 MB Application: afterRenderModule mod_banners (RKG)

**Time**: 0.08 ms / 395.85 ms **Memory**: 0.000 MB / 22.47 MB Application: beforeRenderModule mod_banners (facebook)

**Time**: 39.12 ms / 434.97 ms **Memory**: 0.068 MB / 22.54 MB Application: afterRenderModule mod_banners (facebook)

**Time**: 0.10 ms / 435.07 ms **Memory**: 0.000 MB / 22.53 MB Application: beforeRenderModule mod_banners (lpse grobogan)

**Time**: 86.17 ms / 521.24 ms **Memory**: 0.068 MB / 22.60 MB Application: afterRenderModule mod_banners (lpse grobogan)

**Time**: 0.08 ms / 521.32 ms **Memory**: 0.000 MB / 22.59 MB Application: beforeRenderModule mod_banners (data center)

**Time**: 59.22 ms / 580.53 ms **Memory**: 0.068 MB / 22.66 MB Application: afterRenderModule mod_banners (data center)

**Time**: 0.09 ms / 580.62 ms **Memory**: 0.000 MB / 22.65 MB Application: beforeRenderModule mod_banners (instagram)

**Time**: 17.92 ms / 598.54 ms **Memory**: 0.068 MB / 22.72 MB Application: afterRenderModule mod_banners (instagram)

**Time**: 0.09 ms / 598.63 ms **Memory**: 0.000 MB / 22.71 MB Application: beforeRenderModule mod_banners (ePetani)

**Time**: 19.33 ms / 617.96 ms **Memory**: 0.071 MB / 22.78 MB Application: afterRenderModule mod_banners (ePetani)

**Time**: 0.14 ms / 618.10 ms **Memory**: 0.000 MB / 22.77 MB Application: beforeRenderModule mod_customtwitterdisplay (Twitter Dispetan)

**Time**: 326.71 ms / 944.81 ms **Memory**: 0.132 MB / 22.90 MB Application: afterRenderModule mod_customtwitterdisplay (Twitter Dispetan)

**Time**: 0.18 ms / 944.99 ms **Memory**: 0.000 MB / 22.82 MB Application: beforeRenderModule mod_menu (Main Menu)

**Time**: 23.17 ms / 968.16 ms **Memory**: 1.022 MB / 23.84 MB Application: afterRenderModule mod_menu (Main Menu)

**Time**: 0.08 ms / 968.24 ms **Memory**: 0.000 MB / 23.83 MB Application: beforeRenderModule mod_search (Search)

**Time**: 2.40 ms / 970.64 ms **Memory**: 0.043 MB / 23.87 MB Application: afterRenderModule mod_search (Search)

**Time**: 11.41 ms / 982.05 ms **Memory**: 0.207 MB / 24.08 MB Application: afterRender

**Database queries total: 328.77 ms**

Memory Usage

Database Queries

154 Queries Logged 328.77 ms

42 duplicate found!

**5 duplicates**: #68 #70 #71 #72 #73

**4 duplicates**: #74 #76 #77 #78

**5 duplicates**: #79 #81 #82 #83 #84

**5 duplicates**: #85 #87 #88 #89 #90

**5 duplicates**: #91 #93 #94 #95 #96

**5 duplicates**: #97 #99 #100 #101 #102

**9 duplicates**: #103 #106 #109 #112 #115 #118 #121 #124 #127

**4 duplicates**: #135 #136 #137 #138

**Query Time: 0.27 ms**

SELECT `data`

  FROM `ni2ek_session`

  WHERE `session_id` = 'nt2irli9bqpsl9hbkjhvtbfvk1'

**Explain**

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

**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:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.20 ms** **After last query: 2.19 ms**

SELECT `session_id`

  FROM `ni2ek_session`

  WHERE `session_id` = 'nt2irli9bqpsl9hbkjhvtbfvk1' 
  LIMIT 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_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
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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: 26.26 ms** **After last query: 0.24 ms**

INSERT INTO `ni2ek_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('nt2irli9bqpsl9hbkjhvtbfvk1', 1, '1558691101', 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `ni2ek_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('nt2irli9bqpsl9hbkjhvtbfvk1', 1, '1558691101', 0, '', 0)**

**Profile**

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

**Call Stack**

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.49 ms** **After last query: 4.27 ms**

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

  FROM `ni2ek_extensions`

  WHERE `type` = 'component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_extensions	ref	extension	extension	82	const	39	100.00	Using index condition

**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:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
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:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
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: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:195
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: 3.79 ms**

SELECT id, rules

  FROM `ni2ek_viewlevels`

**Explain**

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

**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: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: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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.40 ms** **After last query: 0.25 ms**

SELECT b.id

  FROM ni2ek_usergroups AS a

  LEFT JOIN ni2ek_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	NULL
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: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: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:195
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: 1.02 ms**

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

  FROM ni2ek_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	ni2ek_extensions	ref	extension	extension	82	const	107	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: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: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:195
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.68 ms** **After last query: 47.94 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 ni2ek_menu AS m

  LEFT JOIN ni2ek_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	42	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.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:374
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:488
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:1070
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.40 ms** **After last query: 13.29 ms**

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

  FROM `ni2ek_extensions`

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_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/jcomments/jcomments.php:111
9	plgSystemJComments->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:1080
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:195
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: 10.07 ms** **After last query: 0.36 ms**

UPDATE `ni2ek_extensions`

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,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
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/jcomments/jcomments.php:111
9	plgSystemJComments->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:1080
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:195
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.71 ms** **After last query: 3.59 ms**

SELECT *

  FROM `ni2ek_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_jcomments_settings	ref	PRIMARY	PRIMARY	214	const,const	91	100.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
15	JCommentsCfg::_load()	*Same as call in the line below.*
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
12	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
11	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
10	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
9	plgSystemJComments->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:1080
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.31 ms** **After last query: 0.75 ms**

SELECT id, home, template, s.params

  FROM ni2ek_template_styles as s

  LEFT JOIN ni2ek_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	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	dinperta_hortik.s.template,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
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_jcomments/helpers/system.php:46
10	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
9	plgSystemJComments->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:1080
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:195
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.73 ms**

SELECT manifest_cache

  FROM ni2ek_extensions

  WHERE element LIKE 'jsn_epic_pro'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	3	100.00	Using index condition

**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/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
13	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
12	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
11	jsn_template_framework_class_loader()	*Same as call in the line below.*
10	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
9	PlgSystemJSNTPLFramework->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:1080
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:195
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.39 ms** **After last query: 7.51 ms**

SELECT COUNT(*)

  FROM ni2ek_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_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
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166
11	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
10	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
9	PlgSystemJSNTPLFramework->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:1080
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:195
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: 0.77 ms**

SELECT *

  FROM ni2ek_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	ni2ek_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	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:195
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.45 ms** **After last query: 12.45 ms**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ni2ek_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easybookreloaded','com_fields','com_finder','com_imageshow','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_phocaguestbook','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	340	11.76	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.70 ms**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ni2ek_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	340	100.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.99 ms** **After last query: 4.72 ms**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)

  FROM `ni2ek_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `ni2ek_categories` AS `s`

  INNER JOIN `ni2ek_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 44

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	44	68.18	Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	dinperta_hortik.c.id	3	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
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.84 ms** **After last query: 3.27 ms**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM ni2ek_content AS a

  LEFT JOIN ni2ek_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ni2ek_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ni2ek_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ni2ek_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state IN (0,1,2) 
  AND a.catid = 44

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 8

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.76 ms** **After last query: 2.12 ms**

SELECT `m`.`tag_id`,`t`.*

  FROM `ni2ek_contentitem_tag_map` AS m 

  INNER JOIN `ni2ek_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 206 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dinperta_hortik.m.tag_id	1	100.00	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.29 ms** **After last query: 1.29 ms**

SELECT COUNT(*)

  FROM ni2ek_content AS a

  LEFT JOIN ni2ek_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ni2ek_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ni2ek_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ni2ek_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state IN (0,1,2) 
  AND a.catid = 44

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	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
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.33 ms**

SELECT `m`.`tag_id`,`t`.*

  FROM `ni2ek_contentitem_tag_map` AS m 

  INNER JOIN `ni2ek_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 44 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dinperta_hortik.m.tag_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
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 18.42 ms**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `ni2ek_categories` AS `s`

  INNER JOIN `ni2ek_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 44

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	44	72.73	Using where

**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/Categories/Categories.php:312
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	*Same as call in the line below.*
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.82 ms** **After last query: 0.29 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, g.note as group_note

  FROM ni2ek_fields AS a

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

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

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

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

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

  LEFT JOIN `ni2ek_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (44,0)) 
  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	dinperta_hortik.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	dinperta_hortik.a.id	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
20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	*Same as call in the line below.*
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.34 ms** **After last query: 4.52 ms**

SELECT `name`, `value`

  FROM `ni2ek_jsn_imageshow_config`

  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_jsn_imageshow_config	ALL	name	NO INDEX KEY COULD BE USED	NULL	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
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
17	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
16	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
15	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
14	plgContentImageShow->onContentPrepare()	*Same as call in the line below.*
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 3.87 ms**

SELECT *

  FROM ni2ek_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ni2ek_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
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
15	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
14	plgContentImageShow->onContentPrepare()	*Same as call in the line below.*
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.09 ms** **After last query: 31.01 ms**

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

  FROM ni2ek_modules AS m

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

  LEFT JOIN ni2ek_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-05-24 09:45:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-05-24 09:45:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 200 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	31	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	dinperta_hortik.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	dinperta_hortik.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
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
13	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
12	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
11	JModuleHelper::getModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:168
10	JSNTplUtils->countModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:498
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.33 ms** **After last query: 2.31 ms**

SELECT m.id

  FROM ni2ek_modules AS m

  INNER JOIN ni2ek_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -200) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mm	index	PRIMARY	PRIMARY	8	NULL	48	75.00	Using where; Using index
1	SIMPLE	m	eq_ref	PRIMARY,published,newsfeeds	PRIMARY	4	dinperta_hortik.mm.moduleid	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/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_epic_pro/template_custom.php:23
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.34 ms** **After last query: 0.14 ms**

SELECT m.id

  FROM ni2ek_modules AS m

  INNER JOIN ni2ek_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid = 200 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -200)) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	41	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	dinperta_hortik.m.id	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:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_epic_pro/template_custom.php:23
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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: 0.18 ms**

SELECT m.id

  FROM ni2ek_modules AS m

  INNER JOIN ni2ek_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_virtuemart_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -200) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mm	index	PRIMARY	PRIMARY	8	NULL	48	75.00	Using where; Using index
1	SIMPLE	m	eq_ref	PRIMARY,published,newsfeeds	PRIMARY	4	dinperta_hortik.mm.moduleid	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/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:770
12	JSNTplUtils->checkVM()	JROOT/templates/jsn_epic_pro/template_custom.php:28
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.31 ms** **After last query: 0.13 ms**

SELECT m.id

  FROM ni2ek_modules AS m

  INNER JOIN ni2ek_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_virtuemart_%' 
  AND (mm.menuid = 200 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -200)) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	41	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	dinperta_hortik.m.id	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:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:770
12	JSNTplUtils->checkVM()	JROOT/templates/jsn_epic_pro/template_custom.php:28
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.45 ms** **After last query: 12.20 ms**

SHOW TABLES LIKE '%_content_multicats'

**Explain**

**EXPLAIN not possible on query: SHOW TABLES LIKE '%_content_multicats'**

**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/database.php:33
17	JDatabase->query()	JROOT/modules/mod_cwnews/classes/source.content.php:441
16	CW_Content_Source->tableExists()	JROOT/modules/mod_cwnews/classes/source.content.php:73
15	CW_Content_Source->getList()	*Same as call in the line below.*
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_cwnews/helper.php:58
11	modCWNewsHelper::getList()	JROOT/modules/mod_cwnews/mod_cwnews.php:28
10	include JROOT/modules/mod_cwnews/mod_cwnews.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.29 ms** **After last query: 0.80 ms**