International Journal of Social Science and Business

ISSN: 2519-9161(Online), ISSN: 2519-9153(Print)

Vol. 2 No. 4, August 2017

Table of Contents

Articles

Admission Variables Predicting Student Success in a Master of Social Work Program

Steven L. Smith, Ph.D., LMSW

View

Download

Impact of implementing Uniform Accounting Standards on Equity Investments

Symon Manyara

View

Download

Turmoil in the Shipping Industry: Implications for Today’s Global Supply Chains

Prashanth N. Bharadwaj, Siddhanth Sargur Prasad

View

Download

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1779653912,
                "last": 1779653912,
                "now": 1779653912
            },
            "token": "gPTkjcLNALkDIa2CaG9q2q852neo8hpD"
        },
        "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**: 5.49 ms / 5.49 ms **Memory**: 1.384 MB / 1.73 MB Application: afterLoad

**Time**: 31.13 ms / 36.62 ms **Memory**: 3.943 MB / 5.68 MB Application: afterInitialise

**Time**: 6.04 ms / 42.66 ms **Memory**: 0.871 MB / 6.55 MB Application: afterRoute

**Time**: 1.07 ms / 43.72 ms **Memory**: 0.100 MB / 6.65 MB Application: beforeRenderComponent com_content

**Time**: 1.99 ms / 45.71 ms **Memory**: 0.361 MB / 7.01 MB Application: Before Access::preloadComponents (all components)

**Time**: 0.41 ms / 46.12 ms **Memory**: 0.055 MB / 7.06 MB Application: After Access::preloadComponents (all components)

**Time**: 0.02 ms / 46.14 ms **Memory**: 0.000 MB / 7.06 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Time**: 0.25 ms / 46.39 ms **Memory**: 0.026 MB / 7.08 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Time**: 12.82 ms / 59.21 ms **Memory**: 1.823 MB / 8.91 MB Application: afterRenderComponent com_content

**Time**: 1.46 ms / 60.67 ms **Memory**: 0.294 MB / 9.20 MB Application: afterDispatch

**Time**: 4.22 ms / 64.89 ms **Memory**: 0.425 MB / 9.63 MB Application: beforeRenderModule mod_finder (Search)

**Time**: 3.69 ms / 68.58 ms **Memory**: 0.436 MB / 10.06 MB Application: afterRenderModule mod_finder (Search)

**Time**: 0.02 ms / 68.60 ms **Memory**: 0.000 MB / 10.06 MB Application: beforeRenderModule mod_custom (Submit Paper)

**Time**: 0.20 ms / 68.80 ms **Memory**: 0.006 MB / 10.07 MB Application: afterRenderModule mod_custom (Submit Paper)

**Time**: 0.01 ms / 68.82 ms **Memory**: 0.000 MB / 10.06 MB Application: beforeRenderModule mod_custom (Journal Cover)

**Time**: 0.10 ms / 68.92 ms **Memory**: 0.003 MB / 10.07 MB Application: afterRenderModule mod_custom (Journal Cover)

**Time**: 0.01 ms / 68.93 ms **Memory**: 0.000 MB / 10.07 MB Application: beforeRenderModule mod_custom (Open Access)

**Time**: 0.07 ms / 69.01 ms **Memory**: 0.004 MB / 10.07 MB Application: afterRenderModule mod_custom (Open Access)

**Time**: 0.01 ms / 69.02 ms **Memory**: 0.000 MB / 10.07 MB Application: beforeRenderModule mod_custom (Plagiarstm)

**Time**: 0.07 ms / 69.09 ms **Memory**: 0.003 MB / 10.07 MB Application: afterRenderModule mod_custom (Plagiarstm)

**Time**: 0.05 ms / 69.13 ms **Memory**: 0.002 MB / 10.07 MB Application: beforeRenderModule mod_menu (Side Menu)

**Time**: 1.22 ms / 70.35 ms **Memory**: 0.093 MB / 10.17 MB Application: afterRenderModule mod_menu (Side Menu)

**Time**: 0.02 ms / 70.36 ms **Memory**: 0.000 MB / 10.16 MB Application: beforeRenderModule mod_custom (Call for Paper)

**Time**: 0.09 ms / 70.46 ms **Memory**: 0.003 MB / 10.16 MB Application: afterRenderModule mod_custom (Call for Paper)

**Time**: 0.01 ms / 70.47 ms **Memory**: 0.000 MB / 10.16 MB Application: beforeRenderModule mod_custom (Join as Reviewer)

**Time**: 0.07 ms / 70.54 ms **Memory**: 0.003 MB / 10.17 MB Application: afterRenderModule mod_custom (Join as Reviewer)

**Time**: 0.03 ms / 70.57 ms **Memory**: 0.002 MB / 10.17 MB Application: beforeRenderModule mod_menu (Main Menu)

**Time**: 0.79 ms / 71.37 ms **Memory**: 0.064 MB / 10.23 MB Application: afterRenderModule mod_menu (Main Menu)

**Time**: 2.07 ms / 73.44 ms **Memory**: 0.158 MB / 10.39 MB Application: afterRender

**Database queries total: 12.38 ms**

Memory Usage

Database Queries

37 Queries Logged 12.38 ms

4 duplicate found!

**2 duplicates**: #27 #30

**2 duplicates**: #29 #32

**Query Time: 0.53 ms** **Query memory: 0.027 MB Memory before query: 3.312 MB** **Rows returned: 0**

SELECT `data`

  FROM `josvn_session`

  WHERE `session_id` = 'a5rih11hh39nv7bnnreo514421'

**Explain**

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

**Profile**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.29 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->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:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
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.18 ms** **After last query: 0.49 ms** **Query memory: 0.023 MB Memory before query: 3.401 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `josvn_session`

  WHERE `session_id` = 'a5rih11hh39nv7bnnreo514421' 
  LIMIT 1

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:214
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
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.76 ms** **After last query: 0.04 ms** **Query memory: 0.005 MB Memory before query: 3.408 MB**

INSERT INTO `josvn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a5rih11hh39nv7bnnreo514421', 1, '1779653912', 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `josvn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a5rih11hh39nv7bnnreo514421', 1, '1779653912', 0, '', 0)**

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.04 ms
table lock	0.00 ms
init for update	0.02 ms
Update	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.33 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.02 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:254
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
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.30 ms** **After last query: 1.10 ms** **Query memory: 0.033 MB Memory before query: 3.614 MB** **Rows returned: 34**

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

  FROM `josvn_extensions`

  WHERE `type` = 'component'

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->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:303
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.87 ms** **Query memory: 0.025 MB Memory before query: 3.812 MB** **Rows returned: 5**

SELECT id, rules

  FROM `josvn_viewlevels`

**Explain**

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

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

**Call Stack**

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

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

**Query Time: 0.23 ms** **After last query: 0.04 ms** **Query memory: 0.025 MB Memory before query: 3.827 MB** **Rows returned: 2**

SELECT b.id

  FROM josvn_usergroups AS a

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

  WHERE a.id = 9

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
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: 0.27 ms** **Query memory: 0.042 MB Memory before query: 3.954 MB** **Rows returned: 74**

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

  FROM josvn_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	josvn_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	178	48.88	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.44 ms** **After last query: 6.55 ms** **Query memory: 0.030 MB Memory before query: 5.086 MB** **Rows returned: 78**

SHOW TABLES

**Explain**

**EXPLAIN not possible on query: SHOW TABLES**

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
checking permissions	0.18 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.21 ms** **After last query: 0.05 ms** **Query memory: 0.025 MB Memory before query: 5.108 MB** **Rows returned: 2**

SELECT name,value

  FROM josvn_jsn_poweradmin_config

  WHERE 1

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
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: 0.52 ms** **Query memory: 0.024 MB Memory before query: 5.157 MB** **Rows returned: 1**

SELECT COUNT(*)

  FROM josvn_extensions

  WHERE element="jsnadminbar"

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josvn_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using where; Using index

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:910
8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:105
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
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: 5.06 ms** **Query memory: 0.043 MB Memory before query: 5.855 MB** **Rows returned: 17**

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

  LEFT JOIN josvn_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	46	36.96	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ijssb_joom102.m.component_id	1	100.00	Using where

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->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:482
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:587
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:1169
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:303
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: 2.54 ms** **Query memory: 0.030 MB Memory before query: 6.372 MB** **Rows returned: 1**

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

  FROM `josvn_extensions`

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josvn_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

**Profile**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.30 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
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/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->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:1179
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:303
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: 0.09 ms** **Query memory: 0.009 MB Memory before query: 6.368 MB**

UPDATE `josvn_extensions`

  SET `params` = '{\"mediaversion\":\"88e3e9d4c35d9ce9de339134f24d0232\"}'

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josvn_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
checking permissions	0.00 ms
After opening tables	0.01 ms
init for update	0.00 ms
init	0.01 ms
Updating main table	0.01 ms
init	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.00 ms
init for update	0.03 ms
Updating	0.02 ms
End of update loop	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**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/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->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:1179
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.32 ms** **After last query: 1.04 ms** **Query memory: 0.026 MB Memory before query: 6.625 MB** **Rows returned: 1**

SELECT *

  FROM josvn_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	josvn_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
7	JDatabaseDriverMysqli->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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.36 ms** **After last query: 0.13 ms** **Query memory: 0.022 MB Memory before query: 6.640 MB** **Rows returned: 1**

SELECT id, home, template, s.params

  FROM josvn_template_styles as s

  LEFT JOIN josvn_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	2	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	ijssb_joom102.e.element	1	100.00	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.04 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.32 ms** **After last query: 2.21 ms** **Query memory: 0.034 MB Memory before query: 7.011 MB** **Rows returned: 34**

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

  FROM `josvn_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_fields','com_finder','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_poweradmin','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	josvn_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	117	29.91	Using where

**Profile**

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.63 ms** **After last query: 0.62 ms** **Query memory: 0.040 MB Memory before query: 7.127 MB** **Rows returned: 30**

SHOW FULL COLUMNS 
  FROM `josvn_content`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josvn_content`**

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.07 ms
closing tables	0.01 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:303
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.46 ms** **After last query: 1.39 ms** **Query memory: 0.045 MB Memory before query: 7.376 MB** **Rows returned: 1**

SELECT *

  FROM josvn_content

  WHERE `id` = '2'

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.22 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:303
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.43 ms** **After last query: 0.08 ms** **Query memory: 0.007 MB Memory before query: 7.401 MB**

UPDATE josvn_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
checking permissions	0.00 ms
After opening tables	0.01 ms
init for update	0.00 ms
init	0.01 ms
Updating main table	0.01 ms
init	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
init for update	0.02 ms
Updating	0.04 ms
End of update loop	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.19 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:303
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.71 ms** **Query memory: 0.039 MB Memory before query: 7.589 MB** **Rows returned: 1**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM josvn_content AS a

  INNER JOIN josvn_categories AS c 
  on c.id = a.catid

  LEFT JOIN josvn_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN josvn_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 2 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-24 20:18:32') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-24 20:18:32') 
  AND (a.state = 1 OR a.state =2)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	1	100.00	Unique row not found

**Profile**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->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:303
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.51 ms** **After last query: 1.19 ms** **Query memory: 0.043 MB Memory before query: 7.753 MB** **Rows returned: 2**

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 `josvn_categories` AS `s`

  INNER JOIN `josvn_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 = 9

  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
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	8	70.00	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
19	ContentRouter->getCategorySegment()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
17	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
16	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
15	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
14	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.26 ms** **After last query: 0.37 ms** **Query memory: 0.037 MB Memory before query: 7.805 MB** **Rows returned: 0**

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

  FROM `josvn_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  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	t	range	PRIMARY,tag_idx,idx_access	tag_idx	5	NULL	1	100.00	Using index condition
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	ijssb_joom102.t.id	1	100.00	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.41 ms** **After last query: 2.43 ms** **Query memory: 0.041 MB Memory before query: 8.247 MB** **Rows returned: 0**

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

  FROM josvn_fields AS a

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

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

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

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

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

  LEFT JOIN `josvn_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 (9,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	ijssb_joom102.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ijssb_joom102.a.checked_out	1	100.00
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ijssb_joom102.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ijssb_joom102.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ijssb_joom102.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ijssb_joom102.a.id	1	100.00	Using where

**Profile**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
13	PlgSystemFields->onContentPrepare()	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/article/view.html.php:193
10	ContentViewArticle->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:303
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.51 ms** **After last query: 6.17 ms** **Query memory: 0.031 MB Memory before query: 9.493 MB** **Rows returned: 11**

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

  FROM josvn_modules AS m

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

  LEFT JOIN josvn_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 <= '2026-05-24 20:18:32') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-24 20:18:32') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 111 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	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	27	48.15	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	ijssb_joom102.m.id	1	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	ijssb_joom102.m.module,const	1	100.00	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	*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/Helper/ModuleHelper.php:433
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/final/library/Artx/Page.php:43
8	ArtxPage->containsModules()	JROOT/templates/final/index.php:81
7	require JROOT/templates/final/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:1126
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.20 ms** **After last query: 0.50 ms** **Query memory: 0.024 MB Memory before query: 9.546 MB** **Rows returned: 0**

SELECT assets, legacy

  FROM josvn_jsn_poweradmin_menu_assets

  WHERE type='css' 
  AND menuId='111'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
8	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:209
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
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.13 ms** **After last query: 0.03 ms** **Query memory: 0.024 MB Memory before query: 9.553 MB** **Rows returned: 0**

SELECT assets, legacy

  FROM josvn_jsn_poweradmin_menu_assets

  WHERE type='js' 
  AND menuId='111'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
8	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:210
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.17 ms** **After last query: 0.02 ms** **Query memory: 0.025 MB Memory before query: 9.560 MB** **Rows returned: 1**

**Duplicate queries**: #30

SELECT parent_id

  FROM josvn_menu

  WHERE id='111'

**Explain**

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

**Profile**

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
9	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.14 ms** **After last query: 0.02 ms** **Query memory: 0.025 MB Memory before query: 9.567 MB** **Rows returned: 0**

SELECT assets, legacy

  FROM josvn_jsn_poweradmin_menu_assets

  WHERE type='css' 
  AND menuId='1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.14 ms** **After last query: 0.02 ms** **Query memory: 0.025 MB Memory before query: 9.574 MB** **Rows returned: 1**

**Duplicate queries**: #32

SELECT parent_id

  FROM josvn_menu

  WHERE id='1'

**Explain**

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

**Profile**

Status	Duration
Starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
10	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
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.15 ms** **After last query: 0.03 ms** **Query memory: 0.025 MB Memory before query: 9.582 MB** **Rows returned: 1**

**Duplicate queries**: #27

SELECT parent_id

  FROM josvn_menu

  WHERE id='111'

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
9	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
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.13 ms** **After last query: 0.02 ms** **Query memory: 0.025 MB Memory before query: 9.589 MB** **Rows returned: 0**

SELECT assets, legacy

  FROM josvn_jsn_poweradmin_menu_assets

  WHERE type='js' 
  AND menuId='1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
Starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
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.15 ms** **After last query: 0.03 ms** **Query memory: 0.025 MB Memory before query: 9.596 MB** **Rows returned: 1**

**Duplicate queries**: #29

SELECT parent_id

  FROM josvn_menu

  WHERE id='1'

**Explain**

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

**Profile**

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
10	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
7	plgSystemJsnpoweradmin->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1130
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:309
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.47 ms** **After last query: 1.02 ms** **Query memory: 0.028 MB Memory before query: 9.712 MB** **Rows returned: 5**

SELECT `name`,`element`

  FROM `josvn_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  AND `enabled` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josvn_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	178	48.88	Using where

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
11	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php: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:1140
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:309
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: 1.67 ms** **Query memory: 0.028 MB Memory before query: 9.958 MB** **Rows returned: 6**

SELECT `title`

  FROM `josvn_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	josvn_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	6	94.74	Using where

**Profile**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
14	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
13	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php: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:1140
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.29 ms** **After last query: 4.29 ms** **Query memory: 0.029 MB Memory before query: 10.327 MB** **Rows returned: 1**

SELECT `alias`

  FROM `josvn_content`

  WHERE id = '26'

**Explain**

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

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
16	ContentRouter->getArticleSegment()	*Same as call in the line below.*
15	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
14	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
13	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
12	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
11	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.19 ms** **After last query: 0.11 ms** **Query memory: 0.029 MB Memory before query: 10.359 MB** **Rows returned: 1**

SELECT `alias`

  FROM `josvn_content`

  WHERE id = '12'

**Explain**

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

**Profile**

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
16	ContentRouter->getArticleSegment()	*Same as call in the line below.*
15	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
14	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
13	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
12	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
11	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
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:309
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.17 ms** **After last query: 0.04 ms** **Query memory: 0.027 MB Memory before query: 10.370 MB** **Rows returned: 1**

SELECT alias

  FROM josvn_content

  WHERE id=12

**Explain**

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

**Profile**

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
14	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
13	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
10	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
9	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
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:309
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.**]

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**4 × SELECT parent_id 
  FROM josvn_menu**

**4 × SELECT assets, legacy 
  FROM josvn_jsn_poweradmin_menu_assets**

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

**2 × SELECT `alias` 
  FROM `josvn_content`**

**1 × SELECT `data` 
  FROM `josvn_session`**

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM josvn_content AS a 
  INNER JOIN josvn_categories AS c 
  on c.id = a.catid 
  LEFT JOIN josvn_users AS u 
  on u.id = a.created_by 
  LEFT JOIN josvn_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN josvn_content_rating AS v 
  ON a.id = v.content_id**

**1 × SELECT `title` 
  FROM `josvn_finder_taxonomy`**

**1 × SELECT `name`,`element` 
  FROM `josvn_extensions`**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM josvn_modules AS m 
  LEFT JOIN josvn_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN josvn_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM josvn_fields AS a 
  LEFT JOIN `josvn_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN josvn_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN josvn_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN josvn_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN josvn_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `josvn_fields_categories` AS fc 
  ON fc.field_id = a.id**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `josvn_contentitem_tag_map` AS m  
  INNER JOIN `josvn_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**1 × 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 `josvn_categories` AS `s` 
  INNER JOIN `josvn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)**

**1 × SELECT * 
  FROM josvn_content**

**1 × SELECT `session_id` 
  FROM `josvn_session`**

**1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `josvn_assets`**

**1 × SELECT id, home, template, s.params 
  FROM josvn_template_styles as s 
  LEFT JOIN josvn_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT * 
  FROM josvn_languages**

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

**1 × SELECT COUNT(*) 
  FROM josvn_extensions**

**1 × SELECT name,value 
  FROM josvn_jsn_poweradmin_config**

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

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

**1 × SELECT id, rules 
  FROM `josvn_viewlevels**

**1 × SELECT alias 
  FROM josvn_content**

OTHER Tables:

**1 × INSERT INTO `josvn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a5rih11hh39nv7bnnreo514421', 1, '1779653912', 0, '', 0**

```
**1 × SHOW TABLE**
```

**1 × UPDATE `josvn_extensions` 
  SET `params` = '{\"mediaversion\":\"88e3e9d4c35d9ce9de339134f24d0232\"}'**

**1 × SHOW FULL COLUMNS 
  FROM `josvn_content**

**1 × UPDATE josvn_content 
  SET `hits` = (`hits` + 1)**

International Journal of Social Science and Business

ISSN: 2519-9161(Online), ISSN: 2519-9153(Print)

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

37 Queries Logged 12.38 ms

4 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**37 Queries Logged** 12.38 ms

**4 duplicate found!**

**29 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

37 Queries Logged 12.38 ms

4 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings