FAQ - Relite Specialty Shop

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1615029138,
                "last": 1615029138,
                "now": 1615029138
            },
            "token": "2o9qfkmuNzRPlVCHZl6dilxGonqdTXFQ"
        },
        "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
        },
        "starttime": "2021-03-06 11:12:18",
        "wb_sh404sef_404_redirect_message": null
    }
}

Profile Information

Time

Memory

Time: 14.11 ms / 14.11 ms Memory: 2.147 MB / 2.41 MB Application: afterLoad

Time: 86.87 ms / 100.98 ms Memory: 10.665 MB / 13.08 MB Application: afterInitialise

Time: 15.92 ms / 116.90 ms Memory: 1.401 MB / 14.48 MB Application: afterRoute

Time: 0.61 ms / 117.51 ms Memory: 0.037 MB / 14.52 MB Application: beforeRenderComponent com_fsf

Time: 54.31 ms / 171.82 ms Memory: 3.446 MB / 17.96 MB Application: afterRenderComponent com_fsf

Time: 6.55 ms / 178.37 ms Memory: 0.759 MB / 18.72 MB Application: afterDispatch

Time: 46.31 ms / 224.68 ms Memory: 6.753 MB / 25.48 MB Application: Before Access::preloadComponents (all components)

Time: 1.57 ms / 226.25 ms Memory: 0.148 MB / 25.62 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 226.29 ms Memory: 0.000 MB / 25.62 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.49 ms / 226.78 ms Memory: 0.046 MB / 25.66 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.05 ms / 226.84 ms Memory: 0.001 MB / 25.66 MB Application: Before Access::getAssetRules (id:274 name:com_virtuemart)

Time: 0.02 ms / 226.85 ms Memory: 0.003 MB / 25.67 MB Application: After Access::getAssetRules (id:274 name:com_virtuemart)

Time: 56.29 ms / 283.14 ms Memory: 1.781 MB / 27.45 MB Application: beforeRenderModule mod_custom (footer)

Time: 0.85 ms / 283.99 ms Memory: 0.060 MB / 27.51 MB Application: afterRenderModule mod_custom (footer)

Time: 0.09 ms / 284.08 ms Memory: 0.000 MB / 27.50 MB Application: beforeRenderModule mod_custom (Opening Time)

Time: 0.23 ms / 284.31 ms Memory: 0.008 MB / 27.51 MB Application: afterRenderModule mod_custom (Opening Time)

Time: 0.08 ms / 284.39 ms Memory: 0.000 MB / 27.51 MB Application: beforeRenderModule mod_menu (Pages)

Time: 4.50 ms / 288.89 ms Memory: 0.132 MB / 27.64 MB Application: afterRenderModule mod_menu (Pages)

Time: 0.09 ms / 288.98 ms Memory: 0.000 MB / 27.63 MB Application: beforeRenderModule mod_menu (Service & Support)

Time: 3.74 ms / 292.72 ms Memory: 0.095 MB / 27.73 MB Application: afterRenderModule mod_menu (Service & Support)

Time: 0.09 ms / 292.81 ms Memory: 0.000 MB / 27.72 MB Application: beforeRenderModule mod_menu (My Account)

Time: 2.87 ms / 295.67 ms Memory: 0.050 MB / 27.77 MB Application: afterRenderModule mod_menu (My Account)

Time: 0.09 ms / 295.76 ms Memory: 0.000 MB / 27.76 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.19 ms / 295.95 ms Memory: 0.007 MB / 27.77 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.07 ms / 296.02 ms Memory: 0.000 MB / 27.77 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.46 ms / 298.48 ms Memory: 0.072 MB / 27.84 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.16 ms / 298.64 ms Memory: 0.000 MB / 27.83 MB Application: beforeRenderModule mod_virtuemart_search (Search Product)

Time: 2.86 ms / 301.50 ms Memory: 0.204 MB / 28.04 MB Application: afterRenderModule mod_virtuemart_search (Search Product)

Time: 0.09 ms / 301.58 ms Memory: 0.000 MB / 28.03 MB Application: beforeRenderModule mod_custom (warranty)

Time: 0.22 ms / 301.80 ms Memory: 0.007 MB / 28.04 MB Application: afterRenderModule mod_custom (warranty)

Time: 0.09 ms / 301.89 ms Memory: 0.000 MB / 28.03 MB Application: beforeRenderModule mod_virtuemart_currencies (Currency:)

Time: 12.19 ms / 314.08 ms Memory: 1.485 MB / 29.52 MB Application: afterRenderModule mod_virtuemart_currencies (Currency:)

Time: 25.28 ms / 339.36 ms Memory: 2.479 MB / 32.00 MB Application: afterRender

Database queries total: 42.34 ms

Memory Usage

Database Queries

80 Queries Logged 42.34 ms

21 duplicate found!

3 duplicates: #8 #20 #76

2 duplicates: #29 #30

14 duplicates: #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

2 duplicates: #65 #68

Query Time: 0.35 ms Query memory: 0.021 MB Memory before query: 4.667 MB Rows returned: 0

SELECT `data`

  FROM `bonnie_session`

  WHERE `session_id` = '7la2o6gev3gmmoeis8t8qiokt3'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 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.14 ms After last query: 1.38 ms Query memory: 0.013 MB Memory before query: 4.843 MB Rows returned: 0

SELECT `session_id`

  FROM `bonnie_session`

  WHERE `session_id` = '7la2o6gev3gmmoeis8t8qiokt3' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 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: 0.25 ms After last query: 0.12 ms Query memory: 0.010 MB Memory before query: 4.860 MB

INSERT INTO `bonnie_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('7la2o6gev3gmmoeis8t8qiokt3', 1, 1615029138, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `bonnie_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7la2o6gev3gmmoeis8t8qiokt3', 1, 1615029138, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.09 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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.56 ms After last query: 2.57 ms Query memory: 0.036 MB Memory before query: 5.196 MB Rows returned: 54

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

  FROM `bonnie_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_extensions	NULL	ref	extension	extension	82	const	55	1.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.00 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
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.25 ms After last query: 2.25 ms Query memory: 0.015 MB Memory before query: 5.545 MB Rows returned: 5

SELECT id, rules

  FROM `bonnie_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 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
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.33 ms After last query: 0.13 ms Query memory: 0.016 MB Memory before query: 5.570 MB Rows returned: 1

SELECT b.id

  FROM bonnie_usergroups AS a

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

  WHERE a.id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	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.10 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 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.02 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: 0.87 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 5.672 MB Rows returned: 132

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

  FROM bonnie_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_extensions	NULL	ref	extension	extension	82	const	194	0.40	Using index condition; Using where; Using filesort

Profile

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

Call Stack

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

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

Query Time: 1.70 ms After last query: 24.00 ms Query memory: 0.022 MB Memory before query: 8.600 MB Rows returned: 407

Duplicate queries: #20 #76

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 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
checking permissions	1.26 ms
Sending data	0.11 ms
end	0.00 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.40 ms After last query: 0.40 ms Query memory: 0.015 MB Memory before query: 8.691 MB Rows returned: 0

SELECT file_id 
  from bonnie_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2021-03-06 05:12:18'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_jdownloads_files	NULL	ALL	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 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/plugins/system/jdownloads/jdownloads.php:106
9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.16 ms After last query: 0.06 ms Query memory: 0.015 MB Memory before query: 8.705 MB Rows returned: 0

SELECT file_id 
  from bonnie_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2021-03-06 05:12:18'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_jdownloads_files	NULL	ref	idx_published	idx_published	1	const	1	9.09	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 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/plugins/system/jdownloads/jdownloads.php:114
9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.24 ms After last query: 2.24 ms Query memory: 0.028 MB Memory before query: 9.061 MB Rows returned: 1

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

  FROM `bonnie_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
21	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
20	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
17	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
16	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
15	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
11	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
10	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.29 ms After last query: 0.24 ms Query memory: 0.020 MB Memory before query: 9.071 MB

UPDATE `bonnie_extensions`

  SET `params` = '{\"mediaversion\":\"726cf5087def7326d371ae5a7753a7e2\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	bonnie_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
16	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
15	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
11	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
10	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.80 ms After last query: 2.44 ms Query memory: 0.043 MB Memory before query: 9.490 MB Rows returned: 49

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

  LEFT JOIN bonnie_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	249	4.82	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	relitesp_site.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.44 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 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()	JROOT/libraries/src/Menu/SiteMenu.php:93
24	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
22	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
21	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
20	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
19	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
18	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
17	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
16	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.42 ms After last query: 1.30 ms Query memory: 0.023 MB Memory before query: 9.807 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM bonnie_template_styles as s

  LEFT JOIN bonnie_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	relitesp_site.e.element	1	11.11	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
9	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.35 ms After last query: 7.52 ms Query memory: 0.023 MB Memory before query: 10.552 MB Rows returned: 1

SELECT *

  FROM bonnie_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
13	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:156
12	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
11	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
10	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:47
9	plgSystemSh404sef->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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: 7.93 ms Query memory: 0.022 MB Memory before query: 11.794 MB Rows returned: 1

SELECT `params` 
  FROM bonnie_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
15	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
14	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
13	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:120
12	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:593
11	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
10	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:56
9	plgSystemSh404sef->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.43 ms After last query: 21.56 ms Query memory: 0.020 MB Memory before query: 14.279 MB Rows returned: 0

SELECT `alias`,`newurl` 
  FROM `bonnie_sh404sef_aliases` 
  WHERE `alias` = 'component/com_fsf/Itemid,847/catid,1/view,faq/' or `alias` = 'index.php/component/com_fsf/Itemid,847/catid,1/view,faq' or `alias` = 'index.php/component/com_fsf/Itemid,847/catid,1/view,faq/' 
  order by `alias` desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_sh404sef_aliases	NULL	ALL	alias	NO INDEX KEY COULD BE USED	NULL	NULL	9	33.33	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
13	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:503
12	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:259
11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.29 ms Query memory: 0.017 MB Memory before query: 14.302 MB Rows returned: 2

select id, title, alias 
  from bonnie_jumi 
  where published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_jumi	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1805
12	JDatabaseDriver->loadRowList()	JROOT/plugins/system/jumirouter/jumirouter.php:57
11	parseJumiRouter()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 1.01 ms Query memory: 0.020 MB Memory before query: 14.432 MB Rows returned: 0

select b.* 
  from bonnie_rstbox b RIGHT JOIN bonnie_rstbox_menu m 
  on b.id = m.boxid 
  and m.menuid IN (-1,847) 
  where b.published = 1 
  AND ((b.accesslevel IN (1,1)) OR (b.accesslevel IS NULL)) 
  AND b.testmode=0 
  GROUP BY b.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	index	PRIMARY	PRIMARY	4	NULL	1	100.00	Using where
1	SIMPLE	m	NULL	ref	boxid,menuid	boxid	4	relitesp_site.b.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:424
11	RstboxHelper::runquery()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:261
10	RstboxHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:54
9	plgSystemRstBox->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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: 1.54 ms After last query: 0.40 ms Query memory: 0.022 MB Memory before query: 14.468 MB Rows returned: 407

Duplicate queries: #8 #76

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	1.19 ms
Sending data	0.10 ms
end	0.00 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.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
9	plgSystemjdownloads->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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: 2.14 ms After last query: 9.73 ms Query memory: 0.020 MB Memory before query: 15.368 MB Rows returned: 158

SELECT * 
  FROM bonnie_fsf_settings

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	1.49 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.47 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 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:1500
10	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/settings.php:48
9	FSF_Settings::_GetSettings()	JROOT/components/com_fsf/helper/settings.php:408
8	FSF_Settings::get()	JROOT/components/com_fsf/helper/helper.php:45
7	FSF_Helper::IncludeJQuery()	JROOT/components/com_fsf/fsf.php:52
6	require_once JROOT/components/com_fsf/fsf.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.18 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 15.477 MB Rows returned: 0

SELECT * 
  FROM bonnie_fsf_settings_big

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	1.06 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 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:1500
10	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/settings.php:60
9	FSF_Settings::_GetSettings()	JROOT/components/com_fsf/helper/settings.php:408
8	FSF_Settings::get()	JROOT/components/com_fsf/helper/helper.php:45
7	FSF_Helper::IncludeJQuery()	JROOT/components/com_fsf/fsf.php:52
6	require_once JROOT/components/com_fsf/fsf.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.91 ms After last query: 11.00 ms Query memory: 0.024 MB Memory before query: 16.507 MB Rows returned: 33

SELECT * 
  FROM bonnie_fsf_settings_view

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/settings.php:81
15	FSF_Settings::_Get_View_Settings()	JROOT/components/com_fsf/helper/settings.php:488
14	FSF_Settings::GetViewSettingsObj()	JROOT/components/com_fsf/models/faq.php:40
13	FsfModelFaq->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.63 ms After last query: 0.40 ms Query memory: 0.024 MB Memory before query: 16.536 MB Rows returned: 1

SELECT * 
  FROM bonnie_fsf_faq_cat 
  WHERE published = 1 
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	1.15 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.26 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.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:1500
15	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/models/faq.php:105
14	FsfModelFaq->_getCatList()	JROOT/components/com_fsf/models/faq.php:59
13	FsfModelFaq->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.29 ms After last query: 8.36 ms Query memory: 0.024 MB Memory before query: 17.126 MB Rows returned: 5

SELECT a.lang_code AS value, a.title AS text, a.title_native

  FROM bonnie_languages AS a

  WHERE a.published >= 0

  ORDER BY a.title

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 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.00 ms
Creating sort index	0.07 ms
end	0.00 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/html/contentlanguage.php:54
16	JHtmlContentLanguage::existing()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_fsf/adminhelper.php:189
12	FSFAdminHelper::LoadLanguages()	JROOT/components/com_fsf/helper/content/faqs.php:77
11	FSF_ContentEdit_FAQs->__construct()	JROOT/components/com_fsf/views/faq/view.html.php:22
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.19 ms After last query: 0.14 ms Query memory: 0.020 MB Memory before query: 17.154 MB Rows returned: 5

SELECT a.id AS value, a.title AS text

  FROM bonnie_viewlevels AS a

  GROUP BY a.id, a.title, a.ordering

  ORDER BY a.ordering ASC,`title` ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fsf/adminhelper.php:237
12	FSFAdminHelper::LoadAccessLevels()	JROOT/components/com_fsf/helper/content/faqs.php:78
11	FSF_ContentEdit_FAQs->__construct()	JROOT/components/com_fsf/views/faq/view.html.php:22
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.34 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 17.190 MB Rows returned: 0

SELECT * 
  FROM bonnie_fsf_user 
  WHERE user_id = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	1.18 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
end	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/components/com_fsf/helper/tickethelper.php:463
12	FSF_Ticket_Helper::getAdminPermissions()	JROOT/components/com_fsf/helper/content.php:46
11	FSF_ContentEdit->Init()	JROOT/components/com_fsf/views/faq/view.html.php:23
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.46 ms After last query: 3.22 ms Query memory: 0.020 MB Memory before query: 17.492 MB Rows returned: 2

SELECT id, link 
  FROM bonnie_menu 
  WHERE link LIKE '%option=com_fsf%' 
  AND published = 1 
  AND language in ('en-GB','*')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_menu	NULL	ALL	idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	249	0.63	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.23 ms
end	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_fsf/helper/helper.php:133
12	FSF_Helper::GetRouteMenus()	JROOT/components/com_fsf/helper/helper.php:814
11	FSF_Helper::NeedBaseBreadcrumb()	JROOT/components/com_fsf/views/faq/view.html.php:99
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.52 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 17.516 MB Rows returned: 13

Duplicate queries: #30

SELECT * 
  FROM bonnie_fsf_faq_faq 
  WHERE faq_cat_id = '1' 
  AND published = 1 
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_fsf_faq_faq	NULL	ref	jos_fss_faq_faq_FKIndex1	jos_fss_faq_faq_FKIndex1	4	const	12	7.69	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_fsf/models/faq.php:258
13	FsfModelFaq->getTotal()	JROOT/components/com_fsf/models/faq.php:268
12	FsfModelFaq->getPagination()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_fsf/views/faq/view.html.php:144
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.27 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 17.538 MB Rows returned: 13

Duplicate queries: #29

SELECT * 
  FROM bonnie_fsf_faq_faq 
  WHERE faq_cat_id = '1' 
  AND published = 1 
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_fsf_faq_faq	NULL	ref	jos_fss_faq_faq_FKIndex1	jos_fss_faq_faq_FKIndex1	4	const	12	7.69	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/models/faq.php:222
12	FsfModelFaq->getData()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_fsf/views/faq/view.html.php:193
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.09 ms After last query: 0.47 ms Query memory: 0.017 MB Memory before query: 17.614 MB Rows returned: 0

SELECT * 
  FROM bonnie_fsf_faq_tags 
  WHERE faq_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13) 
  GROUP BY tag 
  ORDER BY tag

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.93 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_fsf/views/faq/view.html.php:271
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.12 ms After last query: 0.06 ms Query memory: 0.017 MB Memory before query: 17.631 MB Rows returned: 1

SELECT count(*) as cnt 
  FROM bonnie_fsf_faq_tags

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/components/com_fsf/views/faq/view.html.php:287
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 2.53 ms Query memory: 0.026 MB Memory before query: 17.760 MB Rows returned: 0

Duplicate queries: #34 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.74 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.14 ms After last query: 0.31 ms Query memory: 0.026 MB Memory before query: 17.784 MB Rows returned: 0

Duplicate queries: #33 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.15 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 17.808 MB Rows returned: 0

Duplicate queries: #33 #34 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.12 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 17.832 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.11 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 17.856 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.11 ms After last query: 0.30 ms Query memory: 0.026 MB Memory before query: 17.879 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #39 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.11 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 17.903 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #40 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.12 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 17.927 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #41 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.10 ms After last query: 0.29 ms Query memory: 0.026 MB Memory before query: 17.951 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #40 #42 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.10 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 17.975 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #40 #41 #43 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.11 ms After last query: 0.29 ms Query memory: 0.026 MB Memory before query: 17.998 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #44 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.11 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 18.022 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #43 #45 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.11 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 18.047 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #46

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
16	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:162
15	FSF_Glossary::ReplaceGlossary()	JROOT/components/com_fsf/views/faq/snippet/_faq.php:100
14	include JROOT/components/com_fsf/views/faq/snippet/_faq.php	JROOT/components/com_fsf/views/faq/tmpl/default.php:275
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.12 ms After last query: 0.45 ms Query memory: 0.025 MB Memory before query: 18.044 MB Rows returned: 0

Duplicate queries: #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45

SELECT * 
  FROM bonnie_fsf_glossary 
  WHERE  published = 1  
  AND language in ('en-GB','*') 
  AND access IN (1,1) 
  ORDER BY LENGTH(word) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_fsf/helper/glossary.php:41
15	FSF_Glossary::GetGlossary()	JROOT/components/com_fsf/helper/glossary.php:239
14	FSF_Glossary::Footer()	JROOT/components/com_fsf/views/faq/tmpl/default.php:295
13	include JROOT/components/com_fsf/views/faq/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_fsf/views/faq/view.html.php:305
10	FsfViewFaq->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fsf/controller.php:17
8	FsfController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fsf/fsf.php:64
6	require_once JROOT/components/com_fsf/fsf.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.34 ms After last query: 2.77 ms Query memory: 0.018 MB Memory before query: 18.271 MB Rows returned: 0

SELECT `pageid` 
  FROM bonnie_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_fsf&Itemid=847&catid=1&lang=en&view=faq';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bonnie_sh404sef_pageids	NULL	ref	newurl	newurl	767	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.06 ms
preparing	0.00 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
12	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
11	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
10	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
9	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:172
8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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: 38.52 ms Query memory: 0.041 MB Memory before query: 23.586 MB Rows returned: 0