Black Sheep Capuccino

This is override

Black Sheep Capuccino

Download

Submitted By: Super User (admin)

Submitted On: 15 Dec 2022

File Size: 703

Downloads: 12

File Author: Martin Brampton

Tasty

Thumbnails

File Rating

(0/0)

Be the first to comment! Please sign in or register.

open all | close all

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733939897,
                "last": 1733939897,
                "now": 1733939897
            }
        },
        "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.40 ms / 7.40 ms Memory: 1.481 MB / 1.83 MB Application: afterLoad

Time: 28.33 ms / 35.73 ms Memory: 3.228 MB / 5.06 MB Application: afterInitialise

Time: 17.24 ms / 52.97 ms Memory: 1.487 MB / 6.55 MB Application: afterRoute

Time: 5.56 ms / 58.53 ms Memory: 0.283 MB / 6.83 MB Application: beforeRenderComponent com_remository

Time: 34.56 ms / 93.09 ms Memory: 2.788 MB / 9.62 MB Application: afterRenderComponent com_remository

Time: 0.75 ms / 93.84 ms Memory: 0.091 MB / 9.71 MB Application: afterDispatch

Time: 2.54 ms / 96.37 ms Memory: 0.199 MB / 9.91 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Time: 1.15 ms / 97.53 ms Memory: 0.125 MB / 10.03 MB Application: afterRenderModule mod_menu (Bottom Menu)

Time: 0.02 ms / 97.54 ms Memory: -0.002 MB / 10.03 MB Application: beforeRenderModule mod_remositorymulti (Newest files)

Time: 8.77 ms / 106.31 ms Memory: 0.167 MB / 10.20 MB Application: afterRenderModule mod_remositorymulti (Newest files)

Time: 0.05 ms / 106.36 ms Memory: 0.003 MB / 10.20 MB Application: beforeRenderModule mod_tags_popular (Popular Tags)

Time: 1.89 ms / 108.25 ms Memory: 0.043 MB / 10.24 MB Application: afterRenderModule mod_tags_popular (Popular Tags)

Time: 0.02 ms / 108.27 ms Memory: -0.003 MB / 10.24 MB Application: beforeRenderModule mod_remositorytree (Remository Tree)

Time: 5.63 ms / 113.90 ms Memory: 0.066 MB / 10.31 MB Application: afterRenderModule mod_remositorytree (Remository Tree)

Time: 0.03 ms / 113.93 ms Memory: 0.002 MB / 10.31 MB Application: beforeRenderModule mod_articles_category (Older Posts)

Time: 1.78 ms / 115.71 ms Memory: 0.343 MB / 10.65 MB Application: Before Access::preloadComponents (all components)

Time: 1.21 ms / 116.92 ms Memory: 0.052 MB / 10.70 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 116.94 ms Memory: 0.001 MB / 10.70 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.29 ms / 117.23 ms Memory: 0.024 MB / 10.73 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 3.63 ms / 120.86 ms Memory: 0.153 MB / 10.88 MB Application: afterRenderModule mod_articles_category (Older Posts)

Time: 0.03 ms / 120.89 ms Memory: -0.108 MB / 10.77 MB Application: beforeRenderModule mod_articles_archive (Archived Articles)

Time: 1.05 ms / 121.94 ms Memory: 0.024 MB / 10.80 MB Application: afterRenderModule mod_articles_archive (Archived Articles)

Time: 0.02 ms / 121.96 ms Memory: -0.001 MB / 10.80 MB Application: beforeRenderModule mod_articles_popular (Most Read Posts)

Time: 1.75 ms / 123.70 ms Memory: 0.131 MB / 10.93 MB Application: afterRenderModule mod_articles_popular (Most Read Posts)

Time: 0.02 ms / 123.73 ms Memory: -0.097 MB / 10.83 MB Application: beforeRenderModule mod_syndicate (Syndication)

Time: 0.17 ms / 123.90 ms Memory: 0.008 MB / 10.84 MB Application: afterRenderModule mod_syndicate (Syndication)

Time: 0.03 ms / 123.93 ms Memory: -0.001 MB / 10.84 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.66 ms / 124.59 ms Memory: 0.043 MB / 10.88 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.03 ms / 124.62 ms Memory: -0.003 MB / 10.88 MB Application: beforeRenderModule mod_custom (Image)

Time: 6.06 ms / 130.68 ms Memory: 0.588 MB / 11.46 MB Application: afterRenderModule mod_custom (Image)

Time: 0.05 ms / 130.73 ms Memory: -0.001 MB / 11.46 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 1.51 ms / 132.24 ms Memory: 0.077 MB / 11.54 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.04 ms / 132.28 ms Memory: -0.004 MB / 11.54 MB Application: beforeRenderModule mod_search (Search)

Time: 0.47 ms / 132.75 ms Memory: 0.015 MB / 11.55 MB Application: afterRenderModule mod_search (Search)

Time: 67.78 ms / 200.53 ms Memory: 0.543 MB / 12.09 MB Application: afterRender

Database queries total: 64.64 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
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

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'65656230386538666b306133673335396a6d6130716676766f72', 1, 1733939897, 0, '', 0)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.06 ms
Waiting for query cache lock	0.00 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.65 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.22 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.05 ms After last query: 1.15 ms Query memory: 0.021 MB Memory before query: 3.595 MB Rows returned: 36

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	36	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.57 ms After last query: 1.07 ms Query memory: 0.020 MB Memory before query: 3.820 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 ms
Reset for next command	0.02 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.52 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 3.830 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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	2	Using where; Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.05 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/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: 0.81 ms After last query: 0.39 ms Query memory: 0.022 MB Memory before query: 3.894 MB Rows returned: 85

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

  FROM jos_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
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.19 ms After last query: 8.70 ms Query memory: 0.039 MB Memory before query: 5.230 MB Rows returned: 23

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

  FROM jos_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	23	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	myremos_j310.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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.97 ms After last query: 4.47 ms Query memory: 0.025 MB Memory before query: 5.946 MB Rows returned: 107

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:86
15	BlackSheepResearch\aliro\database\ExtendedDatabase->loadResultArray()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:237
14	BlackSheepResearch\aliro\database\ExtendedDatabase->getTableInfo()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:125
13	BlackSheepResearch\aliro\database\ExtendedDatabase->emptyCache()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:58
12	BlackSheepResearch\aliro\database\ExtendedDatabase->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/Database.php:57
11	BlackSheepResearch\aliro\database\Database->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/Database.php:61
10	BlackSheepResearch\aliro\database\Database::getInstance()	JROOT/libraries/BlackSheepResearch/InterfaceLayer.php:162
9	BlackSheepResearch\InterfaceLayer->__construct()	JROOT/libraries/BlackSheepResearch/InterfaceLayer.php:167
8	BlackSheepResearch\InterfaceLayer::getInstance()	JROOT/components/com_remository/router.php:24
7	require_once JROOT/components/com_remository/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: 0.72 ms After last query: 1.95 ms Query memory: 0.021 MB Memory before query: 6.203 MB Rows returned: 0

SHOW TABLES LIKE 'jos_downloads_repository'

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE 'jos_downloads_repository'

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:135
13	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQL()	JROOT/components/com_remository/src/Problems/Repository.php:79
12	BlackSheepResearch\Component\Remository\Site\Problems\Repository->__construct()	JROOT/components/com_remository/src/Problems/Repository.php:104
11	BlackSheepResearch\Component\Remository\Site\Problems\Repository::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:449
10	BlackSheepResearch\Component\Remository\Site\Problems\SEF::revert()	JROOT/components/com_remository/router.php:59
9	RemositoryRouter->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.69 ms After last query: 2.18 ms Query memory: 0.025 MB Memory before query: 6.482 MB Rows returned: 1

SELECT COUNT(*) 
  FROM jos_downloads_containers

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_downloads_containers	index	NULL	parentid	3	NULL	6	Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
20	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Managers/ContainerManager.php:82
19	BlackSheepResearch\Component\Remository\Site\Managers\ContainerManager->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
18	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
17	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Managers/ContainerManager.php:105
16	BlackSheepResearch\Component\Remository\Site\Managers\ContainerManager::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:63
15	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getContainerData()	JROOT/components/com_remository/src/Problems/SEF.php:50
14	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
13	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
12	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Problems/SEF.php:126
11	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:508
10	BlackSheepResearch\Component\Remository\Site\Problems\SEF::revert()	JROOT/components/com_remository/router.php:59
9	RemositoryRouter->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.67 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 6.491 MB Rows returned: 7

SELECT * 
  FROM jos_downloads_containers 
  LIMIT 0, 1000

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:141
22	BlackSheepResearch\aliro\database\ExtendedDatabase->SQLgetrows()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:150
21	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
20	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Managers/ContainerManager.php:87
19	BlackSheepResearch\Component\Remository\Site\Managers\ContainerManager->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
18	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
17	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Managers/ContainerManager.php:105
16	BlackSheepResearch\Component\Remository\Site\Managers\ContainerManager::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:63
15	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getContainerData()	JROOT/components/com_remository/src/Problems/SEF.php:50
14	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
13	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
12	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Problems/SEF.php:126
11	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:508
10	BlackSheepResearch\Component\Remository\Site\Problems\SEF::revert()	JROOT/components/com_remository/router.php:59
9	RemositoryRouter->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.59 ms After last query: 0.61 ms Query memory: 0.026 MB Memory before query: 6.517 MB Rows returned: 3

Duplicate queries: #14

SELECT `path`, `link` 
  FROM `jos_menu` 
  WHERE `link` LIKE '%remository%' 
  AND `published` > 0 
  AND `client_id` = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
23	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/SEF.php:79
22	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getMenus()	JROOT/components/com_remository/src/Problems/SEF.php:51
21	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
20	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
19	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Problems/SEF.php:126
18	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:532
17	BlackSheepResearch\Component\Remository\Site\Problems\SEF::clearCache()	JROOT/components/com_remository/src/Managers/ContainerManager.php:107
16	BlackSheepResearch\Component\Remository\Site\Managers\ContainerManager::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:63
15	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getContainerData()	JROOT/components/com_remository/src/Problems/SEF.php:50
14	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
13	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
12	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Problems/SEF.php:126
11	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:508
10	BlackSheepResearch\Component\Remository\Site\Problems\SEF::revert()	JROOT/components/com_remository/router.php:59
9	RemositoryRouter->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.68 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 6.531 MB Rows returned: 3

Duplicate queries: #13

SELECT `path`, `link` 
  FROM `jos_menu` 
  WHERE `link` LIKE '%remository%' 
  AND `published` > 0 
  AND `client_id` = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
16	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/SEF.php:79
15	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getMenus()	JROOT/components/com_remository/src/Problems/SEF.php:51
14	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
13	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/components/com_remository/src/Problems/Cached.php:31
12	BlackSheepResearch\Component\Remository\Site\Problems\Cached::getCachedSingleton()	JROOT/components/com_remository/src/Problems/SEF.php:126
11	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data::getInstance()	JROOT/components/com_remository/src/Problems/SEF.php:508
10	BlackSheepResearch\Component\Remository\Site\Problems\SEF::revert()	JROOT/components/com_remository/router.php:59
9	RemositoryRouter->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.66 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 6.540 MB Rows returned: 2

SELECT f.id, f.containerid, f.filetitle, f.realname 
  FROM jos_downloads_files AS f 
  WHERE f.containerid = 6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	containerid,recommended,featured,opsystem	containerid	2	const	2

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 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/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
13	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/SEF.php:160
12	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->setFileInfo()	JROOT/components/com_remository/src/Problems/SEF.php:204
11	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->findContainer()	JROOT/components/com_remository/src/Problems/SEF.php:509
10	BlackSheepResearch\Component\Remository\Site\Problems\SEF::revert()	JROOT/components/com_remository/router.php:59
9	RemositoryRouter->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.66 ms After last query: 0.44 ms Query memory: 0.022 MB Memory before query: 6.581 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.00 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:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.32 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 6.572 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"372a653134743e7ecc0acf11a1475d1a\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"372a653134743e7ecc0acf11a1475d1a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.04 ms
Updating	0.05 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.74 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.92 ms After last query: 1.13 ms Query memory: 0.019 MB Memory before query: 6.813 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.81 ms After last query: 0.17 ms Query memory: 0.018 MB Memory before query: 6.822 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	myremos_j310.s.template,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.79 ms After last query: 2.30 ms Query memory: 0.025 MB Memory before query: 7.103 MB Rows returned: 9

SELECT DISTINCT g.title AS role 
  FROM jos_usergroups AS g 
  INNER JOIN jos_usergroups AS c 
  ON g.parent_id != c.id 
  AND g.id != c.parent_id 
  AND g.id != c.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g	index	NULL	idx_usergroup_parent_title_lookup	406	NULL	9	Using index; Using temporary
1	SIMPLE	c	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	9	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.08 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 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()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
18	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/AuthoriserCache.php:136
17	BlackSheepResearch\aliro\rolebasedaccess\AuthoriserCache->getRoleData()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/AuthoriserCache.php:90
16	BlackSheepResearch\aliro\rolebasedaccess\AuthoriserCache->getCacheData()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/AuthoriserCache.php:82
15	BlackSheepResearch\aliro\rolebasedaccess\AuthoriserCache->__construct()	JROOT/libraries/BlackSheepResearch/aliro/cache/cachedSingleton.php:28
14	BlackSheepResearch\aliro\cache\cachedSingleton::getCachedSingleton()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/AuthoriserCache.php:100
13	BlackSheepResearch\aliro\rolebasedaccess\AuthoriserCache::getInstance()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:87
12	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->__construct()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:101
11	BlackSheepResearch\aliro\rolebasedaccess\Authoriser::getInstance()	JROOT/components/com_remository/src/Problems/User.php:102
10	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:109
9	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/components/com_remository/src/Controllers/UserCommon.php:62
8	BlackSheepResearch\Component\Remository\Site\Controllers\UserCommon->__construct()	JROOT/components/com_remository/src/Controllers/UserManager.php:102
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.66 ms After last query: 0.40 ms Query memory: 0.022 MB Memory before query: 7.113 MB Rows returned: 8

SELECT role, subject_id, action 
  FROM jos_permissions 
  WHERE subject_type = 'remosFolder' 
  AND action IN('download','edit')

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 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:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
12	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:305
11	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getRefusedList()	JROOT/components/com_remository/src/Problems/User.php:103
10	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:109
9	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/components/com_remository/src/Controllers/UserCommon.php:62
8	BlackSheepResearch\Component\Remository\Site\Controllers\UserCommon->__construct()	JROOT/components/com_remository/src/Controllers/UserManager.php:102
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.21 ms After last query: 2.53 ms Query memory: 0.005 MB Memory before query: 7.457 MB

UPDATE jos_extensions 
  SET params = '{\"Update_Key\":\"138ba94176ac95778fbb6601ae51b4e5b6a9a4b378b122f1b11753d7ba1f9aff\",\"MaxSize\":\"5000\",\"Max_Up_Dir_Space\":\"50000\",\"User_Remote_Files\":\"0\",\"ExtsOk\":\"txt,exe,tar,gz,rar,zip,png,gif,jpg,pdf,doc,rtf,odt,odc,odp,odg,mp3,mov\",\"Anti_Leach\":\"0\",\"Date_Format\":\"d M Y\",\"Set_date_locale\":\"\",\"Driver_type\":\"Blob\",\"Down_Path\":\"\\/var\\/www\\/myremos\\/public_html\\/remository_downloads\",\"Real_With_ID\":\"1\",\"Allow_Up_Overwrite\":\"1\",\"Fallback_username\":\"admin\",\"Large_Text_Len\":\"300\",\"Small_Text_Len\":\"150\",\"Max_Thumbnails\":\"1\",\"Large_Image_Width\":\"600\",\"Large_Image_Height\":\"600\",\"Small_Image_Width\":\"100\",\"Small_Image_Height\":\"100\",\"Time_Stamp\":\"1136491012\",\"Cron_Timer\":1733939897,\"Main_Page_Title\":\"Remository\",\"headerpic\":\"\\/media\\/com_remository\\/images\\/header.gif\",\"Remository_Pathway\":\"0\",\"Show_RSS_feeds\":\"1\",\"Show_SubCategories\":\"0\",\"Items_per_page\":\"10\",\"Page_spread\":\"9\",\"Default_ordering\":\"2\",\"Show_search_box\":\"1\",\"Apply_content_plugins\":\"0\",\"See_Containers_no_download\":\"1\",\"See_Files_no_download\":\"1\",\"Featured_Number\":\"0\",\"Show_File_Folder_Counts\":\"1\",\"Immediate_Download\":\"0\",\"Allow_File_Info\":\"1\",\"Show_download_counts\":\"1\",\"Allow_Large_Images\":\"1\",\"Show_Footer\":\"1\",\"Show_all_containers\":\"0\",\"Display_FolderIcons\":\"1\",\"Display_FileIcons\":\"1\",\"ExtsDisplay\":\"\",\"Large_icon_size\":\"32\",\"Small_icon_size\":\"16\",\"Use_CMS_Groups\":\"0\",\"Allow_Comments\":\"1\",\"Min_Comment_length\":\"10\",\"Allow_Votes\":\"1\",\"Allow_Visitor_Votes\":\"0\",\"Enable_List_Download\":\"0\",\"Max_Down_Per_Day\":\"5\",\"Max_Down_Reg_Day\":\"10\",\"Max_Down_File_Day\":\"5\",\"Max_Up_Per_Day\":\"5\",\"ExtsAudio\":\"\",\"Audio_Download\":\"0\",\"ExtsVideo\":\"\",\"Video_Download\":\"0\",\"Favourites_Max\":\"0\",\"File_Block_Size\":\"60000\",\"Download_Delay\":\"100\",\"Profile_URI\":\"\",\"Classification_Types\":\"\",\"Update_Server_Salt\":\"You must change this\",\"Count_Down\":\"0\",\"Allow_User_Sub\":\"1\",\"Allow_Container_Add\":\"0\",\"Allow_Container_Edit\":\"0\",\"Allow_Container_Delete\":\"0\",\"Allow_User_Edit\":\"1\",\"Allow_User_Delete\":\"0\",\"Upload_create_folder\":\"0\",\"Enable_Admin_Autoapp\":\"1\",\"Enable_User_Autoapp\":\"0\",\"Make_Auto_Thumbnail\":\"0\",\"Default_Version\":\"1.0\",\"Send_Sub_Mail\":\"0\",\"Sub_Mail_Alt_Addr\":\"\",\"Email_on_new_file\":\"0\",\"Email_on_new_comment\":\"0\",\"SEF_lower_case\":\"0\",\"SEF_add_ID\":\"0\",\"Checkfail_file_ID\":\"0\",\"s3region\":\"\",\"s3key\":\"\",\"s3secret\":\"\",\"s3bucket\":\"\",\"download_text\":\"\",\"preamble\":\"\",\"Default_Licence\":\"\",\"custom-A-filedate\":\"0\",\"custom-A-price\":\"0\",\"custom-A-smalldesc\":\"50\",\"custom-A-submittedby\":\"60\",\"custom-A-submitdate\":\"70\",\"custom-A-filesize\":\"0\",\"custom-A-downloads\":\"90\",\"custom-A-fileversion\":\"0\",\"custom-A-fileauthor\":\"0\",\"custom-A-filehomepage\":\"0\",\"custom-B-filedate\":\"0\",\"custom-B-price\":\"0\",\"custom-B-smalldesc\":\"50\",\"custom-B-submittedby\":\"60\",\"custom-B-submitdate\":\"70\",\"custom-B-filesize\":\"0\",\"custom-B-downloads\":\"90\",\"custom-B-vote_value\":\"100\",\"custom-B-license\":\"0\",\"custom-B-fileversion\":\"0\",\"custom-B-fileauthor\":\"0\",\"custom-B-filehomepage\":\"0\",\"custom-C-filedate\":\"0\",\"custom-C-description\":\"0\",\"custom-C-icon\":\"0\",\"custom-C-price\":\"0\",\"custom-C-smalldesc\":\"50\",\"custom-C-submittedby\":\"60\",\"custom-C-submitdate\":\"70\",\"custom-C-filesize\":\"0\",\"custom-C-downloads\":\"90\",\"custom-C-vote_value\":\"100\",\"custom-C-license\":\"0\",\"custom-C-fileversion\":\"0\",\"custom-C-fileauthor\":\"0\",\"custom-C-filehomepage\":\"0\",\"custom-D-filedate\":\"0\",\"custom-D-description\":\"20\",\"custom-D-price\":\"0\",\"custom-D-submittedby\":\"60\",\"custom-D-submitdate\":\"70\",\"custom-D-filesize\":\"80\",\"custom-D-downloads\":\"90\",\"custom-D-vote_value\":\"100\",\"custom-D-license\":\"0\",\"custom-D-fileversion\":\"120\",\"custom-D-fileauthor\":\"130\",\"custom-D-filehomepage\":\"140\",\"custom-E-filedate\":\"0\",\"custom-E-description\":\"20\",\"custom-E-icon\":\"0\",\"custom-E-price\":\"0\",\"custom-E-smalldesc\":\"50\",\"custom-E-submittedby\":\"0\",\"custom-E-submitdate\":\"0\",\"custom-E-filesize\":\"0\",\"custom-E-downloads\":\"0\",\"custom-E-vote_value\":\"0\",\"custom-E-license\":\"0\",\"custom-E-fileversion\":\"120\",\"custom-E-fileauthor\":\"130\",\"custom-E-filehomepage\":\"140\"}' 
  WHERE type = 'component' 
  AND element = 'com_remository'

Explain

EXPLAIN not possible on query: UPDATE jos_extensions SET params = '{\"Update_Key\":\"138ba94176ac95778fbb6601ae51b4e5b6a9a4b378b122f1b11753d7ba1f9aff\",\"MaxSize\":\"5000\",\"Max_Up_Dir_Space\":\"50000\",\"User_Remote_Files\":\"0\",\"ExtsOk\":\"txt,exe,tar,gz,rar,zip,png,gif,jpg,pdf,doc,rtf,odt,odc,odp,odg,mp3,mov\",\"Anti_Leach\":\"0\",\"Date_Format\":\"d M Y\",\"Set_date_locale\":\"\",\"Driver_type\":\"Blob\",\"Down_Path\":\"\\/var\\/www\\/myremos\\/public_html\\/remository_downloads\",\"Real_With_ID\":\"1\",\"Allow_Up_Overwrite\":\"1\",\"Fallback_username\":\"admin\",\"Large_Text_Len\":\"300\",\"Small_Text_Len\":\"150\",\"Max_Thumbnails\":\"1\",\"Large_Image_Width\":\"600\",\"Large_Image_Height\":\"600\",\"Small_Image_Width\":\"100\",\"Small_Image_Height\":\"100\",\"Time_Stamp\":\"1136491012\",\"Cron_Timer\":1733939897,\"Main_Page_Title\":\"Remository\",\"headerpic\":\"\\/media\\/com_remository\\/images\\/header.gif\",\"Remository_Pathway\":\"0\",\"Show_RSS_feeds\":\"1\",\"Show_SubCategories\":\"0\",\"Items_per_page\":\"10\",\"Page_spread\":\"9\",\"Default_ordering\":\"2\",\"Show_search_box\":\"1\",\"Apply_content_plugins\":\"0\",\"See_Containers_no_download\":\"1\",\"See_Files_no_download\":\"1\",\"Featured_Number\":\"0\",\"Show_File_Folder_Counts\":\"1\",\"Immediate_Download\":\"0\",\"Allow_File_Info\":\"1\",\"Show_download_counts\":\"1\",\"Allow_Large_Images\":\"1\",\"Show_Footer\":\"1\",\"Show_all_containers\":\"0\",\"Display_FolderIcons\":\"1\",\"Display_FileIcons\":\"1\",\"ExtsDisplay\":\"\",\"Large_icon_size\":\"32\",\"Small_icon_size\":\"16\",\"Use_CMS_Groups\":\"0\",\"Allow_Comments\":\"1\",\"Min_Comment_length\":\"10\",\"Allow_Votes\":\"1\",\"Allow_Visitor_Votes\":\"0\",\"Enable_List_Download\":\"0\",\"Max_Down_Per_Day\":\"5\",\"Max_Down_Reg_Day\":\"10\",\"Max_Down_File_Day\":\"5\",\"Max_Up_Per_Day\":\"5\",\"ExtsAudio\":\"\",\"Audio_Download\":\"0\",\"ExtsVideo\":\"\",\"Video_Download\":\"0\",\"Favourites_Max\":\"0\",\"File_Block_Size\":\"60000\",\"Download_Delay\":\"100\",\"Profile_URI\":\"\",\"Classification_Types\":\"\",\"Update_Server_Salt\":\"You must change this\",\"Count_Down\":\"0\",\"Allow_User_Sub\":\"1\",\"Allow_Container_Add\":\"0\",\"Allow_Container_Edit\":\"0\",\"Allow_Container_Delete\":\"0\",\"Allow_User_Edit\":\"1\",\"Allow_User_Delete\":\"0\",\"Upload_create_folder\":\"0\",\"Enable_Admin_Autoapp\":\"1\",\"Enable_User_Autoapp\":\"0\",\"Make_Auto_Thumbnail\":\"0\",\"Default_Version\":\"1.0\",\"Send_Sub_Mail\":\"0\",\"Sub_Mail_Alt_Addr\":\"\",\"Email_on_new_file\":\"0\",\"Email_on_new_comment\":\"0\",\"SEF_lower_case\":\"0\",\"SEF_add_ID\":\"0\",\"Checkfail_file_ID\":\"0\",\"s3region\":\"\",\"s3key\":\"\",\"s3secret\":\"\",\"s3bucket\":\"\",\"download_text\":\"\",\"preamble\":\"\",\"Default_Licence\":\"\",\"custom-A-filedate\":\"0\",\"custom-A-price\":\"0\",\"custom-A-smalldesc\":\"50\",\"custom-A-submittedby\":\"60\",\"custom-A-submitdate\":\"70\",\"custom-A-filesize\":\"0\",\"custom-A-downloads\":\"90\",\"custom-A-fileversion\":\"0\",\"custom-A-fileauthor\":\"0\",\"custom-A-filehomepage\":\"0\",\"custom-B-filedate\":\"0\",\"custom-B-price\":\"0\",\"custom-B-smalldesc\":\"50\",\"custom-B-submittedby\":\"60\",\"custom-B-submitdate\":\"70\",\"custom-B-filesize\":\"0\",\"custom-B-downloads\":\"90\",\"custom-B-vote_value\":\"100\",\"custom-B-license\":\"0\",\"custom-B-fileversion\":\"0\",\"custom-B-fileauthor\":\"0\",\"custom-B-filehomepage\":\"0\",\"custom-C-filedate\":\"0\",\"custom-C-description\":\"0\",\"custom-C-icon\":\"0\",\"custom-C-price\":\"0\",\"custom-C-smalldesc\":\"50\",\"custom-C-submittedby\":\"60\",\"custom-C-submitdate\":\"70\",\"custom-C-filesize\":\"0\",\"custom-C-downloads\":\"90\",\"custom-C-vote_value\":\"100\",\"custom-C-license\":\"0\",\"custom-C-fileversion\":\"0\",\"custom-C-fileauthor\":\"0\",\"custom-C-filehomepage\":\"0\",\"custom-D-filedate\":\"0\",\"custom-D-description\":\"20\",\"custom-D-price\":\"0\",\"custom-D-submittedby\":\"60\",\"custom-D-submitdate\":\"70\",\"custom-D-filesize\":\"80\",\"custom-D-downloads\":\"90\",\"custom-D-vote_value\":\"100\",\"custom-D-license\":\"0\",\"custom-D-fileversion\":\"120\",\"custom-D-fileauthor\":\"130\",\"custom-D-filehomepage\":\"140\",\"custom-E-filedate\":\"0\",\"custom-E-description\":\"20\",\"custom-E-icon\":\"0\",\"custom-E-price\":\"0\",\"custom-E-smalldesc\":\"50\",\"custom-E-submittedby\":\"0\",\"custom-E-submitdate\":\"0\",\"custom-E-filesize\":\"0\",\"custom-E-downloads\":\"0\",\"custom-E-vote_value\":\"0\",\"custom-E-license\":\"0\",\"custom-E-fileversion\":\"120\",\"custom-E-fileauthor\":\"130\",\"custom-E-filehomepage\":\"140\"}' WHERE type = 'component' AND element = 'com_remository'

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.06 ms
Updating	0.06 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	1.15 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:135
12	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQL()	JROOT/libraries/BlackSheepResearch/Utils.php:104
11	BlackSheepResearch\Utils::doSQL()	JROOT/components/com_remository/src/Problems/Repository.php:119
10	BlackSheepResearch\Component\Remository\Site\Problems\Repository->saveValues()	JROOT/components/com_remository/src/Problems/Repository.php:279
9	BlackSheepResearch\Component\Remository\Site\Problems\Repository->checkCronTimer()	JROOT/components/com_remository/src/Controllers/UserCommon.php:66
8	BlackSheepResearch\Component\Remository\Site\Controllers\UserCommon->__construct()	JROOT/components/com_remository/src/Controllers/UserManager.php:102
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.65 ms After last query: 1.47 ms Query memory: 0.022 MB Memory before query: 7.732 MB Rows returned: 1

Duplicate queries: #41 #42 #43 #44 #45

SELECT NOW()

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	No tables used

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
11	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:72
10	BlackSheepResearch\Component\Remository\Site\Problems\File->__construct()	JROOT/components/com_remository/src/Controllers/UserCommon.php:87
9	BlackSheepResearch\Component\Remository\Site\Controllers\UserCommon->createFile()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:58
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.11 ms After last query: 0.06 ms Query memory: 0.039 MB Memory before query: 7.739 MB Rows returned: 1

SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count,  
  CASE WHEN fv.user_id IS NULL THEN 0 WHEN fv.user_id = 0 THEN 0 ELSE 1 END AS favourite 
  FROM jos_downloads_files AS f 
  LEFT JOIN jos_downloads_log AS l 
  ON l.type=3 
  AND l.fileid=f.id 
  LEFT JOIN jos_downloads_favour AS fv 
  ON fv.file_id = f.id 
  AND fv.user_id = 0 
  WHERE f.id = 12 
  AND published=1 
  GROUP BY f.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	const	id	id	4	const	1
1	SIMPLE	l	ref	userid,fileid,ipaddress	userid	1	const	1	Using where
1	SIMPLE	fv	const	user_id	user_id	8	const,const	1	Using index

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.29 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
12	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/database/DatabaseRow.php:125
11	BlackSheepResearch\aliro\database\DatabaseRow->readDataBase()	JROOT/components/com_remository/src/Problems/File.php:380
10	BlackSheepResearch\Component\Remository\Site\Problems\File->getValues()	JROOT/components/com_remository/src/Controllers/UserCommon.php:88
9	BlackSheepResearch\Component\Remository\Site\Controllers\UserCommon->createFile()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:58
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.59 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 7.755 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `jos_permissions` 
  WHERE `subject_type`='remosFolder' 
  AND (`action`='download' OR `action`='*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_permissions	range	subaction	subaction	484	NULL	3	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
13	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:142
12	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getSubjectData()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:221
11	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->accessorPermissionOrControl()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:233
10	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->checkPermission()	JROOT/components/com_remository/src/Problems/File.php:513
9	BlackSheepResearch\Component\Remository\Site\Problems\File->downloadForbidden()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:59
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.55 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 7.761 MB Rows returned: 2

SELECT `role`, `control`, `subject_id`, `action` 
  FROM `jos_permissions` 
  WHERE `subject_type`='remosFolder' 
  AND (`action`='download' OR `action`='*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_permissions	range	subaction	subaction	484	NULL	3	Using index condition

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 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/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
13	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:144
12	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getSubjectData()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:221
11	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->accessorPermissionOrControl()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:233
10	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->checkPermission()	JROOT/components/com_remository/src/Problems/File.php:513
9	BlackSheepResearch\Component\Remository\Site\Problems\File->downloadForbidden()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:59
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.55 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.771 MB Rows returned: 0

SELECT fileid, COUNT(fileid) AS number 
  FROM jos_downloads_log 
  WHERE type = 1 
  AND ipaddress = '18.97.14.91' 
  AND date > SUBDATE(NOW(), INTERVAL 24 HOUR) 
  GROUP BY fileid

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_downloads_log	range	userid,fileid,ipaddress	ipaddress	162	NULL	1	Using index condition; Using temporary; Using filesort

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 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()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
14	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/User.php:370
13	BlackSheepResearch\Component\Remository\Site\Problems\User->nonLoggedCount()	JROOT/components/com_remository/src/Problems/User.php:355
12	BlackSheepResearch\Component\Remository\Site\Problems\User->getDownloadInfo()	JROOT/components/com_remository/src/Problems/User.php:382
11	BlackSheepResearch\Component\Remository\Site\Problems\User->downloadCount()	JROOT/components/com_remository/src/Problems/File.php:485
10	BlackSheepResearch\Component\Remository\Site\Problems\File->checkCountStats()	JROOT/components/com_remository/src/Problems/File.php:515
9	BlackSheepResearch\Component\Remository\Site\Problems\File->downloadForbidden()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:59
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.48 ms After last query: 3.45 ms Query memory: 0.022 MB Memory before query: 8.288 MB Rows returned: 0

SELECT c.*,  
  CASE WHEN c.type = '' THEN 0  ELSE 9 END AS typseq  
  FROM jos_downloads_classify AS c  
  INNER JOIN jos_downloads_file_classify AS fc 
  ON c.id = fc.classify_id  
  WHERE c.published != 0 
  AND c.hidden = 0 
  AND fc.file_id = 12 
  ORDER BY typseq, c.name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	myremos_j310.fc.classify_id	1	Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.28 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 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/BlackSheepResearch/aliro/database/ExtendedDatabase.php:141
12	BlackSheepResearch\aliro\database\ExtendedDatabase->SQLgetrows()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:150
11	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
10	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Controllers/UserCommon.php:125
9	BlackSheepResearch\Component\Remository\Site\Controllers\UserCommon->getRelated()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.27 ms After last query: 4.33 ms Query memory: 0.027 MB Memory before query: 8.799 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `jos_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
22	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
21	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
20	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/BlackSheepResearch/Utils.php:352
17	BlackSheepResearch\Utils::getUser()	JROOT/components/com_remository/src/Problems/User.php:82
16	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:116
15	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:138
14	BlackSheepResearch\Component\Remository\Site\Viewers\show_submittedby()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:511
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.71 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 8.906 MB Rows returned: 1

SELECT *

  FROM `jos_users`

  WHERE `id` = 233

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_users	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.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/BlackSheepResearch/Utils.php:352
17	BlackSheepResearch\Utils::getUser()	JROOT/components/com_remository/src/Problems/User.php:82
16	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:116
15	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:138
14	BlackSheepResearch\Component\Remository\Site\Viewers\show_submittedby()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:511
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.77 ms After last query: 1.47 ms Query memory: 0.025 MB Memory before query: 9.440 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `jos_usergroups` AS g

  INNER JOIN `jos_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 233

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	myremos_j310.m.group_id	1

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/BlackSheepResearch/Utils.php:352
17	BlackSheepResearch\Utils::getUser()	JROOT/components/com_remository/src/Problems/User.php:82
16	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:116
15	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:138
14	BlackSheepResearch\Component\Remository\Site\Viewers\show_submittedby()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:511
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.49 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 9.446 MB Rows returned: 1

SELECT email 
  FROM jos_users 
  WHERE id = 233

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
19	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/User.php:349
18	BlackSheepResearch\Component\Remository\Site\Problems\User->getEmailAddress()	JROOT/components/com_remository/src/Problems/User.php:148
17	BlackSheepResearch\Component\Remository\Site\Problems\User->addAvatar()	JROOT/components/com_remository/src/Problems/User.php:86
16	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:116
15	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:138
14	BlackSheepResearch\Component\Remository\Site\Viewers\show_submittedby()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:511
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.53 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 9.457 MB Rows returned: 0

SELECT role, access_id 
  FROM jos_assignments AS a 
  WHERE a.access_type='aUser' 
  AND (a.access_id='233' OR a.access_id='*' OR a.access_id='+')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	access_type	access_type	484	NULL	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
19	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:182
18	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getAccessorRoles()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:298
17	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getRefusedList()	JROOT/components/com_remository/src/Problems/User.php:103
16	BlackSheepResearch\Component\Remository\Site\Problems\User->__construct()	JROOT/components/com_remository/src/Problems/User.php:116
15	BlackSheepResearch\Component\Remository\Site\Problems\User::getUser()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:138
14	BlackSheepResearch\Component\Remository\Site\Viewers\show_submittedby()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:511
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.54 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 9.465 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `jos_permissions` 
  WHERE `subject_type`='remosFolder' 
  AND (`action`='edit' OR `action`='*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_permissions	range	subaction	subaction	484	NULL	7	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
19	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:142
18	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getSubjectData()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:221
17	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->accessorPermissionOrControl()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:233
16	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->checkPermission()	JROOT/components/com_remository/src/Problems/File.php:562
15	BlackSheepResearch\Component\Remository\Site\Problems\File->checkUpOrDel()	JROOT/components/com_remository/src/Problems/File.php:547
14	BlackSheepResearch\Component\Remository\Site\Problems\File->updatePermitted()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:549
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.53 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 9.475 MB Rows returned: 6

SELECT `role`, `control`, `subject_id`, `action` 
  FROM `jos_permissions` 
  WHERE `subject_type`='remosFolder' 
  AND (`action`='edit' OR `action`='*')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
19	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:144
18	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->getSubjectData()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:221
17	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->accessorPermissionOrControl()	JROOT/libraries/BlackSheepResearch/aliro/rolebasedaccess/Authoriser.php:233
16	BlackSheepResearch\aliro\rolebasedaccess\Authoriser->checkPermission()	JROOT/components/com_remository/src/Problems/File.php:562
15	BlackSheepResearch\Component\Remository\Site\Problems\File->checkUpOrDel()	JROOT/components/com_remository/src/Problems/File.php:547
14	BlackSheepResearch\Component\Remository\Site\Problems\File->updatePermitted()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:549
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.67 ms After last query: 1.34 ms Query memory: 0.023 MB Memory before query: 9.683 MB Rows returned: 1

Duplicate queries: #37

SELECT COUNT(*) 
  FROM jos_downloads_log 
  WHERE type=3 
  AND ipaddress='18.97.14.91' 
  AND fileid=12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_downloads_log	ref	userid,fileid,ipaddress	userid	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:135
16	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQL()	JROOT/libraries/BlackSheepResearch/Utils.php:104
15	BlackSheepResearch\Utils::doSQL()	JROOT/components/com_remository/src/Problems/File.php:405
14	BlackSheepResearch\Component\Remository\Site\Problems\File->userVoted()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:653
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.49 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 9.691 MB Rows returned: 1

Duplicate queries: #36

SELECT COUNT(*) 
  FROM jos_downloads_log 
  WHERE type=3 
  AND ipaddress='18.97.14.91' 
  AND fileid=12

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_downloads_log	ref	userid,fileid,ipaddress	userid	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
15	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:406
14	BlackSheepResearch\Component\Remository\Site\Problems\File->userVoted()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:653
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.10 ms After last query: 0.67 ms Query memory: 0.024 MB Memory before query: 9.731 MB Rows returned: 0

SELECT c.id, c.title, c.comment, c.date, c.imgcount, u.id as userid, u.name, u.username 
  FROM jos_downloads_reviews AS c 
  INNER JOIN jos_users AS u 
  ON c.userid=u.id 
  WHERE c.itemid=12 
  ORDER BY c.date DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using temporary; Using filesort
1	SIMPLE	u	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:141
18	BlackSheepResearch\aliro\database\ExtendedDatabase->SQLgetrows()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:150
17	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
16	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/Comment.php:178
15	BlackSheepResearch\Component\Remository\Site\Problems\Comment::getComments()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:347
14	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->BlackSheepResearch\Component\Remository\Site\Viewers\{closure}()	JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php:729
13	include JROOT/templates/protostar/html/com_remository/FileInfo/default_fileinfo.php	JROOT/components/com_remository/src/Viewers/HTML.php:77
12	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Viewers/HTML.php:47
10	BlackSheepResearch\Component\Remository\Site\Viewers\HTML->display()	JROOT/components/com_remository/src/Viewers/FileInfoHTML.php:42
9	BlackSheepResearch\Component\Remository\Site\Viewers\FileInfoHTML->fileinfoHTML()	JROOT/components/com_remository/src/Controllers/Fileinfo.php:100
8	BlackSheepResearch\Component\Remository\Site\Controllers\Fileinfo->fileinfoAction()	JROOT/components/com_remository/src/Controllers/UserManager.php:105
7	BlackSheepResearch\Component\Remository\Site\Controllers\UserManager->__construct()	JROOT/components/com_remository/remository.php:54
6	require_once JROOT/components/com_remository/remository.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.09 ms After last query: 1.84 ms Query memory: 0.022 MB Memory before query: 9.837 MB Rows returned: 13

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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 <= '2024-12-11 17:58:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-11 17:58:17') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 117 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	ref	PRIMARY,published,newsfeeds	published	1	const	16	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	myremos_j310.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	myremos_j310.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.17 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/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: 1.60 ms After last query: 2.38 ms Query memory: 0.042 MB Memory before query: 10.147 MB Rows returned: 5

SELECT f.*, AVG(v.value) AS vote_value, COUNT(v.value) AS vote_count, 0 AS active_feature, c.name 
  from jos_downloads_files AS f 
  INNER JOIN jos_downloads_containers AS c 
  ON f.containerid = c.id
 
  LEFT JOIN jos_downloads_log AS v 
  ON v.type=3 
  AND v.fileid=f.id 
  AND v.value != 0 
  WHERE f.published != 0 
  AND NOW() >= f.publish_from 
  AND f.publish_to >= NOW() 
  GROUP BY f.id 
  ORDER BY f.filedate DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	id	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using temporary; Using filesort
1	SIMPLE	f	ref	containerid,recommended,featured,opsystem	containerid	2	myremos_j310.c.id	1	Using index condition; Using where
1	SIMPLE	v	ref	userid,fileid,ipaddress	userid	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:141
20	BlackSheepResearch\aliro\database\ExtendedDatabase->SQLgetrows()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:150
19	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
18	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/File.php:865
17	BlackSheepResearch\Component\Remository\Site\Problems\File::newestFiles()	JROOT/components/com_remository/src/Modules/Multi.php:122
16	BlackSheepResearch\Component\Remository\Site\Modules\Multi->getFileSet()	JROOT/components/com_remository/views/multi/tmpl/default.php:146
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.59 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 10.203 MB Rows returned: 1

Duplicate queries: #23 #42 #43 #44 #45

SELECT NOW()

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	No tables used

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
21	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:72
20	BlackSheepResearch\Component\Remository\Site\Problems\File->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:157
19	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
18	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/File.php:865
17	BlackSheepResearch\Component\Remository\Site\Problems\File::newestFiles()	JROOT/components/com_remository/src/Modules/Multi.php:122
16	BlackSheepResearch\Component\Remository\Site\Modules\Multi->getFileSet()	JROOT/components/com_remository/views/multi/tmpl/default.php:146
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.49 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 10.224 MB Rows returned: 1

Duplicate queries: #23 #41 #43 #44 #45

SELECT NOW()

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	No tables used

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
21	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:72
20	BlackSheepResearch\Component\Remository\Site\Problems\File->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:157
19	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
18	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/File.php:865
17	BlackSheepResearch\Component\Remository\Site\Problems\File::newestFiles()	JROOT/components/com_remository/src/Modules/Multi.php:122
16	BlackSheepResearch\Component\Remository\Site\Modules\Multi->getFileSet()	JROOT/components/com_remository/views/multi/tmpl/default.php:146
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.48 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 10.242 MB Rows returned: 1

Duplicate queries: #23 #41 #42 #44 #45

SELECT NOW()

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	No tables used

Profile

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Executing	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
21	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:72
20	BlackSheepResearch\Component\Remository\Site\Problems\File->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:157
19	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
18	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/File.php:865
17	BlackSheepResearch\Component\Remository\Site\Problems\File::newestFiles()	JROOT/components/com_remository/src/Modules/Multi.php:122
16	BlackSheepResearch\Component\Remository\Site\Modules\Multi->getFileSet()	JROOT/components/com_remository/views/multi/tmpl/default.php:146
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.47 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 10.260 MB Rows returned: 1

Duplicate queries: #23 #41 #42 #43 #45

SELECT NOW()

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	No tables used

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
21	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:72
20	BlackSheepResearch\Component\Remository\Site\Problems\File->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:157
19	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
18	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/File.php:865
17	BlackSheepResearch\Component\Remository\Site\Problems\File::newestFiles()	JROOT/components/com_remository/src/Modules/Multi.php:122
16	BlackSheepResearch\Component\Remository\Site\Modules\Multi->getFileSet()	JROOT/components/com_remository/views/multi/tmpl/default.php:146
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.53 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 10.278 MB Rows returned: 1

Duplicate queries: #23 #41 #42 #43 #44

SELECT NOW()

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	No tables used

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
21	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/File.php:72
20	BlackSheepResearch\Component\Remository\Site\Problems\File->__construct()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:157
19	BlackSheepResearch\aliro\database\ExtendedDatabase->doSQLget()	JROOT/libraries/BlackSheepResearch/Utils.php:119
18	BlackSheepResearch\Utils::doSQLget()	JROOT/components/com_remository/src/Problems/File.php:865
17	BlackSheepResearch\Component\Remository\Site\Problems\File::newestFiles()	JROOT/components/com_remository/src/Modules/Multi.php:122
16	BlackSheepResearch\Component\Remository\Site\Modules\Multi->getFileSet()	JROOT/components/com_remository/views/multi/tmpl/default.php:146
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.64 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 10.253 MB Rows returned: 2

SELECT f.id, f.containerid, f.filetitle, f.realname 
  FROM jos_downloads_files AS f 
  INNER JOIN jos_downloads_files AS f2 
  ON f.containerid = f2.containerid 
  WHERE f2.id = 17

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f2	const	id,containerid,recommended,featured,opsystem	id	4	const	1
1	SIMPLE	f	ref	containerid,recommended,featured,opsystem	containerid	2	const	2

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
23	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/SEF.php:160
22	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->setFileInfo()	JROOT/components/com_remository/src/Problems/SEF.php:152
21	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getFileName()	JROOT/components/com_remository/src/Problems/SEF.php:390
20	BlackSheepResearch\Component\Remository\Site\Problems\SEF::create()	JROOT/components/com_remository/src/Problems/SEF.php:260
19	BlackSheepResearch\Component\Remository\Site\Problems\SEF::_()	JROOT/components/com_remository/src/Problems/Repository.php:253
18	BlackSheepResearch\Component\Remository\Site\Problems\Repository->RemositoryBasicFunctionURL()	JROOT/components/com_remository/src/Problems/Repository.php:187
17	BlackSheepResearch\Component\Remository\Site\Problems\Repository->RemositoryFunctionURL()	JROOT/components/com_remository/views/multi/tmpl/default.php:53
16	Joomla\CMS\MVC\View\HtmlView->{closure}()	JROOT/components/com_remository/views/multi/tmpl/default.php:157
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.79 ms Query memory: 0.026 MB Memory before query: 10.287 MB Rows returned: 1

SELECT f.id, f.containerid, f.filetitle, f.realname 
  FROM jos_downloads_files AS f 
  INNER JOIN jos_downloads_files AS f2 
  ON f.containerid = f2.containerid 
  WHERE f2.id = 15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f2	const	id,containerid,recommended,featured,opsystem	id	4	const	1
1	SIMPLE	f	ref	containerid,recommended,featured,opsystem	containerid	2	const	1

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/BlackSheepResearch/aliro/database/ExtendedDatabase.php:63
23	BlackSheepResearch\aliro\database\ExtendedDatabase->__call()	JROOT/components/com_remository/src/Problems/SEF.php:160
22	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->setFileInfo()	JROOT/components/com_remository/src/Problems/SEF.php:152
21	BlackSheepResearch\Component\Remository\Site\Problems\sef_remository_data->getFileName()	JROOT/components/com_remository/src/Problems/SEF.php:390
20	BlackSheepResearch\Component\Remository\Site\Problems\SEF::create()	JROOT/components/com_remository/src/Problems/SEF.php:260
19	BlackSheepResearch\Component\Remository\Site\Problems\SEF::_()	JROOT/components/com_remository/src/Problems/Repository.php:253
18	BlackSheepResearch\Component\Remository\Site\Problems\Repository->RemositoryBasicFunctionURL()	JROOT/components/com_remository/src/Problems/Repository.php:187
17	BlackSheepResearch\Component\Remository\Site\Problems\Repository->RemositoryFunctionURL()	JROOT/components/com_remository/views/multi/tmpl/default.php:53
16	Joomla\CMS\MVC\View\HtmlView->{closure}()	JROOT/components/com_remository/views/multi/tmpl/default.php:157
15	include JROOT/components/com_remository/views/multi/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_remository/src/Modules/Multi.php:51
12	BlackSheepResearch\Component\Remository\Site\Modules\Multi->showFileList()	JROOT/components/com_remository/src/Modules/ModuleSkeleton.php:59
11	BlackSheepResearch\Component\Remository\Site\Modules\ModuleSkeleton->runModule()	JROOT/modules/mod_remositorymulti/mod_remositorymulti.php:22
10	include JROOT/modules/mod_remositorymulti/mod_remositorymulti.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.33 ms After last query: 1.93 ms Query memory: 0.022 MB Memory before query: 10.274 MB Rows returned: 0

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `jos_contentitem_tag_map` AS `m`

  INNER JOIN `jos_tags` AS `t` 
  ON `tag_id` = t.id

  INNER JOIN `jos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1,5) 
  AND `t`.`published` = 1  
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0) 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-12-11 17:58:17') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2024-12-11 17:58:17')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 8

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_core_content_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	myremos_j310.m.tag_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	myremos_j310.m.core_content_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
14	ModTagsPopularHelper::getList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:595
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
10	include JROOT/modules/mod_tags_popular