Printed Circuit Design & Fab Online Magazine - Pulsonix 14.0 Advances Design with Embedded Simulation, Smarter 3D Views & Enhanced Workflow Tools

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1764091623,
                "last": 1764091623,
                "now": 1764091623
            },
            "token": "CdNnZyplf42PvfFjQqnvimlhgqjGpHIG"
        },
        "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: 7.61 ms / 7.61 ms Memory: 0.879 MB / 1.08 MB Application: afterLoad

Time: 194.73 ms / 202.33 ms Memory: 2.336 MB / 3.42 MB Application: afterInitialise

Time: 94.18 ms / 296.51 ms Memory: 1.621 MB / 5.04 MB Application: afterRoute

Time: 2.80 ms / 299.31 ms Memory: 0.047 MB / 5.09 MB Application: beforeRenderComponent com_content

Time: 4.91 ms / 304.22 ms Memory: 0.182 MB / 5.27 MB Application: Before Access::preloadComponents (all components)

Time: 3.65 ms / 307.87 ms Memory: 0.110 MB / 5.38 MB Application: After Access::preloadComponents (all components)

Time: 0.13 ms / 308.00 ms Memory: -0.006 MB / 5.37 MB Application: Before Access::preloadPermissions (com_content)

Time: 493.38 ms / 801.37 ms Memory: 31.330 MB / 36.70 MB Application: After Access::preloadPermissions (com_content)

Time: 30.77 ms / 832.15 ms Memory: -1.862 MB / 34.84 MB Application: Before Access::getAssetRules (id:28575 name:com_content.article.18938)

Time: 1.07 ms / 833.22 ms Memory: 0.023 MB / 34.86 MB Application: After Access::getAssetRules (id:28575 name:com_content.article.18938)

Time: 707.11 ms / 1540.33 ms Memory: 1.407 MB / 36.27 MB Application: afterRenderComponent com_content

Time: 8.26 ms / 1548.59 ms Memory: 0.022 MB / 36.29 MB Application: afterDispatch

Time: 24.55 ms / 1573.14 ms Memory: 0.380 MB / 36.67 MB Application: beforeRenderModule mod_menu (PCDandF Site Footer Menu)

Time: 8.71 ms / 1581.85 ms Memory: 0.112 MB / 36.79 MB Application: afterRenderModule mod_menu (PCDandF Site Footer Menu)

Time: 1.40 ms / 1583.25 ms Memory: -0.009 MB / 36.78 MB Application: beforeRenderModule mod_menu (PCDND Site Menu)

Time: 42.90 ms / 1626.15 ms Memory: 0.921 MB / 37.70 MB Application: afterRenderModule mod_menu (PCDND Site Menu)

Time: 2.48 ms / 1628.63 ms Memory: -0.015 MB / 37.68 MB Application: beforeRenderModule mod_imageshow (JSN imageshow Module)

Time: 29.10 ms / 1657.73 ms Memory: 0.846 MB / 38.53 MB Application: afterRenderModule mod_imageshow (JSN imageshow Module)

Time: 35.83 ms / 1693.56 ms Memory: 0.161 MB / 38.69 MB Application: afterRender

Database queries total: 749.29 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_session	const	PRIMARY	PRIMARY	194	const	1	Using index

EXPLAIN not possible on query: INSERT INTO `upm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'686e75766e64666a6937383468766138366b346a6766326a7131', 1, 1764091623, 0, '', 0)

Profile

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

Call Stack

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

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

Query Time: 1.14 ms After last query: 2.66 ms Query memory: 0.015 MB Memory before query: 1.885 MB Rows returned: 3

SELECT id, rules

  FROM `upm_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.75 ms After last query: 0.24 ms Query memory: 0.015 MB Memory before query: 1.908 MB Rows returned: 1

SELECT b.id

  FROM upm_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.60 ms After last query: 5.87 ms Query memory: 0.018 MB Memory before query: 2.562 MB Rows returned: 180

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
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:280
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:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.78 ms After last query: 0.37 ms Query memory: 0.015 MB Memory before query: 2.611 MB Rows returned: 2

SELECT name,value

  FROM upm_jsn_poweradmin_config

  WHERE 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:280
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:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 1.14 ms Query memory: 0.014 MB Memory before query: 2.621 MB Rows returned: 1

SELECT COUNT(*)

  FROM upm_extensions

  WHERE element="jsnadminbar"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:280
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:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.83 ms After last query: 3.25 ms Query memory: 0.013 MB Memory before query: 2.867 MB Rows returned: 1

SELECT `enabled`

  FROM `upm_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.33 ms After last query: 116.50 ms Query memory: 0.023 MB Memory before query: 4.474 MB Rows returned: 1

SELECT `extension_id`,`name`,`enabled`,`params`

  FROM upm_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:152
14	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:122
13	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51
12	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:38
11	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:148
10	Alledia\Framework\Joomla\Extension\Helper::getExtensionForElement()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:109
9	Alledia\Framework\Joomla\Extension\Helper::loadLibrary()	JROOT/administrator/components/com_osdownloads/include.php:54
8	require_once JROOT/administrator/components/com_osdownloads/include.php	JROOT/components/com_osdownloads/router.php:30
7	require_once JROOT/components/com_osdownloads/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.30 ms After last query: 9.22 ms Query memory: 0.025 MB Memory before query: 4.668 MB Rows returned: 0

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

  INNER JOIN `upm_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) 
  AND c.published = 1 
  AND s.id = 18938

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.75 ms After last query: 0.39 ms Query memory: 0.017 MB Memory before query: 4.684 MB Rows returned: 1

SELECT `alias`,`catid`

  FROM `upm_content`

  WHERE `id` = 18938

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_content	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.66 ms After last query: 1.73 ms Query memory: 0.018 MB Memory before query: 4.711 MB

UPDATE `upm_extensions`

  SET `params` = '{\"mediaversion\":\"6ce3a1cb6159b4bdf688daafce2cffd7\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `upm_extensions` SET `params` = '{\"mediaversion\":\"6ce3a1cb6159b4bdf688daafce2cffd7\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.13 ms
Updating	0.15 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.93 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/betterpreview/betterpreview.php:32
9	PlgSystemBetterPreview->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 57.83 ms Query memory: 0.019 MB Memory before query: 5.016 MB Rows returned: 1

SELECT manifest_cache

  FROM upm_extensions

  WHERE element LIKE 'jsn_epic_pro'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	4	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
13	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:198
12	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
11	jsn_template_framework_class_loader()	Same as call in the line below.
10	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:144
9	PlgSystemJSNTPLFramework->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.12 ms After last query: 10.69 ms Query memory: 0.026 MB Memory before query: 5.278 MB Rows returned: 47

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

  FROM `upm_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_coolfeed','com_cpanel','com_dbreplacer','com_fields','com_finder','com_imageshow','com_installer','com_jce','com_jevents','com_jmap','com_joomlaupdate','com_kunena','com_languages','com_lg-userexport','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osdownloads','com_plugins','com_postinstall','com_poweradmin','com_privacy','com_redirect','com_search','com_sl_keywordlinking','com_tags','com_templates','com_uniform','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_assets	range	idx_asset_name	idx_asset_name	202	NULL	49	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 76.73 ms After last query: 1.25 ms Query memory: 0.758 MB Memory before query: 5.375 MB Rows returned: 19230

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

  FROM `upm_assets`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
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:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.26 ms After last query: 448.93 ms Query memory: 0.026 MB Memory before query: 34.888 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `upm_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
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:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.51 ms After last query: 49.46 ms Query memory: 0.014 MB Memory before query: 35.039 MB

UPDATE upm_content

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

  WHERE `id` = '18938'

Explain

EXPLAIN not possible on query: UPDATE upm_content SET `hits` = (`hits` + 1) WHERE `id` = '18938'

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.15 ms
Updating	0.21 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.42 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.76 ms After last query: 3.59 ms Query memory: 0.036 MB Memory before query: 35.145 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 upm_content AS a

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

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

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

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

  WHERE a.id = 18938 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-25 17:27:04') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-25 17:27:04') 
  AND (a.state = 1 OR a.state =2)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 36.77 ms After last query: 3.47 ms Query memory: 0.039 MB Memory before query: 35.252 MB Rows returned: 3

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

  INNER JOIN `upm_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) 
  AND c.published = 1 
  AND s.id = 258

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 92.20 ms After last query: 2.48 ms Query memory: 0.027 MB Memory before query: 35.334 MB Rows returned: 1

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

  FROM `upm_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	9183	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	pcdandf_sitedb.t.id	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.63 ms After last query: 29.52 ms Query memory: 0.035 MB Memory before query: 35.758 MB Rows returned: 0

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

  FROM upm_fields AS a

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

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

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

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

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

  LEFT JOIN `upm_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 (258,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	pcdandf_sitedb.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	pcdandf_sitedb.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pcdandf_sitedb.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	pcdandf_sitedb.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	pcdandf_sitedb.a.id	1	Using where; Using index; Distinct

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 2.19 ms Query memory: 0.027 MB Memory before query: 35.886 MB Rows returned: 0

SELECT `name`, `value`

  FROM `upm_jsn_imageshow_config`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_jsn_imageshow_config	ALL	name	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
18	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
17	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
16	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
15	plgContentImageShow->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.12 ms After last query: 7.49 ms Query memory: 0.028 MB Memory before query: 36.018 MB Rows returned: 1

Duplicate queries: #58

SELECT *

  FROM upm_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
16	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:47
15	plgContentImageShow->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.37 ms After last query: 1.23 ms Query memory: 0.026 MB Memory before query: 36.040 MB Rows returned: 10

SELECT a.keyword, a.keywords, a.link, a.target, a.tooltip

  FROM upm_sl_keywordlinking_keywords AS a

  INNER JOIN upm_categories AS c 
  ON c.id = a.catid

  WHERE a.state = 1 
  AND a.access IN (1,1) 
  AND c.published = 1 
  AND c.access IN (1,1)

  ORDER BY LENGTH(a.keyword) DESC, c.lft, c.rgt, a.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid	NO INDEX KEY COULD BE USED	NULL	NULL	16	Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	pcdandf_sitedb.a.catid	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/sl_keywordlinking/sl_keywordlinking.php:223
17	plgContentSL_KeywordLinking->_getKeywords()	JROOT/plugins/content/sl_keywordlinking/sl_keywordlinking.php:70
16	plgContentSL_KeywordLinking->_processContent()	JROOT/plugins/content/sl_keywordlinking/sl_keywordlinking.php:52
15	plgContentSL_KeywordLinking->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 141.98 ms After last query: 2.89 ms Query memory: 0.025 MB Memory before query: 36.076 MB Rows returned: 1

SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to

  FROM `upm_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 9962

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	contact	ref	idx_state	idx_state	1	const	7	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:125
16	PlgContentContact->getContactData()	JROOT/plugins/content/contact/contact.php:66
15	PlgContentContact->onContentPrepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 222.49 ms After last query: 2.02 ms Query memory: 0.126 MB Memory before query: 36.124 MB Rows returned: 1910

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM upm_content AS a

  LEFT JOIN upm_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 258 
  AND a.state = 1 
  AND a.access IN (1,1)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-11-25 17:27:04') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-11-25 17:27:04')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state,idx_access	4,1,4	NULL	486	Using intersect(idx_catid,idx_state,idx_access); Using where; Using filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
15	PlgContentPagenavigation->onContentBeforeDisplay()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 23.69 ms After last query: 31.24 ms Query memory: 0.025 MB Memory before query: 36.159 MB Rows returned: 1

SELECT raw_stats

  FROM upm_mostpopular

  WHERE content_id = 18938

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_mostpopular	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16485	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/plugins/content/mostpopular/mostpopular.php:134
17	plgContentMostpopular->_getRawStats()	JROOT/plugins/content/mostpopular/mostpopular.php:42
16	plgContentMostpopular->_updateStats()	JROOT/plugins/content/mostpopular/mostpopular.php:31
15	plgContentMostpopular->onContentAfterDisplay()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 32.37 ms After last query: 0.90 ms Query memory: 0.022 MB Memory before query: 36.189 MB

UPDATE upm_mostpopular

  SET 1_day_stats = 2
	, 7_day_stats = 7
	, 30_day_stats = 113
	, all_time_stats = all_time_stats + 1
	, raw_stats = 'a:29:{s:10:\"2025-10-24\";i:7;s:10:\"2025-10-25\";i:15;s:10:\"2025-10-26\";i:6;s:10:\"2025-10-27\";i:7;s:10:\"2025-10-28\";i:7;s:10:\"2025-10-29\";i:12;s:10:\"2025-10-30\";i:9;s:10:\"2025-10-31\";i:12;s:10:\"2025-11-01\";i:6;s:10:\"2025-11-02\";i:8;s:10:\"2025-11-03\";i:7;s:10:\"2025-11-04\";i:5;s:10:\"2025-11-05\";i:6;s:10:\"2025-11-06\";i:4;s:10:\"2025-11-07\";i:1;s:10:\"2025-11-08\";i:2;s:10:\"2025-11-09\";i:2;s:10:\"2025-11-10\";i:2;s:10:\"2025-11-11\";i:3;s:10:\"2025-11-12\";i:2;s:10:\"2025-11-13\";i:1;s:10:\"2025-11-14\";i:1;s:10:\"2025-11-15\";i:5;s:10:\"2025-11-16\";i:1;s:10:\"2025-11-17\";i:2;s:10:\"2025-11-18\";i:1;s:10:\"2025-11-20\";i:1;s:10:\"2025-11-21\";i:4;s:10:\"2025-11-25\";i:1;}'

  WHERE content_id = 18938

Explain

EXPLAIN not possible on query: UPDATE upm_mostpopular SET 1_day_stats = 2 , 7_day_stats = 7 , 30_day_stats = 113 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:29:{s:10:\"2025-10-24\";i:7;s:10:\"2025-10-25\";i:15;s:10:\"2025-10-26\";i:6;s:10:\"2025-10-27\";i:7;s:10:\"2025-10-28\";i:7;s:10:\"2025-10-29\";i:12;s:10:\"2025-10-30\";i:9;s:10:\"2025-10-31\";i:12;s:10:\"2025-11-01\";i:6;s:10:\"2025-11-02\";i:8;s:10:\"2025-11-03\";i:7;s:10:\"2025-11-04\";i:5;s:10:\"2025-11-05\";i:6;s:10:\"2025-11-06\";i:4;s:10:\"2025-11-07\";i:1;s:10:\"2025-11-08\";i:2;s:10:\"2025-11-09\";i:2;s:10:\"2025-11-10\";i:2;s:10:\"2025-11-11\";i:3;s:10:\"2025-11-12\";i:2;s:10:\"2025-11-13\";i:1;s:10:\"2025-11-14\";i:1;s:10:\"2025-11-15\";i:5;s:10:\"2025-11-16\";i:1;s:10:\"2025-11-17\";i:2;s:10:\"2025-11-18\";i:1;s:10:\"2025-11-20\";i:1;s:10:\"2025-11-21\";i:4;s:10:\"2025-11-25\";i:1;}' WHERE content_id = 18938

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/plugins/content/mostpopular/mostpopular.php:84
16	plgContentMostpopular->_updateStats()	JROOT/plugins/content/mostpopular/mostpopular.php:31
15	plgContentMostpopular->onContentAfterDisplay()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.41 ms After last query: 22.70 ms Query memory: 0.024 MB Memory before query: 36.426 MB Rows returned: 18

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

  FROM upm_modules AS m

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

  LEFT JOIN upm_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 <= '2025-11-25 17:27:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-25 17:27:04') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1397 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	309	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	pcdandf_sitedb.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	pcdandf_sitedb.m.id	5	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
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:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:162
8	JSNTplUtils->countModules()	JROOT/templates/jsn_epic_pro/index.php:51
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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: 3.60 ms Query memory: 0.015 MB Memory before query: 36.494 MB Rows returned: 0

SELECT assets, legacy

  FROM upm_jsn_poweradmin_menu_assets

  WHERE type='css' 
  AND menuId='1397'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:209
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.59 ms After last query: 0.37 ms Query memory: 0.015 MB Memory before query: 36.508 MB Rows returned: 0

SELECT assets, legacy

  FROM upm_jsn_poweradmin_menu_assets

  WHERE type='js' 
  AND menuId='1397'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:210
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.37 ms Query memory: 0.016 MB Memory before query: 36.523 MB Rows returned: 1

Duplicate queries: #35

SELECT parent_id

  FROM upm_menu

  WHERE id='1397'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.05 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.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 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.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.34 ms Query memory: 0.017 MB Memory before query: 36.539 MB Rows returned: 0

SELECT assets, legacy

  FROM upm_jsn_poweradmin_menu_assets

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

Explain

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

Profile

Status	Duration
Starting	0.05 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.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
10	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.32 ms Query memory: 0.018 MB Memory before query: 36.555 MB Rows returned: 1

Duplicate queries: #37

SELECT parent_id

  FROM upm_menu

  WHERE id='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	const	PRIMARY	PRIMARY	4	const	1

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.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 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.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
11	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
10	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.32 ms Query memory: 0.016 MB Memory before query: 36.571 MB Rows returned: 1

Duplicate queries: #32

SELECT parent_id

  FROM upm_menu

  WHERE id='1397'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 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.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 36.587 MB Rows returned: 0

SELECT assets, legacy

  FROM upm_jsn_poweradmin_menu_assets

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

Explain

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

Profile

Status	Duration
Starting	0.05 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.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
10	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.30 ms Query memory: 0.018 MB Memory before query: 36.602 MB Rows returned: 1

Duplicate queries: #34

SELECT parent_id

  FROM upm_menu

  WHERE id='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 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.05 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
11	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
10	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
8	plgSystemJsnpoweradmin->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.89 ms After last query: 31.13 ms Query memory: 0.023 MB Memory before query: 37.271 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1312 OR id = 1314

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 1.21 ms Query memory: 0.023 MB Memory before query: 37.293 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1466

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.64 ms Query memory: 0.023 MB Memory before query: 37.315 MB Rows returned: 2

Duplicate queries: #41 #42

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1225

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.59 ms Query memory: 0.023 MB Memory before query: 37.337 MB Rows returned: 2

Duplicate queries: #40 #42

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1225

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 37.359 MB Rows returned: 2

Duplicate queries: #40 #41

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1225

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 37.381 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1228

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 37.403 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1226

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.65 ms After last query: 0.46 ms Query memory: 0.023 MB Memory before query: 37.425 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1443

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.55 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 37.446 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1392

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.41 ms Query memory: 0.023 MB Memory before query: 37.468 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1378

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.59 ms After last query: 0.57 ms Query memory: 0.023 MB Memory before query: 37.490 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1235

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.58 ms Query memory: 0.023 MB Memory before query: 37.512 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1230

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.59 ms After last query: 0.57 ms Query memory: 0.023 MB Memory before query: 37.534 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1223 OR id = 1237

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.89 ms Query memory: 0.023 MB Memory before query: 37.556 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1238 OR id = 1239

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.66 ms Query memory: 0.023 MB Memory before query: 37.578 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1238 OR id = 1467

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.65 ms After last query: 0.58 ms Query memory: 0.023 MB Memory before query: 37.600 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1238 OR id = 1366

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.05 ms
Starting cleanup	0.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.59 ms After last query: 0.56 ms Query memory: 0.023 MB Memory before query: 37.622 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1238 OR id = 1365

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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: 1.32 ms Query memory: 0.023 MB Memory before query: 37.643 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1244 OR id = 1245

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.49 ms After last query: 0.68 ms Query memory: 0.023 MB Memory before query: 37.665 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1244 OR id = 1246

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 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.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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: 0.59 ms Query memory: 0.023 MB Memory before query: 37.687 MB Rows returned: 2

SELECT lft, rgt

  FROM upm_menu

  WHERE id = 1244 OR id = 1427

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_menu	range	PRIMARY	PRIMARY	4	NULL	2	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.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
15	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_epic_pro/html/mod_menu/default.php:79
14	require JROOT/templates/jsn_epic_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:633
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.92 ms After last query: 5.95 ms Query memory: 0.026 MB Memory before query: 37.722 MB Rows returned: 1

Duplicate queries: #23

SELECT *

  FROM upm_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
13	JSNISUtils->getComponentInfo()	JROOT/modules/mod_imageshow/helper.php:24
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.83 ms Query memory: 0.021 MB Memory before query: 37.747 MB Rows returned: 0

SELECT c.introtext, c.fulltext
				   
  FROM upm_imageshow_showlist sl
				   
  INNER JOIN upm_content c 
  ON sl.alter_autid = c.id
				   
  WHERE sl.showlist_id=3

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_show.php:85
13	JSNISShow->getArticleAuth()	JROOT/modules/mod_imageshow/helper.php:42
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.65 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 37.767 MB Rows returned: 1

Duplicate queries: #65 #73

SELECT * 
  FROM upm_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
13	JSNISShowlist->getShowListByID()	JROOT/modules/mod_imageshow/helper.php:43
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.52 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 37.792 MB Rows returned: 1

SELECT * 
  FROM upm_imageshow_showcase 
  WHERE  published = 1 
  AND  showcase_id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_showcase	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 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.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcase.php:155
13	JSNISShowcase->getShowCaseByID()	JROOT/modules/mod_imageshow/helper.php:44
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.55 ms After last query: 0.44 ms Query memory: 0.022 MB Memory before query: 37.825 MB Rows returned: 1

SELECT * 
  FROM upm_imageshow_theme_profile 
  WHERE showcase_id =1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_theme_profile	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 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.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:341
13	JSNISShowcaseTheme->getThemeProfile()	JROOT/modules/mod_imageshow/helper.php:62
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.72 ms After last query: 0.37 ms Query memory: 0.024 MB Memory before query: 37.847 MB Rows returned: 6

Duplicate queries: #72

SELECT
						image_id, image_title,
						image_small, image_big, image_medium,
						image_description, image_link,
						image_extid, album_extid, image_size, custom_data, exif_data
				   
  FROM upm_imageshow_images
				   
  WHERE showlist_id =3
				   
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort

Profile

Status	Duration
Starting	0.07 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.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:46
13	JSNISImages->getImagesByShowlistID()	JROOT/modules/mod_imageshow/helper.php:89
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 0.46 ms Query memory: 0.025 MB Memory before query: 37.885 MB Rows returned: 1

SELECT *
			   
  FROM upm_extensions
			   
  WHERE folder = 'jsnimageshow'
			   
  AND element='themeslider'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:293
13	JSNISShowcaseTheme->getThemeInfo()	JROOT/modules/mod_imageshow/helper.php:137
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.77 ms After last query: 2.75 ms Query memory: 0.036 MB Memory before query: 37.960 MB Rows returned: 1

Duplicate queries: #60 #73

SELECT * 
  FROM upm_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
21	JSNISShowlist->getShowListByID()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:26
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.51 ms After last query: 0.99 ms Query memory: 0.039 MB Memory before query: 38.025 MB Rows returned: 20

SHOW FULL COLUMNS 
  FROM `upm_imageshow_showlist`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.51 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.16 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.15 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_imageshow/tables/showlist.php:41
23	TableShowList->TableShowList()	JROOT/libraries/src/Table/Table.php:328
22	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:120
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.66 ms Query memory: 0.036 MB Memory before query: 38.108 MB Rows returned: 1

Duplicate queries: #68

SELECT *

  FROM upm_imageshow_showlist

  WHERE `showlist_id` = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:123
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.54 ms After last query: 0.69 ms Query memory: 0.040 MB Memory before query: 38.196 MB Rows returned: 1

Duplicate queries: #67

SELECT *

  FROM upm_imageshow_showlist

  WHERE `showlist_id` = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 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.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
25	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:20
24	JSNImagesSourcesDefault->__construct()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:18
23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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: 0.60 ms Query memory: 0.037 MB Memory before query: 38.239 MB

UPDATE upm_extensions 
  SET enabled = 1 
  WHERE element LIKE 'source%' 
  AND folder = 'jsnimageshow' 
  AND enabled = 0

Explain

EXPLAIN not possible on query: UPDATE upm_extensions SET enabled = 1 WHERE element LIKE 'source%' AND folder = 'jsnimageshow' AND enabled = 0

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.11 ms
Updating	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
29	JDatabase->query()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:67
28	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
27	JSNISSource->JSNISSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
26	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
25	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
24	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.54 ms After last query: 0.22 ms Query memory: 0.043 MB Memory before query: 38.277 MB Rows returned: 2

SELECT * 
  FROM upm_extensions 
  WHERE element LIKE 'source%' 
  AND folder = 'jsnimageshow' 
  AND enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	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.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:71
28	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
27	JSNISSource->JSNISSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
26	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
25	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
24	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.55 ms After last query: 0.50 ms Query memory: 0.033 MB Memory before query: 38.331 MB Rows returned: 0

SELECT album_extid
				  
  FROM upm_imageshow_images
				  
  WHERE showlist_id =3
				  
  AND sync = 1
				  
  GROUP BY album_extid

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using temporary; Using filesort

Profile

Status	Duration
Starting	0.04 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.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:198
24	JSNISImages->getSyncAlbumsByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:23
23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.24 ms Query memory: 0.038 MB Memory before query: 38.364 MB Rows returned: 6

Duplicate queries: #63

SELECT
						image_id, image_title,
						image_small, image_big, image_medium,
						image_description, image_link,
						image_extid, album_extid, image_size, custom_data, exif_data
				   
  FROM upm_imageshow_images
				   
  WHERE showlist_id =3
				   
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort

Profile

Status	Duration
Starting	0.08 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.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:46
25	JSNISImages->getImagesByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:157
24	JSNImagesSourcesDefault->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:102
23	JSNImagesSourcesInternal->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/source_folder/internal_source_folder.php:407
22	JSNInternalSourceFolder->getImages2JSON()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:126
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.33 ms Query memory: 0.036 MB Memory before query: 38.422 MB Rows returned: 1

Duplicate queries: #60 #65

SELECT * 
  FROM upm_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 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.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 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.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
22	JSNISShowlist->getShowListByID()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:129
21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:27
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.50 ms After last query: 2.22 ms Query memory: 0.040 MB Memory before query: 38.472 MB Rows returned: 23

SHOW FULL COLUMNS 
  FROM `upm_imageshow_theme_slider`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.54 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.17 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.15 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
25	Joomla\CMS\Table\Table->__construct()	JROOT/plugins/jsnimageshow/themeslider/tables/themeslider.php:38
24	TableThemeSlider->__construct()	JROOT/libraries/src/Table/Table.php:328
23	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/jsnimageshow/themeslider/models/themeslider.php:50
22	ThemeSlider->getTable()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:240
21	JSNISSliderDisplay->getThemeDataStandard()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:55
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.87 ms Query memory: 0.039 MB Memory before query: 38.562 MB Rows returned: 1

SELECT *

  FROM upm_imageshow_theme_slider

  WHERE `theme_id` = '2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_imageshow_theme_slider	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 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.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/plugins/jsnimageshow/themeslider/models/themeslider.php:52
22	ThemeSlider->getTable()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:240
21	JSNISSliderDisplay->getThemeDataStandard()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:55
20	JSNISSliderDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themeslider/classes/jsn_is_sliderdisplay.php:227
19	JSNISSliderDisplay->display()	JROOT/plugins/jsnimageshow/themeslider/themeslider.php:77
18	plgJSNImageshowThemeSlider->onDisplayJSNShowcaseTheme()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.73 ms After last query: 2.19 ms Query memory: 0.021 MB Memory before query: 38.556 MB Rows returned: 0

SELECT *
 
  FROM upm_jmap_metainfo
 
  WHERE `linkurl` = 'https://pcdandf.com/pcdesign/index.php/current/18938-pulsonix-14-0-advances-design-with-embedded-simulation-smarter-3d-views-enhanced-workflow-tools'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	upm_jmap_metainfo	ref	linkurl,published	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:258
13	plgSystemJMap->onBeforeCompileHead()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.]

42 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
20 × SELECT lft, rgt 
  FROM upm_menu
```

5 × SELECT * 
  FROM upm_imageshow_showlist

```
4 × SELECT parent_id 
  FROM upm_menu
```

4 × SELECT assets, legacy 
  FROM upm_jsn_poweradmin_menu_assets

```
3 × SELECT * 
  FROM upm_extensions
```

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `upm_assets`

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

2 × SELECT       image_id, image_title,       image_small, image_big, image_medium,       image_description, image_link,       image_extid, album_extid, image_size, custom_data, exif_data        
  FROM upm_imageshow_images

1 × SELECT raw_stats 
  FROM upm_mostpopular

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM upm_modules AS m 
  LEFT JOIN upm_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN upm_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT c.introtext, c.fulltext        
  FROM upm_imageshow_showlist sl        
  INNER JOIN upm_content c 
  ON sl.alter_autid = c.id

1 × SELECT * 
  FROM upm_imageshow_showcase

1 × SELECT * 
  FROM upm_imageshow_theme_slider

1 × SELECT *  
  FROM upm_jmap_metainfo

1 × SELECT album_extid       
  FROM upm_imageshow_images

1 × SELECT *       
  FROM upm_extensions

1 × SELECT * 
  FROM upm_imageshow_theme_profile

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM upm_content AS a 
  LEFT JOIN upm_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.keyword, a.keywords, a.link, a.target, a.tooltip 
  FROM upm_sl_keywordlinking_keywords AS a 
  INNER JOIN upm_categories AS c 
  ON c.id = a.catid

1 × SELECT `enabled` 
  FROM `upm_extensions`

1 × SELECT `extension_id`,`name`,`enabled`,`params` 
  FROM upm_extensions

1 × SELECT COUNT(*) 
  FROM upm_extensions

1 × SELECT name,value 
  FROM upm_jsn_poweradmin_config

1 × SELECT id, rules 
  FROM `upm_viewlevels

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

1 × SELECT `alias`,`catid` 
  FROM `upm_content`

1 × SELECT manifest_cache 
  FROM upm_extensions

1 × SELECT `name`, `value` 
  FROM `upm_jsn_imageshow_config`

1 × SELECT `session_id` 
  FROM `upm_session`

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM upm_fields AS a 
  LEFT JOIN `upm_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN upm_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN upm_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN upm_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN upm_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `upm_fields_categories` AS fc 
  ON fc.field_id = a.id

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

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 upm_content AS a 
  INNER JOIN upm_categories AS c 
  on c.id = a.catid 
  LEFT JOIN upm_users AS u 
  on u.id = a.created_by 
  LEFT JOIN upm_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN upm_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to 
  FROM `upm_contact_details` AS `contact`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `upm_imageshow_showlist

1 × UPDATE upm_extensions 
  SET enabled = 1

1 × SHOW FULL COLUMNS 
  FROM `upm_imageshow_theme_slider

1 × UPDATE upm_mostpopular 
  SET 1_day_stats = 2  , 7_day_stats = 7  , 30_day_stats = 113  , all_time_stats = all_time_stats + 1  , raw_stats = 'a:29:{s:10:\"2025-10-24\";i:7;s:10:\"2025-10-25\";i:15;s:10:\"2025-10-26\";i:6;s:10:\"2025-10-27\";i:7;s:10:\"2025-10-28\";i:7;s:10:\"2025-10-29\";i:12;s:10:\"2025-10-30\";i:9;s:10:\"2025-10-31\";i:12;s:10:\"2025-11-01\";i:6;s:10:\"2025-11-02\";i:8;s:10:\"2025-11-03\";i:7;s:10:\"2025-11-04\";i:5;s:10:\"2025-11-05\";i:6;s:10:\"2025-11-06\";i:4;s:10:\"2025-11-07\";i:1;s:10:\"2025-11-08\";i:2;s:10:\"2025-11-09\";i:2;s:10:\"2025-11-10\";i:2;s:10:\"2025-11-11\";i:3;s:10:\"2025-11-12\";i:2;s:10:\"2025-11-13\";i:1;s:10:\"2025-11-14\";i:1;s:10:\"2025-11-15\";i:5;s:10:\"2025-11-16\";i:1;s:10:\"2025-11-17\";i:2;s:10:\"2025-11-18\";i:1;s:10:\"2025-11-20\";i:1;s:10:\"2025-11-21\";i:4;s:10:\"2025-11-25\";i:1;}'

1 × UPDATE upm_content 
  SET `hits` = (`hits` + 1)

```
1 × SHOW TABLE
```

1 × UPDATE `upm_extensions` 
  SET `params` = '{\"mediaversion\":\"6ce3a1cb6159b4bdf688daafce2cffd7\"}'

1 × SHOW FULL COLUMNS 
  FROM `upm_content

1 × INSERT INTO `upm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'686e75766e64666a6937383468766138366b346a6766326a7131', 1, 1764091623, 0, '', 0

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

76 Queries Logged 749.29 ms

16 duplicate found!

42 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: