Joomla Fit - Custom Made Extensions

Ideal Directory is a Joomla!™ extension which allows you to create a directory of business on your site. You'll be able to create a structured directory with all the business/location information and your website visitors will be able to either navigate using the directory or the interactive map.

$ 75 Ideal Directory Core - 1 Year

$ 250 Ideal Directory Core - 5 Years

$ 99 Ideal Directory Pro - 6 Months

$ 149 Ideal Directory Pro - 1 Year

$ 499 Ideal Directory Pro - 5 Years

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": 1566039283,
                "last": 1566039283,
                "now": 1566039283
            },
            "token": "4imV0Lt4V82Yx6HHJt9GjEHA18UopoFH"
        },
        "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

40 Queries Logged 200.76 ms

12 duplicate found!

2 duplicates: #8 #9

2 duplicates: #12 #13

4 duplicates: #18 #19 #37 #38

2 duplicates: #21 #22

2 duplicates: #23 #24

Query Time: 0.40 ms Query memory: 0.025 MB Memory before query: 3.524 MB Rows returned: 0

SELECT `data`

  FROM `jfit_session`

  WHERE `session_id` = 'd8f10b87207727fa1e49ae843d1de2c0'

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.07 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 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.15 ms After last query: 1.73 ms Query memory: 0.022 MB Memory before query: 3.689 MB Rows returned: 0

SELECT `session_id`

  FROM `jfit_session`

  WHERE `session_id` = 'd8f10b87207727fa1e49ae843d1de2c0' 
  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.01 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.01 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: 20.00 ms After last query: 0.10 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 
('d8f10b87207727fa1e49ae843d1de2c0', 1, 1566039283, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jfit_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('d8f10b87207727fa1e49ae843d1de2c0', 1, 1566039283, 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.01 ms
update	0.10 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	19.73 ms
closing tables	0.02 ms
freeing items	0.02 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.84 ms After last query: 5.00 ms Query memory: 0.035 MB Memory before query: 3.905 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.08 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.11 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.32 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/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.19 ms After last query: 3.07 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.00 ms
statistics	0.01 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
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.24 ms After last query: 0.10 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.00 ms
checking permissions	0.00 ms
Opening tables	0.02 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.00 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: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.11 ms After last query: 0.88 ms Query memory: 0.034 MB Memory before query: 4.192 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.05 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.84 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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.52 ms After last query: 14.38 ms Query memory: 0.024 MB Memory before query: 5.375 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.00 ms
Sending data	0.20 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: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.34 ms After last query: 6.00 ms Query memory: 0.024 MB Memory before query: 5.671 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.00 ms
optimizing	0.01 ms
statistics	0.04 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
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.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.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.27 ms After last query: 4.33 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.05 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.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 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
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.51 ms After last query: 15.07 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.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 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
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.87 ms Query memory: 0.023 MB Memory before query: 6.766 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.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.17 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.80 ms After last query: 22.25 ms Query memory: 0.023 MB Memory before query: 7.592 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.07 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.42 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	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: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.25 ms After last query: 0.69 ms Query memory: 0.024 MB Memory before query: 7.627 MB Rows returned: 0

SELECT *

  FROM `jfit_admintools_ipautoban`

  WHERE `ip` = '18.210.27.34'

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 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
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.14 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 7.632 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.02 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.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
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.49 ms After last query: 3.71 ms Query memory: 0.024 MB Memory before query: 7.654 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `jfit_admintools_redirects`

  WHERE ((`dest` = 'component/akeebasubs/levels') OR (`dest` = 'component/akeebasubs/levels') OR ('component/akeebasubs/levels' 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.11 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.03 ms
preparing	0.02 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.00 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.45 ms After last query: 0.33 ms Query memory: 0.024 MB Memory before query: 7.674 MB Rows returned: 0

Duplicate queries: #19 #37 #38

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.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.21 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: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.32 ms After last query: 0.90 ms Query memory: 0.024 MB Memory before query: 7.693 MB Rows returned: 0

Duplicate queries: #18 #37 #38

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.15 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/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.79 ms After last query: 5.00 ms Query memory: 0.039 MB Memory before query: 8.029 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.08 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 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.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.42 ms After last query: 5.57 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.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.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.20 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/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.35 ms After last query: 0.84 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.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.17 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
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.34 ms After last query: 4.62 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.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.16 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/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.31 ms After last query: 0.76 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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/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.42 ms After last query: 6.49 ms Query memory: 0.026 MB Memory before query: 8.945 MB Rows returned: 1

SELECT *

  FROM `jfit_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_akeebasubs') 
  AND `view` IN('','levels') 
  AND `task` IN('','levels.') 
  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.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.07 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	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
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.26 ms After last query: 1.00 ms Query memory: 0.025 MB Memory before query: 9.060 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.03 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.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 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: 71.24 ms After last query: 0.21 ms Query memory: 0.005 MB Memory before query: 9.050 MB

UPDATE `jfit_extensions`

  SET `params` = '{\"mediaversion\":\"4ceafb93f05dc78f1b9c6897235d03dc\"}'

  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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.06 ms
updating	0.05 ms
end	0.01 ms
query end	70.95 ms
closing tables	0.02 ms
freeing items	0.02 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.47 ms After last query: 2.94 ms Query memory: 0.025 MB Memory before query: 9.224 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.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.08 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.40 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 9.233 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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.09 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
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: 0.37 ms After last query: 7.24 ms Query memory: 0.025 MB Memory before query: 9.456 MB Rows returned: 1

SELECT `params`

  FROM `jfit_extensions`

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

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.04 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.11 ms
preparing	0.02 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Params/Params.php:56
14	FOF30\Params\Params->reload()	JROOT/libraries/fof30/Params/Params.php:41
13	FOF30\Params\Params->__construct()	JROOT/libraries/fof30/Container/Container.php:507
12	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:112
11	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
10	FOF30\Container\ContainerBase->__get()	JROOT/components/com_akeebasubs/Dispatcher/Dispatcher.php:26
9	Akeeba\Subscriptions\Site\Dispatcher\Dispatcher->onBeforeDispatch()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:249
8	FOF30\Dispatcher\Dispatcher->triggerEvent()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:141
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.05 ms After last query: 19.72 ms Query memory: 0.034 MB Memory before query: 10.757 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.01 ms
Opening tables	0.06 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.63 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 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_akeebasubs/Model/Levels.php:92
17	Akeeba\Subscriptions\Admin\Model\Levels->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:557
16	FOF30\Factory\BasicFactory->createModel()	JROOT/libraries/fof30/Factory/BasicFactory.php:145
15	FOF30\Factory\BasicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
14	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
13	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
12	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
11	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.21 ms After last query: 0.15 ms Query memory: 0.038 MB Memory before query: 10.785 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.30 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.04 ms
checking permissions	0.05 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.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
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.11 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_akeebasubs/Model/Levels.php:92
17	Akeeba\Subscriptions\Admin\Model\Levels->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:557
16	FOF30\Factory\BasicFactory->createModel()	JROOT/libraries/fof30/Factory/BasicFactory.php:145
15	FOF30\Factory\BasicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
14	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
13	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
12	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
11	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.06 ms After last query: 53.43 ms Query memory: 0.034 MB Memory before query: 11.768 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.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.25 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.32 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:566
18	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/View/DataView/Raw.php:109
17	FOF30\View\DataView\Raw->getPermissions()	JROOT/libraries/fof30/View/DataView/Raw.php:57
16	FOF30\View\DataView\Raw->__construct()	JROOT/libraries/fof30/Factory/BasicFactory.php:577
15	FOF30\Factory\BasicFactory->createView()	JROOT/libraries/fof30/Factory/BasicFactory.php:201
14	FOF30\Factory\BasicFactory->view()	JROOT/libraries/fof30/Controller/DataController.php:384
13	FOF30\Controller\DataController->getView()	JROOT/libraries/fof30/Controller/Controller.php:456
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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: 91.42 ms After last query: 22.78 ms Query memory: 0.044 MB Memory before query: 12.106 MB Rows returned: 6

SELECT *

  FROM jfit_akeebasubs_levels

  WHERE `access` IN ('1','1','5') 
  AND (`enabled` = '1')

  ORDER BY `ordering` ASC,ordering ASC

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	91.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 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/View/DataView/Raw.php:269
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/components/com_akeebasubs/View/Levels/Html.php:144
15	Akeeba\Subscriptions\Site\View\Levels\Html->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1198
14	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/View.php:559
13	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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: 2.38 ms Query memory: 0.026 MB Memory before query: 12.153 MB Rows returned: 1

SELECT COUNT(*)

  FROM jfit_akeebasubs_levels

  WHERE `access` IN ('1','1','5') 
  AND (`enabled` = '1')

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Model/DataModel.php:1709
17	FOF30\Model\DataModel->count()	JROOT/libraries/fof30/View/DataView/Raw.php:270
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/components/com_akeebasubs/View/Levels/Html.php:144
15	Akeeba\Subscriptions\Site\View\Levels\Html->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1198
14	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/View.php:559
13	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.08 ms After last query: 75.30 ms Query memory: 0.033 MB Memory before query: 12.828 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-08-17 10:54:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-17 10:54:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 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.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.35 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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
22	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
21	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
20	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/fof30/Template/Template.php:631
19	FOF30\Template\Template->loadPosition()	JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php:19
18	include JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php	JROOT/libraries/fof30/View/View.php:1030
17	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
16	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
15	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
14	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
13	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.67 ms After last query: 14.70 ms Query memory: 0.031 MB Memory before query: 13.138 MB Rows returned: 0

Duplicate queries: #18 #19 #38

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.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.11 ms
preparing	0.03 ms
executing	0.01 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.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
31	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
30	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
29	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
28	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
27	FOF30\Container\Container::getInstance()	JROOT/plugins/content/astimedrelease/astimedrelease.php:122
26	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
25	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
24	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
23	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
22	JHtmlContent::prepare()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php:70
18	include JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php	JROOT/libraries/fof30/View/View.php:1030
17	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
16	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
15	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
14	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
13	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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: 1.03 ms Query memory: 0.031 MB Memory before query: 13.162 MB Rows returned: 0

Duplicate queries: #18 #19 #37

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.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.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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
31	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
30	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
29	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
28	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
27	FOF30\Container\Container::getInstance()	JROOT/plugins/content/astimedrelease/astimedrelease.php:122
26	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
25	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
24	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
23	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
22	JHtmlContent::prepare()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php:70
18	include JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php	JROOT/libraries/fof30/View/View.php:1030
17	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
16	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
15	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
14	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
13	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.33 ms After last query: 1.77 ms Query memory: 0.047 MB Memory before query: 13.187 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.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.12 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
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/plugins/content/astimedrelease/astimedrelease.php:124
26	plgContentAstimedrelease->initialiseArrays()	JROOT/plugins/content/astimedrelease/astimedrelease.php:67
25	plgContentAstimedrelease->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
24	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
23	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
22	JHtmlContent::prepare()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php:70
18	include JROOT/components/com_akeebasubs/View/Levels/tmpl/default.php	JROOT/libraries/fof30/View/View.php:1030
17	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1005
16	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:720
15	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
14	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/View.php:571
13	FOF30\View\View->display()	JROOT/libraries/fof30/Controller/Controller.php:546
12	FOF30\Controller\Controller->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
10	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
9	FOF30\Controller\DataController->execute()	JROOT/administrator/components/com_akeebasubs/Controller/Mixin/PredefinedTaskList.php:41
8	Akeeba\Subscriptions\Site\Controller\Levels->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_akeebasubs/akeebasubs.php:16
6	require_once JROOT/components/com_akeebasubs/akeebasubs.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.41 ms After last query: 30.87 ms Query memory: 0.023 MB Memory before query: 14.242 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.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.01 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
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.]

26 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 * 
  FROM jfit_akeebasubs_levels

2 × SELECT `value` 
  FROM `jfit_admintools_storage`

1 × SELECT `data` 
  FROM `jfit_session`

1 × SELECT * 
  FROM `jfit_admintools_wafblacklists`

1 × SELECT COUNT(*) 
  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 `ip` 
  FROM `jfit_admintools_ipblock

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 `source`,`keepurlparams` 
  FROM `jfit_admintools_redirects`

1 × SELECT `session_id` 
  FROM `jfit_session`

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  ('d8f10b87207727fa1e49ae843d1de2c0', 1, 1566039283, 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `jfit_extensions` 
  SET `params` = '{\"mediaversion\":\"4ceafb93f05dc78f1b9c6897235d03dc\"}'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `jfit_akeebasubs_levels