Library Catalogue

Hits: 50
Eloquent Keyword Catalogue
Hits: 59
Eloquent WebLibrary's Visual Catalogue
Hits: 48
Eloquent Template Search
Hits: 54
Eloquent Advanced Title Search

LEND YOUR SUPPORT

Please consider supporting our book drive of $2,000 for each public library to expand our literary inventory throughout the national library system.

Search the Invisible Web

In addition to a large collection of resources you may find accessible on the Internet and in your public library, even more information can be found by accessing the invisible web of database libraries...

Get Connected ...

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1529740577,
                "last": 1529740577,
                "now": 1529740577
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 15.50 ms / 15.50 ms Memory: 0.733 MB / 1.06 MB Application: afterLoad

Time: 125.92 ms / 141.42 ms Memory: 5.983 MB / 7.04 MB Application: afterInitialise

Time: 46.09 ms / 187.51 ms Memory: 2.233 MB / 9.27 MB Application: Before JAccess::preloadComponents (all components)

Time: 2.36 ms / 189.87 ms Memory: 0.093 MB / 9.37 MB Application: After JAccess::preloadComponents (all components)

Time: 0.12 ms / 189.98 ms Memory: 0.000 MB / 9.36 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Time: 1.28 ms / 191.26 ms Memory: 0.043 MB / 9.41 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 6.20 ms / 197.46 ms Memory: 0.091 MB / 9.50 MB Application: afterRoute

Time: 10.23 ms / 207.68 ms Memory: 0.372 MB / 9.87 MB Application: beforeRenderComponent com_weblinks

Time: 14.42 ms / 222.11 ms Memory: 0.688 MB / 10.56 MB Application: Before JAccess::getAssetRules (id:718 name:com_weblinks)

Time: 0.19 ms / 222.30 ms Memory: 0.009 MB / 10.57 MB Application: After JAccess::getAssetRules (id:718 name:com_weblinks)

Time: 82.48 ms / 304.78 ms Memory: 3.291 MB / 13.86 MB Application: Before JAccess::preloadPermissions (com_weblinks)

Time: 1.86 ms / 306.64 ms Memory: 0.053 MB / 13.91 MB Application: After JAccess::preloadPermissions (com_weblinks)

Time: 0.09 ms / 306.73 ms Memory: 0.000 MB / 13.91 MB Application: Before JAccess::getAssetRules (id:105 name:com_weblinks.category.61)

Time: 0.06 ms / 306.78 ms Memory: 0.003 MB / 13.91 MB Application: After JAccess::getAssetRules (id:105 name:com_weblinks.category.61)

Time: 9.75 ms / 316.53 ms Memory: 0.017 MB / 13.93 MB Application: afterRenderComponent com_weblinks

Time: 6.26 ms / 322.79 ms Memory: 0.150 MB / 14.08 MB Application: afterDispatch

Time: 62.08 ms / 384.87 ms Memory: 2.250 MB / 16.33 MB Application: beforeRenderModule mod_custom (Bahamas Libraries Copyright)

Time: 2.98 ms / 387.85 ms Memory: 0.061 MB / 16.39 MB Application: afterRenderModule mod_custom (Bahamas Libraries Copyright)

Time: 0.13 ms / 387.98 ms Memory: 0.000 MB / 16.39 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 6.88 ms / 394.87 ms Memory: 0.126 MB / 16.51 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.25 ms / 395.12 ms Memory: 0.000 MB / 16.50 MB Application: beforeRenderModule mod_custom (Search the Invisible Web)

Time: 0.65 ms / 395.76 ms Memory: 0.008 MB / 16.51 MB Application: afterRenderModule mod_custom (Search the Invisible Web)

Time: 0.23 ms / 395.99 ms Memory: 0.000 MB / 16.51 MB Application: beforeRenderModule mod_osdonate (LEND YOUR SUPPORT)

Time: 3.85 ms / 399.84 ms Memory: 0.051 MB / 16.56 MB Application: afterRenderModule mod_osdonate (LEND YOUR SUPPORT)

Time: 0.26 ms / 400.10 ms Memory: 0.000 MB / 16.54 MB Application: beforeRenderModule mod_as_superfish_menu (AS Superfish Menu)

Time: 138.18 ms / 538.29 ms Memory: 0.780 MB / 17.32 MB Application: afterRenderModule mod_as_superfish_menu (AS Superfish Menu)

Time: 0.40 ms / 538.69 ms Memory: 0.000 MB / 17.31 MB Application: beforeRenderModule mod_menu (Top Menu)

Time: 6.07 ms / 544.76 ms Memory: 0.042 MB / 17.36 MB Application: afterRenderModule mod_menu (Top Menu)

Time: 0.12 ms / 544.88 ms Memory: 0.000 MB / 17.35 MB Application: beforeRenderModule mod_djmegamenu_button (Mobile Menu)

Time: 0.47 ms / 545.35 ms Memory: 0.009 MB / 17.36 MB Application: afterRenderModule mod_djmegamenu_button (Mobile Menu)

Time: 0.24 ms / 545.58 ms Memory: 0.013 MB / 17.37 MB Application: beforeRenderModule mod_social_icons (Social Icons)

Time: 3.80 ms / 549.39 ms Memory: 0.048 MB / 17.42 MB Application: afterRenderModule mod_social_icons (Social Icons)

Time: 18.15 ms / 567.54 ms Memory: 0.096 MB / 17.51 MB Application: afterRender

Database queries total: 25.55 ms

Memory Usage

Database Queries

32 Queries Logged 25.55 ms

8 duplicate found!

2 duplicates: #17 #28

2 duplicates: #18 #29

2 duplicates: #19 #30

2 duplicates: #20 #31

Query Time: 0.70 ms Query memory: 0.008 MB Memory before query: 3.116 MB

DELETE 

  FROM `f4soy_session`

  WHERE `time` < '1529739677'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f4soy_session	range	time	time	59	const	1	100.00	Using where

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.11 ms
updating	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:63

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

Query Time: 0.46 ms After last query: 1.43 ms Query memory: 0.019 MB Memory before query: 3.147 MB Rows returned: 0

SELECT `data`

  FROM `f4soy_session`

  WHERE `session_id` = 'nsuq1d9splgfe6ceqa21i16h15'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:63

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

Query Time: 0.52 ms After last query: 3.04 ms Query memory: 0.010 MB Memory before query: 3.290 MB Rows returned: 0

SELECT `session_id`

  FROM `f4soy_session`

  WHERE `session_id` = 'nsuq1d9splgfe6ceqa21i16h15' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:63

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

Query Time: 0.53 ms After last query: 0.37 ms Query memory: 0.009 MB Memory before query: 3.305 MB

INSERT INTO `f4soy_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('nsuq1d9splgfe6ceqa21i16h15', 1, '1529740577', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `f4soy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('nsuq1d9splgfe6ceqa21i16h15', 1, '1529740577', 0, '', 0)

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
update	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:63

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

Query Time: 1.19 ms After last query: 5.22 ms Query memory: 0.013 MB Memory before query: 3.554 MB Rows returned: 42

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

  FROM `f4soy_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f4soy_extensions	ref	extension	extension	82	const	42	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
9	JComponentHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.55 ms After last query: 7.18 ms Query memory: 0.013 MB Memory before query: 3.840 MB Rows returned: 5

SELECT id, rules

  FROM `f4soy_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.52 ms After last query: 0.40 ms Query memory: 0.014 MB Memory before query: 3.864 MB Rows returned: 2

SELECT b.id

  FROM f4soy_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 1.01 ms After last query: 2.05 ms Query memory: 0.013 MB Memory before query: 3.958 MB Rows returned: 71

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

  FROM f4soy_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
9	JPluginHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 2.19 ms After last query: 73.40 ms Query memory: 0.023 MB Memory before query: 7.319 MB Rows returned: 177

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	234	78.21	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
17	JMenuSite->{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 1.27 ms After last query: 38.81 ms Query memory: 0.023 MB Memory before query: 9.280 MB Rows returned: 39

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

  FROM `f4soy_assets`

  WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_hdwplayer','com_installer','com_jce','com_joomlaupdate','com_jupgradepro','com_jxtcalbumplayer','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rquote','com_search','com_speasyimagegallery','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zcalendar')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f4soy_assets	range	idx_asset_name	idx_asset_name	202	NULL	42	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:110
10	RegularLabs\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/src/Plugin.php:54
9	RegularLabs\AdvancedModules\Plugin->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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.61 ms After last query: 3.83 ms Query memory: 0.016 MB Memory before query: 9.456 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM f4soy_template_styles as s

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
12	JApplicationSite->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
11	jsn_template_framework_class_loader()	Same as call in the line below.
10	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
9	PlgSystemJSNTPLFramework->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

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

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

  FROM `f4soy_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
13	JLibraryHelper::{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.44 ms After last query: 0.59 ms Query memory: 0.012 MB Memory before query: 9.549 MB

UPDATE `f4soy_extensions`

  SET `params` = '{\"mediaversion\":\"17475d88ba4108fdbc12bcb7bdc3b555\"}'

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.45 ms After last query: 4.93 ms Query memory: 0.009 MB Memory before query: 9.808 MB Rows returned: 1

SELECT *

  FROM f4soy_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 1.55 ms After last query: 20.27 ms Query memory: 0.021 MB Memory before query: 10.714 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

  FROM f4soy_categories as c

  LEFT JOIN f4soy_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `f4soy_weblinks` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_weblinks' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=61

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	11	100.00	Using index condition; Using where
1	SIMPLE	i	ref	idx_state,idx_catid	idx_catid	4	ct_baha_f4soy.c.id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_weblinks/models/category.php:299
13	WeblinksModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:121
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.91 ms After last query: 1.01 ms Query memory: 0.021 MB Memory before query: 10.751 MB Rows returned: 4

SELECT a.*,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `f4soy_weblinks` AS a

  LEFT JOIN f4soy_categories AS c 
  ON c.id = a.catid

  LEFT JOIN f4soy_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN f4soy_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1,5) 
  AND a.catid = 61 
  AND c.access IN (1,1,5) 
  AND a.state = 1 
  AND a.state != -2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-23 07:56:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-23 07:56:18')

  ORDER BY ordering ASC 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	4	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.modified_by	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
14	JModelList->getItems()	JROOT/components/com_weblinks/models/category.php:81
13	WeblinksModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.49 ms After last query: 4.46 ms Query memory: 0.020 MB Memory before query: 10.992 MB Rows returned: 0

Duplicate queries: #28

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
13	WeblinksModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.46 ms After last query: 0.56 ms Query memory: 0.020 MB Memory before query: 11.015 MB Rows returned: 0

Duplicate queries: #29

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
13	WeblinksModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.47 ms After last query: 0.55 ms Query memory: 0.020 MB Memory before query: 11.037 MB Rows returned: 0

Duplicate queries: #30

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 3 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
13	WeblinksModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.45 ms After last query: 0.53 ms Query memory: 0.020 MB Memory before query: 11.060 MB Rows returned: 0

Duplicate queries: #31

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 4 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
13	WeblinksModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.60 ms After last query: 3.11 ms Query memory: 0.021 MB Memory before query: 11.217 MB Rows returned: 1

SELECT COUNT(*)

  FROM `f4soy_weblinks` AS a

  LEFT JOIN f4soy_categories AS c 
  ON c.id = a.catid

  LEFT JOIN f4soy_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN f4soy_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1,5) 
  AND a.catid = 61 
  AND c.access IN (1,1,5) 
  AND a.state = 1 
  AND a.state != -2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-23 07:56:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-23 07:56:18')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	4	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.modified_by	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
15	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
14	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
13	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:144
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.46 ms After last query: 0.77 ms Query memory: 0.018 MB Memory before query: 11.238 MB Rows returned: 0

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = '.category' 
  AND `m`.`content_item_id` = 61 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_weblinks/views/category/view.html.php:28
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.78 ms After last query: 17.51 ms Query memory: 0.033 MB Memory before query: 11.919 MB Rows returned: 0

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

  FROM f4soy_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_weblinks.categories' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ct_baha_f4soy.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.group_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
25	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
24	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
23	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
21	PlgSystemFields->onContentPrepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.90 ms After last query: 9.42 ms Query memory: 0.036 MB Memory before query: 12.428 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM f4soy_categories as c

  LEFT JOIN f4soy_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_weblinks' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=61

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	11	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
28	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
27	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
26	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
25	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
24	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
22	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:255
21	PlgSystemFields->onContentAfterTitle()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.68 ms After last query: 0.80 ms Query memory: 0.034 MB Memory before query: 12.468 MB Rows returned: 0

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

  FROM f4soy_fields AS a

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

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

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

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

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

  LEFT JOIN `f4soy_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_weblinks.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (61,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ct_baha_f4soy.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
26	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
25	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
24	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
22	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:255
21	PlgSystemFields->onContentAfterTitle()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.77 ms After last query: 24.98 ms Query memory: 0.037 MB Memory before query: 13.568 MB Rows returned: 0

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

  FROM f4soy_fields AS a

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

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

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

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

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

  LEFT JOIN `f4soy_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_weblinks.category.title' 
  AND (fc.category_id IS NULL OR fc.category_id IN (61,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ct_baha_f4soy.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ct_baha_f4soy.a.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
29	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
28	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
27	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
26	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
25	PlgSystemFields->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
19	JHtml::call()	JROOT/libraries/cms/html/html.php:140
18	JHtml::_()	JROOT/layouts/joomla/content/category_default.php:57
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 1.23 ms After last query: 7.01 ms Query memory: 0.033 MB Memory before query: 13.862 MB Rows returned: 10

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

  FROM `f4soy_assets`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
24	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
23	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
22	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
20	JUser->authorise()	JROOT/components/com_weblinks/views/category/tmpl/default_items.php:23
19	include JROOT/components/com_weblinks/views/category/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
18	JViewLegacy->loadTemplate()	JROOT/layouts/joomla/content/category_default.php:79
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.49 ms After last query: 2.51 ms Query memory: 0.028 MB Memory before query: 13.964 MB Rows returned: 0

Duplicate queries: #17

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
20	JHelperTags->getItemTags()	JROOT/components/com_weblinks/views/category/tmpl/default_items.php:129
19	include JROOT/components/com_weblinks/views/category/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
18	JViewLegacy->loadTemplate()	JROOT/layouts/joomla/content/category_default.php:79
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.63 ms After last query: 1.42 ms Query memory: 0.028 MB Memory before query: 13.996 MB Rows returned: 0

Duplicate queries: #18

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
20	JHelperTags->getItemTags()	JROOT/components/com_weblinks/views/category/tmpl/default_items.php:129
19	include JROOT/components/com_weblinks/views/category/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
18	JViewLegacy->loadTemplate()	JROOT/layouts/joomla/content/category_default.php:79
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.78 ms After last query: 1.49 ms Query memory: 0.028 MB Memory before query: 14.025 MB Rows returned: 0

Duplicate queries: #19

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 3 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
20	JHelperTags->getItemTags()	JROOT/components/com_weblinks/views/category/tmpl/default_items.php:129
19	include JROOT/components/com_weblinks/views/category/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
18	JViewLegacy->loadTemplate()	JROOT/layouts/joomla/content/category_default.php:79
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 0.47 ms After last query: 1.37 ms Query memory: 0.028 MB Memory before query: 14.053 MB Rows returned: 0

Duplicate queries: #20

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

  FROM `f4soy_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 4 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ct_baha_f4soy.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
20	JHelperTags->getItemTags()	JROOT/components/com_weblinks/views/category/tmpl/default_items.php:129
19	include JROOT/components/com_weblinks/views/category/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
18	JViewLegacy->loadTemplate()	JROOT/layouts/joomla/content/category_default.php:79
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
16	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
15	JLayoutHelper::render()	JROOT/components/com_weblinks/views/category/tmpl/default.php:14
14	include JROOT/components/com_weblinks/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_weblinks/views/category/view.html.php:51
10	WeblinksViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_weblinks/controller.php:65
8	WeblinksController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_weblinks/weblinks.php:15
6	require_once JROOT/components/com_weblinks/weblinks.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:66

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

Query Time: 2.44 ms After last query: 11.11 ms Query memory: 0.022 MB Memory before query: 14.279 MB Rows returned: 42

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM f4soy_modules AS m

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

  LEFT JOIN f4soy_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:402
16	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
15	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
13	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
12	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/templates/as002073free/includes/includes.php:66
8	include JROOT/templates/as002073free/includes/includes.php	JROOT/templates/as002073free/index.php:13
7	require JROOT/templates/as002073free/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:66

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

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT `m`.`tag_id`,`t`.* 
  FROM `f4soy_contentitem_tag_map` AS m  
  INNER JOIN `f4soy_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM f4soy_fields AS a 
  LEFT JOIN `f4soy_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f4soy_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f4soy_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f4soy_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN f4soy_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `f4soy_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT a.*,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `f4soy_weblinks` AS a 
  LEFT JOIN f4soy_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f4soy_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN f4soy_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT COUNT(*) 
  FROM `f4soy_weblinks` AS a 
  LEFT JOIN f4soy_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f4soy_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN f4soy_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM f4soy_categories as c 
  LEFT JOIN f4soy_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM f4soy_modules AS m 
  LEFT JOIN f4soy_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN f4soy_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM f4soy_categories as c 
  LEFT JOIN f4soy_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN `f4soy_weblinks` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM f4soy_fields AS a 
  LEFT JOIN `f4soy_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f4soy_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f4soy_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f4soy_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN f4soy_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT id, rules 
  FROM `f4soy_viewlevels

1 × SELECT `session_id` 
  FROM `f4soy_session`

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM f4soy_extensions

1 × SELECT `data` 
  FROM `f4soy_session`

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

```
1 × SELECT * 
  FROM f4soy_languages
```

OTHER Tables:

1 × UPDATE `f4soy_extensions` 
  SET `params` = '{\"mediaversion\":\"17475d88ba4108fdbc12bcb7bdc3b555\"}'

1 × INSERT INTO `f4soy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('nsuq1d9splgfe6ceqa21i16h15', 1, '1529740577', 0, '', 0

```
1 × DELETE  
  FROM `f4soy_session`
```