BIM Books - Page 2 - BIMlar Directory

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713948638,
                "last": 1713948638,
                "now": 1713948638
            },
            "client": {
                "forwarded": "3.128.199.88"
            },
            "token": "BeDxA29uqRVDXhhhCy686UQsMoGqCCJN"
        },
        "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
        }
    },
    "__findCount": {
        "Listing": {
            "e6173884905cc40def4d82e270287dc9": "23"
        }
    }
}

Profile Information

Time

Memory

Time: 2.68 ms / 2.68 ms Memory: 0.395 MB / 0.74 MB Application: afterLoad

Time: 32.64 ms / 35.32 ms Memory: 2.570 MB / 3.31 MB Application: afterInitialise

Time: 1.76 ms / 37.08 ms Memory: 0.176 MB / 3.48 MB Application: Before Access::preloadComponents (all components)

Time: 0.38 ms / 37.46 ms Memory: 0.061 MB / 3.55 MB Application: After Access::preloadComponents (all components)

Time: 0.01 ms / 37.47 ms Memory: -0.002 MB / 3.54 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.09 ms / 37.56 ms Memory: 0.008 MB / 3.55 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 1.17 ms / 38.73 ms Memory: 0.104 MB / 3.66 MB Application: afterRoute

Time: 0.16 ms / 38.89 ms Memory: 0.021 MB / 3.68 MB Application: beforeRenderComponent com_jreviews

Time: 27.78 ms / 66.67 ms Memory: 4.845 MB / 8.52 MB Application: afterRenderComponent com_jreviews

Time: 0.97 ms / 67.64 ms Memory: 0.023 MB / 8.54 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.02 ms / 67.66 ms Memory: 0.007 MB / 8.55 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 1.15 ms / 68.81 ms Memory: 0.040 MB / 8.59 MB Application: afterDispatch

Time: 0.88 ms / 69.70 ms Memory: 0.048 MB / 8.64 MB Application: Before Access::getAssetRules (id:218 name:com_jfbconnect)

Time: 0.01 ms / 69.71 ms Memory: 0.002 MB / 8.64 MB Application: After Access::getAssetRules (id:218 name:com_jfbconnect)

Time: 0.31 ms / 70.02 ms Memory: 0.018 MB / 8.66 MB Application: beforeRenderModule mod_jreviews_advsearch (Search jreviews all)

Time: 0.22 ms / 70.24 ms Memory: 0.016 MB / 8.67 MB Application: afterRenderModule mod_jreviews_advsearch (Search jreviews all)

Time: 0.01 ms / 70.25 ms Memory: -0.003 MB / 8.67 MB Application: beforeRenderModule mod_jreviews_fields (Topics)

Time: 22.27 ms / 92.52 ms Memory: 1.041 MB / 9.71 MB Application: afterRenderModule mod_jreviews_fields (Topics)

Time: 0.02 ms / 92.54 ms Memory: 0.013 MB / 9.72 MB Application: beforeRenderModule mod_jreviews_fields (Authors)

Time: 5.86 ms / 98.40 ms Memory: 0.427 MB / 10.15 MB Application: afterRenderModule mod_jreviews_fields (Authors)

Time: 0.03 ms / 98.43 ms Memory: 0.002 MB / 10.15 MB Application: beforeRenderModule mod_jreviews_fields (Publishers)

Time: 3.37 ms / 101.80 ms Memory: 0.191 MB / 10.35 MB Application: afterRenderModule mod_jreviews_fields (Publishers)

Time: 0.02 ms / 101.81 ms Memory: -0.001 MB / 10.34 MB Application: beforeRenderModule mod_jreviews_fields (Related solutions)

Time: 2.74 ms / 104.56 ms Memory: 0.146 MB / 10.49 MB Application: afterRenderModule mod_jreviews_fields (Related solutions)

Time: 6.18 ms / 110.73 ms Memory: 0.721 MB / 11.21 MB Application: afterRender

Database queries total: 23.14 ms

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

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

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

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

EXPLAIN not possible on query: INSERT INTO `jaf2q_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'346e6d763139356733727631326f6b35763331726b6f636b7439', 1, 1713948638, 0, '', 0)

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.03 ms
Update	0.09 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.07 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.69 ms After last query: 2.18 ms Query memory: 0.021 MB Memory before query: 1.126 MB Rows returned: 5

SELECT id, rules

  FROM `jaf2q_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.70 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 1.138 MB Rows returned: 2

SELECT b.id

  FROM jaf2q_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.84 ms After last query: 4.86 ms Query memory: 0.022 MB Memory before query: 1.583 MB Rows returned: 0

Duplicate queries: #7

SELECT `manifest_cache`

  FROM `jaf2q_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.57 ms After last query: 1.68 ms Query memory: 0.022 MB Memory before query: 1.608 MB Rows returned: 0

Duplicate queries: #6

SELECT `manifest_cache`

  FROM `jaf2q_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.45 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 1.613 MB Rows returned: 1

SELECT `value`

  FROM `jaf2q_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

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

Call Stack

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

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

Query Time: 0.36 ms After last query: 0.42 ms Query memory: 0.021 MB Memory before query: 1.635 MB Rows returned: 0

SELECT *

  FROM `jaf2q_admintools_wafexceptions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.43 ms After last query: 2.63 ms Query memory: 0.006 MB Memory before query: 1.899 MB

UPDATE `jaf2q_extensions`

  SET `params` = '{\"mediaversion\":\"9dcec7d7eba9e9916c4a26500bfcc362\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jaf2q_extensions` SET `params` = '{\"mediaversion\":\"9dcec7d7eba9e9916c4a26500bfcc362\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.08 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jamp/jamp.php:864
7	PlgSystemJAmp->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 1.76 ms Query memory: 0.042 MB Memory before query: 2.167 MB Rows returned: 75

SELECT setting,value 
  FROM jaf2q_jfbconnect_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:305
14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:337
13	JFBConnectModelConfig->get()	JROOT/administrator/components/com_jfbconnect/models/config.php:384
12	JFBConnectModelConfig->getSetting()	JROOT/components/com_jfbconnect/libraries/provider.php:32
11	JFBConnectProvider->__construct()	JROOT/components/com_jfbconnect/libraries/provider/vk.php:20
10	JFBConnectProviderVk->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:55
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 1.09 ms Query memory: 0.024 MB Memory before query: 2.376 MB Rows returned: 1

SELECT value

  FROM jaf2q_jfbconnect_config

  WHERE setting="profile_joomla"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jfbconnect_config	const	setting	setting	152	const	1

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:616
16	SocialProfilePlugin->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:170
15	SocialProfilePlugin->socialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jfbconnect/libraries/profile/amazon.php:82
11	JFBConnectProfileAmazon->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:34
10	JFBConnectProviderAmazon->setupAuthentication()	JROOT/components/com_jfbconnect/libraries/factory.php:56
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 3.41 ms Query memory: 0.022 MB Memory before query: 2.974 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.005 MB Memory before query: 2.980 MB


  SET NAMES utf8mb4 COLLATE utf8mb4_general_ci

Explain

EXPLAIN not possible on query: SET NAMES utf8mb4 COLLATE utf8mb4_general_ci

Profile

Status	Duration
Starting	0.02 ms
Opening tables	0.00 ms
After opening tables	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/admintools/feature/utf8mb4.php:39
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:715
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 2.987 MB Rows returned: 0

SELECT *

  FROM `jaf2q_admintools_ipautoban`

  WHERE `ip` = '3.128.199.88'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.22 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 3.007 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `jaf2q_admintools_redirects`

  WHERE ((`dest` = 'books') OR (`dest` = 'books?page=2') OR ('books?page=2' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.20 ms After last query: 2.64 ms Query memory: 0.022 MB Memory before query: 3.395 MB Rows returned: 1

SELECT
                count(*)
            
  FROM
                jaf2q_jreviews_categories
            
  WHERE
                id = 47 
  AND `option` = 'com_content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_categories	const	PRIMARY,option	PRIMARY	156	const,const	1	Using index

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2603
12	JReviewsRouter->isJReviewsCategory()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1342
11	JReviewsRouter->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 3.415 MB Rows returned: 1

SELECT *

  FROM `jaf2q_admintools_wafblacklists`

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

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.31 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 3.488 MB Rows returned: 46

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

  FROM `jaf2q_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_ampz','com_associations','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jfbconnect','com_jmap','com_joomlaupdate','com_jreviews','com_languages','com_littlehelper','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rstbox','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	203	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
8	PlgSystemAdvancedModules->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 2.84 ms Query memory: 0.006 MB Memory before query: 4.288 MB


  SET SQL_BIG_SELECTS=1

Explain

EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

Profile

Status	Duration
Starting	0.02 ms
Opening tables	0.00 ms
After opening tables	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:91
8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 4.294 MB Rows returned: 1

SHOW TABLES LIKE '%_jreviews_config'

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE '%_jreviews_config'

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
10	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:40
9	JReviews\Models\ConfigurationModel::tableCreated()	JROOT/components/com_jreviews/jreviews/framework.php:93
8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.300 MB Rows returned: 1

SELECT value 
  FROM jaf2q_jreviews_config 
  WHERE id = 'cms_secret'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_config	const	PRIMARY	PRIMARY	767	const	1

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:98
8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.97 ms Query memory: 0.022 MB Memory before query: 4.742 MB Rows returned: 6

SELECT name 
  FROM jaf2q_jreviews_addons 
  WHERE state = 1 
  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:174
8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 8.65 ms Query memory: 0.023 MB Memory before query: 7.333 MB Rows returned: 2

SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`,
CriteriaRating.title AS `CriteriaRating.title`,
CriteriaRating.required AS `CriteriaRating.required`,
CriteriaRating.weight AS `CriteriaRating.weight`,
CriteriaRating.description AS `CriteriaRating.description`,
CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`,
CriteriaRating.ordering AS `CriteriaRating.ordering`,
ListingType.state AS `CriteriaRating.listing_type_state`
 
  FROM jaf2q_jreviews_criteria_ratings AS CriteriaRating

  LEFT JOIN jaf2q_jreviews_criteria AS ListingType 
  ON ListingType.id = CriteriaRating.listing_type_id
 
  WHERE 1 = 1 
  AND ( 
   CriteriaRating.listing_type_id = 13
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	CriteriaRating	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	30	Using where
1	SIMPLE	ListingType	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
13	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
12	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
11	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:353
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 7.339 MB Rows returned: 1

SELECT
                count(DISTINCT groupid)
            
  FROM
                jaf2q_jreviews_criteria
            
  WHERE
                groupid != ''

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
12	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:2136
11	FieldModel->getOrderList()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:360
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 7.347 MB Rows returned: 5

Duplicate queries: #31

SELECT
                    groupid
                
  FROM jaf2q_jreviews_groups
                
  WHERE
                    groupid IN (17,19,7,14,18)
                    
  AND type = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_groups	ref	PRIMARY,type	type	152	const	13	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
13	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:632
12	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:2140
11	FieldModel->getOrderList()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:360
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 7.355 MB Rows returned: 0

SELECT
                        Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access
                    
  FROM
                        jaf2q_jreviews_fields AS Field
                    
  WHERE
                        Field.location = 'content'
                        
  AND Field.listsort = 1
                        
  AND Field.groupid IN (17,19,7,14,18)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	ref\|filter	groupid,listsort	listsort\|groupid	1\|4	const	1 (20%)	Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
12	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:2156
11	FieldModel->getOrderList()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:360
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 7.368 MB Rows returned: 1

Duplicate queries: #50 #56 #62 #68

SELECT
                    Category.id
                
  FROM
                    jaf2q_categories AS Category,
                    jaf2q_categories AS ParentCategory
                
  WHERE
                    Category.published >= 0
                    
  AND Category.extension = "com_content"
                    
  AND Category.access IN ( 1,5)
                    
  AND Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                    
  AND ParentCategory.id = 47

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ParentCategory	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	Category	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	1 (47%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:420
14	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:282
13	EverywhereComContentModel->addCategoryFiltering()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:225
12	ListingsRepositoryComponent->prepareQueryData()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:166
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.01 ms Query memory: 0.024 MB Memory before query: 7.376 MB Rows returned: 6

Duplicate queries: #51 #57 #63 #69

SELECT id 
  FROM jaf2q_jreviews_categories 
  WHERE `option` = "com_content"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_categories	ref	option	option	152	const	6	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:428
14	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:282
13	EverywhereComContentModel->addCategoryFiltering()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:225
12	ListingsRepositoryComponent->prepareQueryData()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:166
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.38 ms After last query: 0.10 ms Query memory: 0.043 MB Memory before query: 7.405 MB Rows returned: 3

SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.fulltext AS `Listing.description`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Field.featured AS `Listing.featured`,
JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
User.block AS `User.block`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.user_review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`,
Field.jr_latitude AS `Geomaps.lat`,
Field.jr_longitude AS `Geomaps.lon`,
JreviewsCategory.marker_icon AS `Geomaps.marker_icon`
 
  FROM jaf2q_jreviews_content AS Field USE KEY (featured)

  LEFT JOIN jaf2q_content AS Listing 
  ON Field.contentid = Listing.id

  LEFT JOIN jaf2q_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content'

  LEFT JOIN jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content'

  LEFT JOIN jaf2q_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content'

  LEFT JOIN jaf2q_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid

  LEFT JOIN jaf2q_users AS User 
  ON User.id = Listing.created_by

  LEFT JOIN jaf2q_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1
 
  WHERE 1 = 1 
  AND ( 
   Listing.catid IN (47)
   
  AND Listing.state = 1
   
  AND Listing.access IN ( 1,5)
   
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-24 22:00:00" )
   
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-23 22:00:00" )
 )
 
  ORDER BY Field.featured DESC, Field.contentid DESC
 
  LIMIT 20, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	338	Using temporary; Using filesort
1	SIMPLE	Listing	eq_ref	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	idx_state	5	const,bimdir_db.Field.contentid	1	Using index condition; Using where
1	SIMPLE	Totals	eq_ref	PRIMARY	PRIMARY	156	bimdir_db.Listing.id,const	1	Using where
1	SIMPLE	JreviewsCategory	const	PRIMARY,option	PRIMARY	156	const,const	1	Using where
1	SIMPLE	Category	const	PRIMARY,cat_idx	PRIMARY	4	const	1	Using where
1	SIMPLE	Directory	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.JreviewsCategory.dirid	1	Using where
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.created_by	1	Using where
1	SIMPLE	Claim	ALL	listing_id,user_id,approved	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
14	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 7.482 MB Rows returned: 5

Duplicate queries: #26

SELECT
                    groupid
                
  FROM jaf2q_jreviews_groups
                
  WHERE
                    groupid IN (17,19,7,14,18)
                    
  AND type = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_groups	ref	PRIMARY,type	type	152	const	13	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
18	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:632
17	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:898
16	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
15	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:676
14	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.028 MB Memory before query: 7.494 MB Rows returned: 7

SELECT
                Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`,
                Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`,
                Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`,
                Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`,
                Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`,
                Field.published As `Field.published`, Field.ordering AS `Field.ordering`,
                `
  Group`.groupid AS `
  Group.group_id`, `
  Group`.title AS `
  Group.title`, `
  Group`.name AS `
  Group.name`, `
  Group`.showtitle AS `
  Group.showTitle`, `
  Group`.ordering AS `
  Group.ordering`
         
  FROM
            jaf2q_jreviews_fields AS Field
         
  LEFT JOIN
            jaf2q_jreviews_groups AS `
  Group` 
  ON `
  Group`.groupid = Field.groupid
         
  WHERE
            Field.published = 1
            
  AND Field.location = 'content'
            
  AND Field.groupid IN ( 17,19,7,14,18)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	range	groupid,entry_published,list_published	groupid	4	NULL	7	Using index condition; Using where
1	SIMPLE	Group	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Field.groupid	1

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:929
16	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
15	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:676
14	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 7.528 MB Rows returned: 3

SELECT
                            Listing.contentid AS element_id,jr_language,jr_topics,jr_author,jr_publisher,jr_solutions,jr_url,jr_amazon
                        
  FROM
                            jaf2q_jreviews_content AS Listing
                        
  WHERE
                            Listing.contentid IN (212,211,210)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY	PRIMARY	4	NULL	3	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1014
16	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
15	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:676
14	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.03 ms Query memory: 0.029 MB Memory before query: 7.545 MB Rows returned: 21

SELECT
                        *
                    
  FROM
                        jaf2q_jreviews_fieldoptions
                    
  WHERE
                        fieldid IN ( '59','61','58')
                        
  AND
                        value IN ( 'best-practices','bim-implementation','
  case-studies','tips','robert-klaschka','nbs','bim-level-2','bim-roles','bim-workflows','methodology','david-shepherd','collaboration-tools','integrated-project-delivery','interoperability','lean-construction','sustainable-building','chuck-eastman','paul-teicholz','rafael-sacks','kathleen-liston','wiley')
                    
  ORDER
                        BY ordering ASC ,optionid ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_fieldoptions	range\|filter	fieldid,field_value	field_value\|fieldid	767\|4	NULL	21 (31%)	Using index condition; Using where; Using filesort; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1115
16	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
15	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:676
14	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.34 ms Query memory: 0.025 MB Memory before query: 7.626 MB Rows returned: 0

SELECT
                content_id AS listing_id, count(*) AS favored 
  FROM jaf2q_jreviews_favorites AS Favorite
		    
  WHERE
                Favorite.content_id IN (212,211,210)
		    
  GROUP BY
                listing_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Favorite	range	user_favorite	user_favorite	4	NULL	3	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
16	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/favorite.php:91
15	FavoriteModel->addFavorite()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:794
14	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 7.650 MB Rows returned: 3

SELECT
						media.media_id,
						media.media_type,
						media.media_function,
						media.likes_rank,
						media.likes_up,
						media.likes_total,
						media.created,
						media.main_media,
						media.listing_id,
						media.review_id,
						media.user_id,
						media.filename,
						media.file_extension,
						media.rel_path,
						media.title,
						media.description,
						media.media_info,
						media.metadata,
						media.embed,
						media.published,
						media.approved,
						media.access,
						media.views,
						media.filesize,
						media.extension
					
  FROM
						jaf2q_jreviews_media AS media
					
  WHERE

						listing_id IN (212,211,210)

						
  AND published = 1 
  AND approved = 1

						
  AND access IN (1,5)

						
  AND main_media = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	media	range	listing	listing	4	NULL	9	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media.php:1536
16	MediaModel->addMediaDetail()	JROOT/components/com_jreviews/jreviews/models/media.php:1155
15	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:818
14	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.22 ms Query memory: 0.028 MB Memory before query: 7.680 MB Rows returned: 3

SELECT PaidOrder.*,
User.id AS `User.user_id`,
User. name AS `User.name`,
User. email AS `User.email`,
PaidHandler.name AS `PaidHandler.handler_name`
 
  FROM jaf2q_jreviews_paid_orders AS `PaidOrder`

  LEFT JOIN jaf2q_users AS User 
  ON PaidOrder.user_id = User.id

  LEFT JOIN jaf2q_jreviews_paid_handlers AS PaidHandler 
  ON PaidOrder.handler_id = PaidHandler.handler_id
 
  WHERE 1 = 1 
  AND ( 
   `PaidOrder`.listing_id IN (212,211,210)
   
  AND `PaidOrder`.order_status IN ('Complete')
   
  AND `PaidOrder`.order_active = 1
 )
 
  ORDER BY `PaidOrder`.order_created ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	PaidOrder	range	listing_id,order_status,order_active	listing_id	4	NULL	3	Using index condition; Using where; Using filesort
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.PaidOrder.user_id	1
1	SIMPLE	PaidHandler	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.PaidOrder.handler_id	1

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
22	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
19	S2ModelCore->findAll()	JROOT/components/com_jreviews_addons/paidlistings/models/paid_order.php:241
18	PaidOrderModel->completeOrderInfo()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings.php:1180
17	PaidlistingsComponent->processPaidData()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings.php:283
16	PaidlistingsComponent->plgAfterAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
15	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:111
14	MyModel->plgAfterAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:451
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.08 ms Query memory: 0.043 MB Memory before query: 7.718 MB Rows returned: 237

SELECT PaidCountry.id,
PaidCountry.country_code,
PaidCountry.country_name
 
  FROM jaf2q_jreviews_paid_countries AS `PaidCountry`
 
  ORDER BY PaidCountry.country_name ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
25	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
24	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
23	S2ModelCore->findAll()	JROOT/components/com_jreviews_addons/paidlistings/models/paid_country.php:39
22	PaidCountryModel->getCountries()	JROOT/components/com_jreviews_addons/paidlistings/models/paid_order.php:556
21	PaidOrderModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
19	S2ModelCore->findAll()	JROOT/components/com_jreviews_addons/paidlistings/models/paid_order.php:241
18	PaidOrderModel->completeOrderInfo()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings.php:1180
17	PaidlistingsComponent->processPaidData()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings.php:283
16	PaidlistingsComponent->plgAfterAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
15	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:111
14	MyModel->plgAfterAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:451
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.34 ms Query memory: 0.047 MB Memory before query: 7.803 MB Rows returned: 3

SELECT Listing.id AS `Listing.listing_id`,
Listing.alias AS `Listing.slug`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.fulltext AS `Listing.description`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.modified AS `Listing.modified`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.publish_down AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Field.featured AS `Listing.featured`,
JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.alias AS `Category.slug`,
Category.params AS `Category.params`,
Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.slug`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
User.block AS `User.block`,
Claim.approved AS `Claim.approved`,
Totals.user_rating AS `Review.user_rating`,
Totals.user_rating_count AS `Review.user_rating_count`,
Totals.user_criteria_rating AS `Review.user_criteria_rating`,
Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
Totals.user_comment_count AS `Review.user_review_count`,
Totals.editor_rating AS `Review.editor_rating`,
Totals.editor_rating_count AS `Review.editor_rating_count`,
Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
Totals.editor_comment_count AS `Review.editor_review_count`,
Totals.media_count AS `Listing.media_count`,
Totals.video_count AS `Listing.video_count`,
Totals.photo_count AS `Listing.photo_count`,
Totals.audio_count AS `Listing.audio_count`,
Totals.attachment_count AS `Listing.attachment_count`,
(Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
(Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
(Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
(Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
(Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
Totals.media_count_user AS `Listing.media_count_user`,
Totals.video_count_user AS `Listing.video_count_user`,
Totals.photo_count_user AS `Listing.photo_count_user`,
Totals.audio_count_user AS `Listing.audio_count_user`,
Totals.attachment_count_user AS `Listing.attachment_count_user`
 
  FROM jaf2q_content AS Listing

  LEFT JOIN jaf2q_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content'

  LEFT JOIN jaf2q_jreviews_content AS Field 
  ON Field.contentid = Listing.id

  LEFT JOIN jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content'

  LEFT JOIN jaf2q_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content'

  LEFT JOIN jaf2q_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid

  LEFT JOIN jaf2q_users AS User 
  ON User.id = Listing.created_by

  LEFT JOIN jaf2q_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1
 
  WHERE 1 = 1 
  AND ( 
   Listing.id IN (210,211,212)
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY	PRIMARY	4	NULL	3	Using where
1	SIMPLE	Totals	eq_ref	PRIMARY	PRIMARY	156	bimdir_db.Listing.id,const	1	Using where
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where
1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Listing.catid,const	1	Using where
1	SIMPLE	Category	eq_ref	PRIMARY,cat_idx	PRIMARY	4	bimdir_db.Listing.catid	1	Using where
1	SIMPLE	Directory	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.created_by	1	Using where
1	SIMPLE	Claim	ALL	listing_id,user_id,approved	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
25	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
24	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
23	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
22	S2ModelCore->findAll()	JROOT/components/com_jreviews_addons/paidlistings/models/paid_order.php:587
21	PaidOrderModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
19	S2ModelCore->findAll()	JROOT/components/com_jreviews_addons/paidlistings/models/paid_order.php:241
18	PaidOrderModel->completeOrderInfo()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings.php:1180
17	PaidlistingsComponent->processPaidData()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings.php:283
16	PaidlistingsComponent->plgAfterAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
15	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:111
14	MyModel->plgAfterAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:451
13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
12	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
11	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 7.777 MB Rows returned: 1

SELECT COUNT(*)
 
  FROM jaf2q_jreviews_content AS Field

  LEFT JOIN jaf2q_content AS Listing 
  ON Field.contentid = Listing.id
 
  WHERE 1 = 1 
  AND ( 
   Listing.catid IN (47)
   
  AND Listing.state = 1
   
  AND Listing.access IN ( 1,5)
   
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-24 22:00:00" )
   
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-23 22:00:00" )
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	jr_listing_count	14	NULL	24	Using where; Using index
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
13	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:286
12	S2ModelCore->findCount()	JROOT/components/com_jreviews/jreviews/repositories/base_repository.php:290
11	BaseRepository->count()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:443
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 7.783 MB Rows returned: 1

SELECT Directory.id AS `Directory.dir_id`,
Directory.desc AS `Directory.title`,
Directory.title AS `Directory.name`,
Directory.tmpl_suffix AS `Directory.tmpl_suffix`,
Directory.title AS `Directory.slug`
 
  FROM jaf2q_jreviews_directories AS Directory
 
  WHERE 1 = 1 
  AND ( 
   Directory.id = 1
 )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
13	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
12	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
11	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:469
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.68 ms Query memory: 0.119 MB Memory before query: 8.002 MB Rows returned: 47

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

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

  LEFT JOIN jaf2q_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	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	51	Using index condition; Using where; Using filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	bimdir_db.m.module,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406
24	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
23	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
22	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
21	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:377
20	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
19	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:44
18	JreviewsHelper->loadModulePosition()	JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_header.thtml:110
17	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_header.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
16	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:333
15	MyView->renderControllerView()	JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_masonry.thtml:29
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_masonry.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
13	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
12	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
11	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:696
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 4.23 ms Query memory: 0.033 MB Memory before query: 8.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 `jaf2q_categories` AS `s`

  INNER JOIN `jaf2q_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	17	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
32	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
31	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
30	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
29	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
28	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2513
27	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1036
26	JReviewsRouter->buildRule()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
24	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1164
18	cmsFramework::route()	JROOT/components/com_s2framework/s2framework/libs/view/helpers/html.php:151
17	HtmlHelper->sefLink()	JROOT/components/com_s2framework/s2framework/libs/view/helpers/html.php:137
16	HtmlHelper->link()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:571
15	RoutesHelper->content()	JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_masonry.thtml:67
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_masonry.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
13	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
12	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
11	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:696
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:106
9	CategoriesController->category()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 1.08 ms Query memory: 0.024 MB Memory before query: 8.501 MB Rows returned: 1

SELECT
                    dirid, criteriaid
                
  FROM
                    jaf2q_jreviews_categories
                
  WHERE
                    id IN (47)
                     
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1943
14	FieldModel->getFieldGroupIdsByCatId()	JROOT/components/com_jreviews/jreviews/models/field.php:1861
13	FieldModel->getFieldNames()	JROOT/components/com_jreviews_addons/geomaps/plugins/geomaps_assets.php:303
12	GeomapsAssetsComponent->assetsSite()	JROOT/components/com_jreviews_addons/geomaps/plugins/geomaps_assets.php:118
11	GeomapsAssetsComponent->plgBeforeAfterFilter()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:331
10	S2Controller->beforeAfterFilter()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:304
9	MyController->beforeAfterFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:356
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 8.514 MB Rows returned: 1

SELECT Field.fieldid AS `Field.fieldid`,
Field.name AS `Field.name`,
Field.title AS `Field.title`,
Field.type AS `Field.type`,
Field.required AS `Field.required`,
Field.access AS `Field.access`,
Field.access_view AS `Field.access_view`,
Field.options AS `Field.options`,
Field.showtitle AS `Field.showtitle`,
Field.description AS `Field.description`,
Field.groupid AS `Field.groupid`,
Field.location AS `Field.location`,
Field.size AS `Field.size`,
Field.maxlength AS `Field.maxlength`,
Field.cols AS `Field.cols`,
Field.rows AS `Field.rows`,
Field.contentview AS `Field.contentview`,
Field.ordering AS `Field.ordering`,
Field.listview AS `Field.listview`,
Field.compareview AS `Field.compareview`,
Field.listsort AS `Field.listsort`,
Field.search AS `Field.search`,
Field.published AS `Field.published`,
Field.control_field AS `Field.control_field`,
Field.control_value AS `Field.control_value`
 
  FROM jaf2q_jreviews_fields AS `Field`
 
  WHERE 1 = 1 
  AND ( 
   Field.location = 'content'
   
  AND Field.published = 1
   
  AND Field.type IN ('text','decimal')
   
  AND Field.groupid IN (17,19,7,14,18)
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	range	groupid,entry_published,list_published	groupid	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
16	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
15	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
14	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/models/field.php:1905
13	FieldModel->getFieldNames()	JROOT/components/com_jreviews_addons/geomaps/plugins/geomaps_assets.php:303
12	GeomapsAssetsComponent->assetsSite()	JROOT/components/com_jreviews_addons/geomaps/plugins/geomaps_assets.php:118
11	GeomapsAssetsComponent->plgBeforeAfterFilter()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:331
10	S2Controller->beforeAfterFilter()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:304
9	MyController->beforeAfterFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:356
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 1.67 ms Query memory: 0.021 MB Memory before query: 8.535 MB Rows returned: 0

SELECT *

  FROM `jaf2q_opengraph_action`

  WHERE `published`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jfbconnect/models/opengraphaction.php:80
10	JFBConnectModelOpenGraphAction->getActions()	JROOT/components/com_jfbconnect/libraries/profile/facebook.php:114
9	JFBConnectProfileFacebook->getRequiredScope()	JROOT/components/com_jfbconnect/libraries/provider/facebook.php:263
8	JFBConnectProviderFacebook->onAfterDispatch()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:90
7	plgSystemJFBCSystem->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select b.* 
  from jaf2q_rstbox b 
  where b.published = 1  
  AND b.testmode=0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:242
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 3.30 ms Query memory: 0.025 MB Memory before query: 8.863 MB Rows returned: 1

Duplicate queries: #54 #60 #66

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (47)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:161
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 8.875 MB Rows returned: 1

Duplicate queries: #55 #61 #67

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,Category.title AS text
			
  FROM
				jaf2q_categories AS Category
            RIGHT JOIN
                jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'
			
  WHERE
				Category.published = 1
				
  AND Category.access IN ( 1,5  )
                
  AND Category.level > 0 
  AND Category.extension = 'com_content'  
  AND ((Category.path = 'books' OR Category.path LIKE 'books/%'))
			
  ORDER BY
				Category.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	range\|filter	PRIMARY,cat_idx,idx_access,idx_path	idx_path\|cat_idx	402\|207	NULL	2 (41%)	Using where; Using filesort; Using rowid filter
1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Category.id,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:267
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 8.885 MB Rows returned: 1

Duplicate queries: #28 #56 #62 #68

SELECT
                    Category.id
                
  FROM
                    jaf2q_categories AS Category,
                    jaf2q_categories AS ParentCategory
                
  WHERE
                    Category.published >= 0
                    
  AND Category.extension = "com_content"
                    
  AND Category.access IN ( 1,5)
                    
  AND Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                    
  AND ParentCategory.id = 47

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ParentCategory	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	Category	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	1 (47%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:420
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 8.895 MB Rows returned: 6

Duplicate queries: #29 #57 #63 #69

SELECT id 
  FROM jaf2q_jreviews_categories 
  WHERE `option` = "com_content"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_categories	ref	option	option	152	const	6	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:428
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 8.905 MB Rows returned: 23

SELECT
                jr_topics AS value, count(*) AS total
            
  FROM
                jaf2q_jreviews_content AS Field
            
  LEFT JOIN
                jaf2q_content AS Listing 
  ON Listing.id = Field.contentid
            
  WHERE
                jr_topics <> ""
                
  AND Listing.catid IN (47) 
                
  AND Listing.state = 1
                
  AND Listing.access IN (1,5)
                
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-24 22:00:00" )
                
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-23 22:00:00" )
            
  GROUP BY
                jr_topics
            
  ORDER BY
                jr_topics

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	jr_listing_count	14	NULL	24	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:542
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.08 ms Query memory: 0.039 MB Memory before query: 8.943 MB Rows returned: 74

SELECT FieldOption.optionid AS `FieldOption.optionid`,
FieldOption.value AS `FieldOption.value`,
FieldOption.image AS `FieldOption.image`,
FieldOption.default AS `FieldOption.default`,
FieldOption.description AS `FieldOption.description`,
FieldOption.control_field AS `FieldOption.control_field`,
FieldOption.control_value AS `FieldOption.control_value`,
Field.name AS `FieldOption.name`,
Field.location AS `FieldOption.location`,
FieldOption.text AS `FieldOption.text`
 
  FROM jaf2q_jreviews_fieldoptions AS `FieldOption`

  LEFT JOIN jaf2q_jreviews_fields AS Field 
  ON FieldOption.fieldid = Field.fieldid
 
  WHERE 1 = 1 
  AND ( 
   Field.name = 'jr_topics'
 )
 
  ORDER BY FieldOption.text

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	const	PRIMARY,name	name	152	const	1
1	SIMPLE	FieldOption	ALL	fieldid	NO INDEX KEY COULD BE USED	NULL	NULL	341	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
19	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
18	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:297
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 20.28 ms Query memory: 0.025 MB Memory before query: 9.822 MB Rows returned: 1

Duplicate queries: #48 #60 #66

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (47)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:161
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 9.834 MB Rows returned: 1

Duplicate queries: #49 #61 #67

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,Category.title AS text
			
  FROM
				jaf2q_categories AS Category
            RIGHT JOIN
                jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'
			
  WHERE
				Category.published = 1
				
  AND Category.access IN ( 1,5  )
                
  AND Category.level > 0 
  AND Category.extension = 'com_content'  
  AND ((Category.path = 'books' OR Category.path LIKE 'books/%'))
			
  ORDER BY
				Category.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	range\|filter	PRIMARY,cat_idx,idx_access,idx_path	idx_path\|cat_idx	402\|207	NULL	2 (41%)	Using where; Using filesort; Using rowid filter
1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Category.id,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:267
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 9.844 MB Rows returned: 1

Duplicate queries: #28 #50 #62 #68

SELECT
                    Category.id
                
  FROM
                    jaf2q_categories AS Category,
                    jaf2q_categories AS ParentCategory
                
  WHERE
                    Category.published >= 0
                    
  AND Category.extension = "com_content"
                    
  AND Category.access IN ( 1,5)
                    
  AND Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                    
  AND ParentCategory.id = 47

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ParentCategory	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	Category	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	1 (47%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:420
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 9.854 MB Rows returned: 6

Duplicate queries: #29 #51 #63 #69

SELECT id 
  FROM jaf2q_jreviews_categories 
  WHERE `option` = "com_content"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_categories	ref	option	option	152	const	6	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:428
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 9.864 MB Rows returned: 18

SELECT
                jr_author AS value, count(*) AS total
            
  FROM
                jaf2q_jreviews_content AS Field
            
  LEFT JOIN
                jaf2q_content AS Listing 
  ON Listing.id = Field.contentid
            
  WHERE
                jr_author <> ""
                
  AND Listing.catid IN (47) 
                
  AND Listing.state = 1
                
  AND Listing.access IN (1,5)
                
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-24 22:00:00" )
                
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-23 22:00:00" )
            
  GROUP BY
                jr_author
            
  ORDER BY
                jr_author

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	jr_listing_count	14	NULL	24	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:542
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.034 MB Memory before query: 9.890 MB Rows returned: 28

SELECT FieldOption.optionid AS `FieldOption.optionid`,
FieldOption.value AS `FieldOption.value`,
FieldOption.image AS `FieldOption.image`,
FieldOption.default AS `FieldOption.default`,
FieldOption.description AS `FieldOption.description`,
FieldOption.control_field AS `FieldOption.control_field`,
FieldOption.control_value AS `FieldOption.control_value`,
Field.name AS `FieldOption.name`,
Field.location AS `FieldOption.location`,
FieldOption.text AS `FieldOption.text`
 
  FROM jaf2q_jreviews_fieldoptions AS `FieldOption`

  LEFT JOIN jaf2q_jreviews_fields AS Field 
  ON FieldOption.fieldid = Field.fieldid
 
  WHERE 1 = 1 
  AND ( 
   Field.name = 'jr_author'
 )
 
  ORDER BY FieldOption.text

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	const	PRIMARY,name	name	152	const	1
1	SIMPLE	FieldOption	ref	fieldid	fieldid	4	const	28	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
19	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
18	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:297
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 3.92 ms Query memory: 0.025 MB Memory before query: 10.251 MB Rows returned: 1

Duplicate queries: #48 #54 #66

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (47)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:161
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 10.263 MB Rows returned: 1

Duplicate queries: #49 #55 #67

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,Category.title AS text
			
  FROM
				jaf2q_categories AS Category
            RIGHT JOIN
                jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'
			
  WHERE
				Category.published = 1
				
  AND Category.access IN ( 1,5  )
                
  AND Category.level > 0 
  AND Category.extension = 'com_content'  
  AND ((Category.path = 'books' OR Category.path LIKE 'books/%'))
			
  ORDER BY
				Category.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	range\|filter	PRIMARY,cat_idx,idx_access,idx_path	idx_path\|cat_idx	402\|207	NULL	2 (41%)	Using where; Using filesort; Using rowid filter
1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Category.id,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:267
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 10.273 MB Rows returned: 1

Duplicate queries: #28 #50 #56 #68

SELECT
                    Category.id
                
  FROM
                    jaf2q_categories AS Category,
                    jaf2q_categories AS ParentCategory
                
  WHERE
                    Category.published >= 0
                    
  AND Category.extension = "com_content"
                    
  AND Category.access IN ( 1,5)
                    
  AND Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                    
  AND ParentCategory.id = 47

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ParentCategory	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	Category	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	1 (47%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:420
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 10.283 MB Rows returned: 6

Duplicate queries: #29 #51 #57 #69

SELECT id 
  FROM jaf2q_jreviews_categories 
  WHERE `option` = "com_content"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_categories	ref	option	option	152	const	6	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:428
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 10.294 MB Rows returned: 5

SELECT
                jr_publisher AS value, count(*) AS total
            
  FROM
                jaf2q_jreviews_content AS Field
            
  LEFT JOIN
                jaf2q_content AS Listing 
  ON Listing.id = Field.contentid
            
  WHERE
                jr_publisher <> ""
                
  AND Listing.catid IN (47) 
                
  AND Listing.state = 1
                
  AND Listing.access IN (1,5)
                
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-24 22:00:00" )
                
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-23 22:00:00" )
            
  GROUP BY
                jr_publisher
            
  ORDER BY
                jr_publisher

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	jr_listing_count	14	NULL	24	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:542
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.032 MB Memory before query: 10.321 MB Rows returned: 5

SELECT FieldOption.optionid AS `FieldOption.optionid`,
FieldOption.value AS `FieldOption.value`,
FieldOption.image AS `FieldOption.image`,
FieldOption.default AS `FieldOption.default`,
FieldOption.description AS `FieldOption.description`,
FieldOption.control_field AS `FieldOption.control_field`,
FieldOption.control_value AS `FieldOption.control_value`,
Field.name AS `FieldOption.name`,
Field.location AS `FieldOption.location`,
FieldOption.text AS `FieldOption.text`
 
  FROM jaf2q_jreviews_fieldoptions AS `FieldOption`

  LEFT JOIN jaf2q_jreviews_fields AS Field 
  ON FieldOption.fieldid = Field.fieldid
 
  WHERE 1 = 1 
  AND ( 
   Field.name = 'jr_publisher'
 )
 
  ORDER BY FieldOption.text

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	const	PRIMARY,name	name	152	const	1
1	SIMPLE	FieldOption	ref	fieldid	fieldid	4	const	5	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
19	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
18	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:297
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 1.41 ms Query memory: 0.025 MB Memory before query: 10.441 MB Rows returned: 1

Duplicate queries: #48 #54 #60

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (47)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:161
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 10.453 MB Rows returned: 1

Duplicate queries: #49 #55 #61

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,Category.title AS text
			
  FROM
				jaf2q_categories AS Category
            RIGHT JOIN
                jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'
			
  WHERE
				Category.published = 1
				
  AND Category.access IN ( 1,5  )
                
  AND Category.level > 0 
  AND Category.extension = 'com_content'  
  AND ((Category.path = 'books' OR Category.path LIKE 'books/%'))
			
  ORDER BY
				Category.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	range\|filter	PRIMARY,cat_idx,idx_access,idx_path	idx_path\|cat_idx	402\|207	NULL	2 (41%)	Using where; Using filesort; Using rowid filter
1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Category.id,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:267
18	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:106
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #28 #50 #56 #62

SELECT
                    Category.id
                
  FROM
                    jaf2q_categories AS Category,
                    jaf2q_categories AS ParentCategory
                
  WHERE
                    Category.published >= 0
                    
  AND Category.extension = "com_content"
                    
  AND Category.access IN ( 1,5)
                    
  AND Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                    
  AND ParentCategory.id = 47

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ParentCategory	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	Category	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	1 (47%)	Using index condition; Using where; Using rowid filter

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:420
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 10.473 MB Rows returned: 6

Duplicate queries: #29 #51 #57 #63

SELECT id 
  FROM jaf2q_jreviews_categories 
  WHERE `option` = "com_content"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_categories	ref	option	option	152	const	6	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:428
19	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:510
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.01 ms Query memory: 0.025 MB Memory before query: 10.484 MB Rows returned: 2

SELECT
                jr_solutions AS value, count(*) AS total
            
  FROM
                jaf2q_jreviews_content AS Field
            
  LEFT JOIN
                jaf2q_content AS Listing 
  ON Listing.id = Field.contentid
            
  WHERE
                jr_solutions <> ""
                
  AND Listing.catid IN (47) 
                
  AND Listing.state = 1
                
  AND Listing.access IN (1,5)
                
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-24 22:00:00" )
                
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-23 22:00:00" )
            
  GROUP BY
                jr_solutions
            
  ORDER BY
                jr_solutions

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	jr_listing_count	14	NULL	24	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:542
18	EverywhereComContentModel->getFieldOptionUsageCount()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:216
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 10.500 MB Rows returned: 25

SELECT FieldOption.optionid AS `FieldOption.optionid`,
FieldOption.value AS `FieldOption.value`,
FieldOption.image AS `FieldOption.image`,
FieldOption.default AS `FieldOption.default`,
FieldOption.description AS `FieldOption.description`,
FieldOption.control_field AS `FieldOption.control_field`,
FieldOption.control_value AS `FieldOption.control_value`,
Field.name AS `FieldOption.name`,
Field.location AS `FieldOption.location`,
FieldOption.text AS `FieldOption.text`
 
  FROM jaf2q_jreviews_fieldoptions AS `FieldOption`

  LEFT JOIN jaf2q_jreviews_fields AS Field 
  ON FieldOption.fieldid = Field.fieldid
 
  WHERE 1 = 1 
  AND ( 
   Field.name = 'jr_solutions'
 )
 
  ORDER BY FieldOption.text

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	const	PRIMARY,name	name	152	const	1
1	SIMPLE	FieldOption	ref	fieldid	fieldid	4	const	25	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
20	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
19	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
18	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_fields_controller.php:297
17	ModuleFieldsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
15	JreviewsModuleHelper::renderModule()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
12	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:151
11	JreviewsModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php:40
10	include JROOT/modules/mod_jreviews_fields/mod_jreviews_fields.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 2.86 ms Query memory: 0.022 MB Memory before query: 10.530 MB Rows returned: 0

SELECT *
 
  FROM jaf2q_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.bimlar.com/books'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jmap_metainfo	ref	linkurl,published	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:350
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 2.65 ms Query memory: 0.027 MB Memory before query: 10.853 MB Rows returned: 84

SELECT * 
  FROM jaf2q_acymailing_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:450
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:789
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1096
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

54 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT                     Category.id                 
  FROM                     jaf2q_categories AS Category,                     jaf2q_categories AS ParentCategory

5 × SELECT id 
  FROM jaf2q_jreviews_categories

4 × SELECT FieldOption.optionid AS `FieldOption.optionid`, FieldOption.value AS `FieldOption.value`, FieldOption.image AS `FieldOption.image`, FieldOption.default AS `FieldOption.default`, FieldOption.description AS `FieldOption.description`, FieldOption.control_field AS `FieldOption.control_field`, FieldOption.control_value AS `FieldOption.control_value`, Field.name AS `FieldOption.name`, Field.location AS `FieldOption.location`, FieldOption.text AS `FieldOption.text`  
  FROM jaf2q_jreviews_fieldoptions AS `FieldOption` 
  LEFT JOIN jaf2q_jreviews_fields AS Field 
  ON FieldOption.fieldid = Field.fieldid

4 × SELECT                 Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,Category.title AS text    
  FROM     jaf2q_categories AS Category             RIGHT JOIN                 jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Category.id 
  AND JreviewsCategory.`option` = 'com_content'

4 × SELECT                     path                 
  FROM                     jaf2q_categories

2 × SELECT `manifest_cache` 
  FROM `jaf2q_extensions`

2 × SELECT                     groupid                 
  FROM jaf2q_jreviews_groups

1 × SELECT `data` 
  FROM `jaf2q_session`

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 `jaf2q_categories` AS `s` 
  INNER JOIN `jaf2q_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT PaidCountry.id, PaidCountry.country_code, PaidCountry.country_name  
  FROM jaf2q_jreviews_paid_countries AS `PaidCountry`

1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`  
  FROM jaf2q_content AS Listing 
  LEFT JOIN jaf2q_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content' 
  LEFT JOIN jaf2q_jreviews_content AS Field 
  ON Field.contentid = Listing.id 
  LEFT JOIN jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content' 
  LEFT JOIN jaf2q_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content' 
  LEFT JOIN jaf2q_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid 
  LEFT JOIN jaf2q_users AS User 
  ON User.id = Listing.created_by 
  LEFT JOIN jaf2q_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1

1 × SELECT COUNT(*)  
  FROM jaf2q_jreviews_content AS Field 
  LEFT JOIN jaf2q_content AS Listing 
  ON Field.contentid = Listing.id

1 × SELECT Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.name`, Directory.tmpl_suffix AS `Directory.tmpl_suffix`, Directory.title AS `Directory.slug`  
  FROM jaf2q_jreviews_directories AS Directory

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 jaf2q_modules AS m 
  LEFT JOIN jaf2q_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN jaf2q_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT * 
  FROM `jaf2q_opengraph_action`

1 × SELECT                     dirid, criteriaid                 
  FROM                     jaf2q_jreviews_categories

1 × SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value`  
  FROM jaf2q_jreviews_fields AS `Field`

1 × SELECT       media.media_id,       media.media_type,       media.media_function,       media.likes_rank,       media.likes_up,       media.likes_total,       media.created,       media.main_media,       media.listing_id,       media.review_id,       media.user_id,       media.filename,       media.file_extension,       media.rel_path,       media.title,       media.description,       media.media_info,       media.metadata,       media.embed,       media.published,       media.approved,       media.access,       media.views,       media.filesize,       media.extension      
  FROM       jaf2q_jreviews_media AS media

```
1 × select b.* 
  from jaf2q_rstbox b
```

1 × SELECT                 jr_topics AS value, count(*) AS total             
  FROM                 jaf2q_jreviews_content AS Field             
  LEFT JOIN                 jaf2q_content AS Listing 
  ON Listing.id = Field.contentid

1 × SELECT                 jr_author AS value, count(*) AS total             
  FROM                 jaf2q_jreviews_content AS Field             
  LEFT JOIN                 jaf2q_content AS Listing 
  ON Listing.id = Field.contentid

1 × SELECT                 jr_publisher AS value, count(*) AS total             
  FROM                 jaf2q_jreviews_content AS Field             
  LEFT JOIN                 jaf2q_content AS Listing 
  ON Listing.id = Field.contentid

1 × SELECT                 jr_solutions AS value, count(*) AS total             
  FROM                 jaf2q_jreviews_content AS Field             
  LEFT JOIN                 jaf2q_content AS Listing 
  ON Listing.id = Field.contentid

1 × SELECT *  
  FROM jaf2q_jmap_metainfo

1 × SELECT PaidOrder.*, User.id AS `User.user_id`, User. name AS `User.name`, User. email AS `User.email`, PaidHandler.name AS `PaidHandler.handler_name`  
  FROM jaf2q_jreviews_paid_orders AS `PaidOrder` 
  LEFT JOIN jaf2q_users AS User 
  ON PaidOrder.user_id = User.id 
  LEFT JOIN jaf2q_jreviews_paid_handlers AS PaidHandler 
  ON PaidOrder.handler_id = PaidHandler.handler_id

1 × SELECT                             Listing.contentid AS element_id,jr_language,jr_topics,jr_author,jr_publisher,jr_solutions,jr_url,jr_amazon                         
  FROM                             jaf2q_jreviews_content AS Listing

1 × SELECT                 content_id AS listing_id, count(*) AS favored 
  FROM jaf2q_jreviews_favorites AS Favorite

1 × SELECT                 count(*)             
  FROM                 jaf2q_jreviews_categories

1 × SELECT id, rules 
  FROM `jaf2q_viewlevels

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

1 × SELECT `value` 
  FROM `jaf2q_admintools_storage`

1 × SELECT * 
  FROM `jaf2q_admintools_wafexceptions`

1 × SELECT setting,value 
  FROM jaf2q_jfbconnect_confi

1 × SELECT value 
  FROM jaf2q_jfbconnect_config

1 × SELECT * 
  FROM `jaf2q_admintools_ipautoban`

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

1 × SELECT * 
  FROM `jaf2q_admintools_wafblacklists`

1 × SELECT                         *                     
  FROM                         jaf2q_jreviews_fieldoptions

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

1 × SELECT value 
  FROM jaf2q_jreviews_config

1 × SELECT name 
  FROM jaf2q_jreviews_addons

1 × SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`, CriteriaRating.title AS `CriteriaRating.title`, CriteriaRating.required AS `CriteriaRating.required`, CriteriaRating.weight AS `CriteriaRating.weight`, CriteriaRating.description AS `CriteriaRating.description`, CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`, CriteriaRating.ordering AS `CriteriaRating.ordering`, ListingType.state AS `CriteriaRating.listing_type_state`  
  FROM jaf2q_jreviews_criteria_ratings AS CriteriaRating 
  LEFT JOIN jaf2q_jreviews_criteria AS ListingType 
  ON ListingType.id = CriteriaRating.listing_type_id

1 × SELECT                 count(DISTINCT groupid)             
  FROM                 jaf2q_jreviews_criteria

1 × SELECT                         Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access                     
  FROM                         jaf2q_jreviews_fields AS Field

1 × SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon`  
  FROM jaf2q_jreviews_content AS Field USE KEY (featured) 
  LEFT JOIN jaf2q_content AS Listing 
  ON Field.contentid = Listing.id 
  LEFT JOIN jaf2q_jreviews_listing_totals AS Totals 
  ON Totals.listing_id = Listing.id 
  AND Totals.extension = 'com_content' 
  LEFT JOIN jaf2q_jreviews_categories AS JreviewsCategory 
  ON JreviewsCategory.id = Listing.catid 
  AND JreviewsCategory.`option` = 'com_content' 
  LEFT JOIN jaf2q_categories AS Category 
  ON Category.id = Listing.catid 
  AND Category.extension = 'com_content' 
  LEFT JOIN jaf2q_jreviews_directories AS Directory 
  ON Directory.id = JreviewsCategory.dirid 
  LEFT JOIN jaf2q_users AS User 
  ON User.id = Listing.created_by 
  LEFT JOIN jaf2q_jreviews_claims AS Claim 
  ON Claim.listing_id = Listing.id 
  AND Claim.user_id = Listing.created_by 
  AND Claim.approved = 1

1 × SELECT                 Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`,                 Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`,                 Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`,                 Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`,                 Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`,                 Field.published As `Field.published`, Field.ordering AS `Field.ordering`,                 `
  Group`.groupid AS `
  Group.group_id`, `
  Group`.title AS `
  Group.title`, `
  Group`.name AS `
  Group.name`, `
  Group`.showtitle AS `
  Group.showTitle`, `
  Group`.ordering AS `
  Group.ordering`          
  FROM             jaf2q_jreviews_fields AS Field          
  LEFT JOIN             jaf2q_jreviews_groups AS `
  Group` 
  ON `
  Group`.groupid = Field.groupid

1 × SELECT `session_id` 
  FROM `jaf2q_session`

1 × SELECT * 
  FROM jaf2q_acymailing_confi

OTHER Tables:

1 × INSERT INTO `jaf2q_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'346e6d763139356733727631326f6b35763331726b6f636b7439', 1, 1713948638, 0, '', 0

1 × UPDATE `jaf2q_extensions` 
  SET `params` = '{\"mediaversion\":\"9dcec7d7eba9e9916c4a26500bfcc362\"}'

1 × SHOW VARIABLES LIKE "collation_database

1 × 
  SET NAMES utf8mb4 COLLATE utf8mb4_general_c

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × SHOW TABLES LIKE '%_jreviews_config

Sidebar

Topics

Authors

Publishers

Related solutions

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

73 Queries Logged 23.14 ms

22 duplicate found!

54 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: