Ideal Directory :: Uninstallation

Uninstallation
Prev	Chapter 1. Introduction and installation	Next

Uninstallation

You can uninstall the component just like any other Joomla!™ component. In your site's back-end, just go to Extensions → Manage → Manage, select Ideal Directory and click on the Uninstall button.

	Important
	This will completely remove Ideal Directory including all plugins, modules, listing information and all settings.

Prev	Up	Next
Requesting support and reporting bugs	Home	Chapter 2. The component

JoomlaFit.com and this site is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1574360607,
                "last": 1574360607,
                "now": 1574360607
            },
            "token": "cYdgKb0ugjEnVyrN9ohPZZpaUSyp9gtN"
        },
        "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

Memory Usage

Database Queries

46 Queries Logged 119.24 ms

16 duplicate found!

2 duplicates: #8 #9

2 duplicates: #12 #13

4 duplicates: #18 #19 #41 #42

2 duplicates: #21 #22

2 duplicates: #23 #24

2 duplicates: #34 #39

2 duplicates: #36 #40

Query Time: 0.25 ms Query memory: 0.025 MB Memory before query: 3.525 MB Rows returned: 0

SELECT `data`

  FROM `jfit_session`

  WHERE `session_id` = '6bfbfb198fbfee2e002eb834215d970c'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.13 ms After last query: 1.59 ms Query memory: 0.022 MB Memory before query: 3.690 MB Rows returned: 0

SELECT `session_id`

  FROM `jfit_session`

  WHERE `session_id` = '6bfbfb198fbfee2e002eb834215d970c' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 71.57 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 3.695 MB

INSERT INTO `jfit_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('6bfbfb198fbfee2e002eb834215d970c', 1, 1574360607, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jfit_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6bfbfb198fbfee2e002eb834215d970c', 1, 1574360607, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
update	0.09 ms
Waiting for query cache lock	0.01 ms
update	0.00 ms
end	0.00 ms
query end	71.37 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.65 ms After last query: 4.15 ms Query memory: 0.035 MB Memory before query: 3.906 MB Rows returned: 40

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

  FROM `jfit_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 3.75 ms Query memory: 0.023 MB Memory before query: 4.114 MB Rows returned: 7

SELECT id, rules

  FROM `jfit_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.26 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.127 MB Rows returned: 2

SELECT b.id

  FROM jfit_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.26 ms After last query: 1.01 ms Query memory: 0.034 MB Memory before query: 4.193 MB Rows returned: 103

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

  FROM jfit_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	160	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.96 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.57 ms After last query: 17.56 ms Query memory: 0.024 MB Memory before query: 5.376 MB Rows returned: 0

Duplicate queries: #9

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_admintools'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 7.33 ms Query memory: 0.024 MB Memory before query: 5.672 MB Rows returned: 0

Duplicate queries: #8

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_admintools'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.33 ms Query memory: 0.027 MB Memory before query: 5.688 MB Rows returned: 1

SELECT `value`

  FROM `jfit_admintools_storage`

  WHERE `key` = 'cparams'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	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	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 4.06 ms Query memory: 0.024 MB Memory before query: 5.943 MB Rows returned: 0

SELECT *

  FROM `jfit_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 16.00 ms Query memory: 0.023 MB Memory before query: 6.748 MB Rows returned: 0

Duplicate queries: #13

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_ars'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/plugins/system/arsjed/arsjed.php:53
7	plgSystemArsjed->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.79 ms Query memory: 0.023 MB Memory before query: 6.767 MB Rows returned: 0

Duplicate queries: #12

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_ars'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/plugins/system/arsjed/arsjed.php:53
7	plgSystemArsjed->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 22.65 ms Query memory: 0.023 MB Memory before query: 7.593 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.41 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.64 ms Query memory: 0.024 MB Memory before query: 7.627 MB Rows returned: 0

SELECT *

  FROM `jfit_admintools_ipautoban`

  WHERE `ip` = '18.204.48.199'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.633 MB Rows returned: 0

SELECT `ip`

  FROM `jfit_admintools_ipblock`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:139
11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:33
10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 3.57 ms Query memory: 0.024 MB Memory before query: 7.654 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `jfit_admintools_redirects`

  WHERE ((`dest` = 'documentation/ideal-directory/uninstallation') OR (`dest` = 'documentation/ideal-directory/uninstallation') OR ('documentation/ideal-directory/uninstallation' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1767
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 7.675 MB Rows returned: 0

Duplicate queries: #19 #41 #42

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_akeebasubs'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/aslogoutuser/aslogoutuser.php:86
8	plgSystemAslogoutuser->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 1.04 ms Query memory: 0.024 MB Memory before query: 7.693 MB Rows returned: 0

Duplicate queries: #18 #41 #42

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_akeebasubs'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/aslogoutuser/aslogoutuser.php:86
8	plgSystemAslogoutuser->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 5.22 ms Query memory: 0.039 MB Memory before query: 8.030 MB Rows returned: 21

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

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 7.72 ms Query memory: 0.024 MB Memory before query: 8.424 MB Rows returned: 1

Duplicate queries: #22

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_ats'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/components/com_ats/router.php:16
7	require_once JROOT/components/com_ats/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 1.01 ms Query memory: 0.024 MB Memory before query: 8.443 MB Rows returned: 1

Duplicate queries: #21

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_ats'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/components/com_ats/router.php:16
7	require_once JROOT/components/com_ats/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 6.16 ms Query memory: 0.024 MB Memory before query: 8.707 MB Rows returned: 0

Duplicate queries: #24

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_docimport'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/components/com_docimport/router.php:20
7	require_once JROOT/components/com_docimport/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 1.03 ms Query memory: 0.024 MB Memory before query: 8.726 MB Rows returned: 0

Duplicate queries: #23

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_docimport'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
11	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
10	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
9	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
8	FOF30\Container\Container::getInstance()	JROOT/components/com_docimport/router.php:20
7	require_once JROOT/components/com_docimport/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 7.03 ms Query memory: 0.024 MB Memory before query: 9.079 MB Rows returned: 1

SELECT `docimport_category_id` AS `id`,`slug`

  FROM `jfit_docimport_categories`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_docimport/Helper/Routing.php:557
12	Akeeba\DocImport\Site\Helper\Routing::initCategoryAndArticleCaches()	JROOT/components/com_docimport/Helper/Routing.php:512
11	Akeeba\DocImport\Site\Helper\Routing::getArticleFromSlug()	JROOT/components/com_docimport/router.php:358
10	docimportParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 9.085 MB Rows returned: 23

SELECT `docimport_article_id` AS `id`,`slug`,`docimport_category_id` AS `catid`

  FROM `jfit_docimport_articles`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_docimport/Helper/Routing.php:565
12	Akeeba\DocImport\Site\Helper\Routing::initCategoryAndArticleCaches()	JROOT/components/com_docimport/Helper/Routing.php:512
11	Akeeba\DocImport\Site\Helper\Routing::getArticleFromSlug()	JROOT/components/com_docimport/router.php:358
10	docimportParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 9.098 MB Rows returned: 1

SELECT *

  FROM `jfit_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_docimport') 
  AND `view` IN('','Article') 
  AND `task` IN('','Article.') 
  AND `enabled` = '1'

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
Creating sort index	0.04 ms
end	0.01 ms
removing tmp table	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:87
10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:145
8	plgSystemAdmintools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 1.19 ms Query memory: 0.025 MB Memory before query: 9.151 MB Rows returned: 1

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

  FROM `jfit_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 25.76 ms After last query: 0.23 ms Query memory: 0.005 MB Memory before query: 9.141 MB

UPDATE `jfit_extensions`

  SET `params` = '{\"mediaversion\":\"3de2419f46ff0a2ca24159ef56b4600d\"}'

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.06 ms
updating	0.11 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	25.36 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 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:1129
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 3.61 ms Query memory: 0.025 MB Memory before query: 9.310 MB Rows returned: 1

SELECT *

  FROM jfit_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.34 ms Query memory: 0.021 MB Memory before query: 9.321 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jfit_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomlafi_joomla.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.21 ms After last query: 82.22 ms Query memory: 0.034 MB Memory before query: 10.572 MB Rows returned: 146

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.77 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
20	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/fof30/Model/DataModel.php:736
19	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
18	FOF30\Model\DataModel->__construct()	JROOT/administrator/components/com_docimport/Model/Articles.php:61
17	Akeeba\DocImport\Admin\Model\Articles->__construct()	JROOT/components/com_docimport/Model/Articles.php:20
16	Akeeba\DocImport\Site\Model\Articles->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:557
15	FOF30\Factory\BasicFactory->createModel()	JROOT/libraries/fof30/Factory/BasicFactory.php:145
14	FOF30\Factory\BasicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 10.608 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `jfit_docimport_articles`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
19	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
18	FOF30\Model\DataModel->__construct()	JROOT/administrator/components/com_docimport/Model/Articles.php:61
17	Akeeba\DocImport\Admin\Model\Articles->__construct()	JROOT/components/com_docimport/Model/Articles.php:20
16	Akeeba\DocImport\Site\Model\Articles->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:557
15	FOF30\Factory\BasicFactory->createModel()	JROOT/libraries/fof30/Factory/BasicFactory.php:145
14	FOF30\Factory\BasicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 5.11 ms Query memory: 0.029 MB Memory before query: 10.853 MB Rows returned: 1

Duplicate queries: #39

SELECT *

  FROM `jfit_docimport_articles`

  WHERE `docimport_article_id` = '121'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	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	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof30/Model/DataModel.php:2537
13	FOF30\Model\DataModel->find()	JROOT/libraries/fof30/Controller/DataController.php:1591
12	FOF30\Controller\DataController->getIDsFromRequest()	JROOT/components/com_docimport/Controller/Article.php:27
11	Akeeba\DocImport\Site\Controller\Article->onBeforeRead()	JROOT/libraries/fof30/Controller/Controller.php:1023
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:386
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 10.61 ms Query memory: 0.034 MB Memory before query: 10.996 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `jfit_docimport_categories`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.26 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
23	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
22	FOF30\Model\DataModel->__construct()	JROOT/administrator/components/com_docimport/Model/Categories.php:55
21	Akeeba\DocImport\Admin\Model\Categories->__construct()	JROOT/components/com_docimport/Model/Categories.php:20
20	Akeeba\DocImport\Site\Model\Categories->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:557
19	FOF30\Factory\BasicFactory->createModel()	JROOT/libraries/fof30/Factory/BasicFactory.php:145
18	FOF30\Factory\BasicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
17	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
16	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
15	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
14	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
13	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
12	FOF30\Model\DataModel->__get()	JROOT/components/com_docimport/Controller/Article.php:36
11	Akeeba\DocImport\Site\Controller\Article->onBeforeRead()	JROOT/libraries/fof30/Controller/Controller.php:1023
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:386
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 4.66 ms Query memory: 0.033 MB Memory before query: 11.215 MB Rows returned: 1

Duplicate queries: #40

SELECT *

  FROM jfit_docimport_categories

  WHERE `enabled` = '1' 
  AND (`docimport_category_id` = '1')

  ORDER BY `docimport_category_id` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_docimport_categories	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
19	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
18	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
17	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
16	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
15	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
14	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
13	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
12	FOF30\Model\DataModel->__get()	JROOT/components/com_docimport/Controller/Article.php:36
11	Akeeba\DocImport\Site\Controller\Article->onBeforeRead()	JROOT/libraries/fof30/Controller/Controller.php:1023
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:386
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.63 ms Query memory: 0.030 MB Memory before query: 11.243 MB Rows returned: 1

SELECT `params`

  FROM `jfit_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
27	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Params/Params.php:56
26	FOF30\Params\Params->reload()	JROOT/libraries/fof30/Params/Params.php:41
25	FOF30\Params\Params->__construct()	JROOT/libraries/fof30/Container/Container.php:507
24	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:112
23	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
22	FOF30\Container\ContainerBase->__get()	JROOT/administrator/components/com_docimport/Model/Categories.php:155
21	Akeeba\DocImport\Admin\Model\Categories->getStatusFor()	JROOT/administrator/components/com_docimport/Model/Categories.php:137
20	Akeeba\DocImport\Admin\Model\Categories->onAfterGetItemsArray()	JROOT/libraries/fof30/Model/Model.php:543
19	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1817
18	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
17	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
16	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
15	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
14	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
13	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
12	FOF30\Model\DataModel->__get()	JROOT/components/com_docimport/Controller/Article.php:36
11	Akeeba\DocImport\Site\Controller\Article->onBeforeRead()	JROOT/libraries/fof30/Controller/Controller.php:1023
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:386
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 18.58 ms Query memory: 0.032 MB Memory before query: 11.819 MB Rows returned: 40

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

  FROM `jfit_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_akeebasubs','com_ars','com_associations','com_ats','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docimport','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.26 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.33 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
22	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:566
17	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/View/DataView/Raw.php:109
16	FOF30\View\DataView\Raw->getPermissions()	JROOT/libraries/fof30/View/DataView/Raw.php:57
15	FOF30\View\DataView\Raw->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:577
14	FOF30\Factory\BasicFactory->createView()	JROOT/libraries/fof30/Factory/BasicFactory.php:211
13	FOF30\Factory\BasicFactory->view()	JROOT/libraries/fof30/Controller/DataController.php:384
12	FOF30\Controller\DataController->getView()	JROOT/libraries/fof30/Controller/Controller.php:456
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 1.23 ms Query memory: 0.031 MB Memory before query: 11.890 MB Rows returned: 1

Duplicate queries: #34

SELECT *

  FROM `jfit_docimport_articles`

  WHERE `docimport_article_id` = '121'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof30/Model/DataModel.php:2537
17	FOF30\Model\DataModel->find()	JROOT/libraries/fof30/Model/DataModel.php:2414
16	FOF30\Model\DataModel->findOrFail()	JROOT/libraries/fof30/View/DataView/Raw.php:367
15	FOF30\View\DataView\Raw->onBeforeRead()	JROOT/components/com_docimport/View/Article/Html.php:25
14	Akeeba\DocImport\Site\View\Article\Html->onBeforeRead()	JROOT/libraries/fof30/View/View.php:1198
13	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/View.php:559
12	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 1.79 ms Query memory: 0.034 MB Memory before query: 11.918 MB Rows returned: 1

Duplicate queries: #36

SELECT *

  FROM jfit_docimport_categories

  WHERE `enabled` = '1' 
  AND (`docimport_category_id` = '1')

  ORDER BY `docimport_category_id` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_docimport_categories	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	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	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
22	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
21	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
20	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
19	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
18	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
17	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
16	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
15	FOF30\Model\DataModel->__get()	JROOT/components/com_docimport/View/Article/Html.php:33
14	Akeeba\DocImport\Site\View\Article\Html->onBeforeRead()	JROOT/libraries/fof30/View/View.php:1198
13	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/View.php:559
12	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 30.13 ms Query memory: 0.031 MB Memory before query: 12.824 MB Rows returned: 0

Duplicate queries: #18 #19 #42

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_akeebasubs'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.23 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
30	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
29	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
28	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
27	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
26	FOF30\Container\Container::getInstance()	JROOT/plugins/content/astimedrelease/astimedrelease.php:122
25	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
24	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
23	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
22	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_docimport/View/Article/tmpl/item.php:19
17	include JROOT/components/com_docimport/View/Article/tmpl/item.php	JROOT/libraries/fof30/View/View.php:1030
16	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
15	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
14	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
13	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
12	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.93 ms Query memory: 0.031 MB Memory before query: 12.847 MB Rows returned: 0

Duplicate queries: #18 #19 #41

SELECT `manifest_cache`

  FROM `jfit_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_akeebasubs'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
30	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
29	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
28	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
27	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
26	FOF30\Container\Container::getInstance()	JROOT/plugins/content/astimedrelease/astimedrelease.php:122
25	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
24	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
23	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
22	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_docimport/View/Article/tmpl/item.php:19
17	include JROOT/components/com_docimport/View/Article/tmpl/item.php	JROOT/libraries/fof30/View/View.php:1030
16	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
15	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
14	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
13	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
12	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.22 ms After last query: 1.45 ms Query memory: 0.044 MB Memory before query: 12.945 MB Rows returned: 33

SHOW FULL COLUMNS 
  FROM `jfit_akeebasubs_levels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
30	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
29	FOF30\Model\DataModel->__construct()	JROOT/administrator/components/com_akeebasubs/Model/Levels.php:92
28	Akeeba\Subscriptions\Admin\Model\Levels->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:557
27	FOF30\Factory\BasicFactory->createModel()	JROOT/libraries/fof30/Factory/BasicFactory.php:145
26	FOF30\Factory\BasicFactory->model()	JROOT/plugins/content/astimedrelease/astimedrelease.php:123
25	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
24	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
23	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
22	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_docimport/View/Article/tmpl/item.php:19
17	include JROOT/components/com_docimport/View/Article/tmpl/item.php	JROOT/libraries/fof30/View/View.php:1030
16	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
15	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
14	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
13	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
12	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 1.56 ms Query memory: 0.047 MB Memory before query: 13.029 MB Rows returned: 6

SELECT *

  FROM jfit_akeebasubs_levels

  ORDER BY `akeebasubs_level_id` ASC,akeebasubs_level_id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jfit_akeebasubs_levels	index	NULL	PRIMARY	8	NULL	6	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
29	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
28	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
27	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
26	FOF30\Model\DataModel->get()	JROOT/plugins/content/astimedrelease/astimedrelease.php:124
25	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
24	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
23	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
22	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_docimport/View/Article/tmpl/item.php:19
17	include JROOT/components/com_docimport/View/Article/tmpl/item.php	JROOT/libraries/fof30/View/View.php:1030
16	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
15	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
14	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
13	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
12	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
11	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:484
10	FOF30\Controller\DataController->read()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_docimport/docimport.php:16
6	require_once JROOT/components/com_docimport/docimport.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.18 ms After last query: 12.64 ms Query memory: 0.028 MB Memory before query: 13.604 MB Rows returned: 9

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

  FROM jfit_modules AS m

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

  LEFT JOIN jfit_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-11-21 18:23:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-21 18:23:27') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 134 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	13	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomlafi_joomla.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomlafi_joomla.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.06 ms
statistics	0.15 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/masterbootstrap/includes/params.php:14
8	include JROOT/templates/masterbootstrap/includes/params.php	JROOT/templates/masterbootstrap/index.php:12
7	require JROOT/templates/masterbootstrap/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 16.26 ms Query memory: 0.023 MB Memory before query: 14.068 MB Rows returned: 0

SELECT `value`

  FROM `jfit_admintools_storage`

  WHERE `key` = 'criticalfiles'

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/admintools/feature/criticalfiles.php:205
10	AtsystemFeatureCriticalfiles->load()	JROOT/plugins/system/admintools/feature/criticalfiles.php:31
9	AtsystemFeatureCriticalfiles->onAfterRender()	JROOT/plugins/system/admintools/admintools/main.php:710
8	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:171
7	plgSystemAdmintools->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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:202
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.]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

12 × SELECT `manifest_cache` 
  FROM `jfit_extensions`

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

2 × SELECT `value` 
  FROM `jfit_admintools_storage`

2 × SELECT * 
  FROM jfit_docimport_categories

2 × SELECT * 
  FROM `jfit_docimport_articles`

1 × SELECT `data` 
  FROM `jfit_session`

1 × SELECT `docimport_article_id` AS `id`,`slug`,`docimport_category_id` AS `catid` 
  FROM `jfit_docimport_articles

1 × SELECT * 
  FROM jfit_akeebasubs_levels

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jfit_assets`

1 × SELECT `params` 
  FROM `jfit_extensions`

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

```
1 × SELECT * 
  FROM jfit_languages
```

1 × SELECT * 
  FROM `jfit_admintools_wafblacklists`

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

1 × SELECT `docimport_category_id` AS `id`,`slug` 
  FROM `jfit_docimport_categories

1 × SELECT `session_id` 
  FROM `jfit_session`

1 × SELECT `source`,`keepurlparams` 
  FROM `jfit_admintools_redirects`

1 × SELECT `ip` 
  FROM `jfit_admintools_ipblock

1 × SELECT * 
  FROM `jfit_admintools_ipautoban`

1 × SELECT * 
  FROM `jfit_admintools_wafexceptions`

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

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

1 × SELECT id, rules 
  FROM `jfit_viewlevels

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

OTHER Tables:

1 × INSERT INTO `jfit_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('6bfbfb198fbfee2e002eb834215d970c', 1, 1574360607, 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `jfit_extensions` 
  SET `params` = '{\"mediaversion\":\"3de2419f46ff0a2ca24159ef56b4600d\"}'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `jfit_docimport_articles

1 × SHOW FULL COLUMNS 
  FROM `jfit_docimport_categories

1 × SHOW FULL COLUMNS 
  FROM `jfit_akeebasubs_levels