BIM Events in « Worcestershire »

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713240132,
                "last": 1713240132,
                "now": 1713240132
            },
            "client": {
                "forwarded": "18.188.40.207"
            },
            "token": "f4vGrZAdx5mG6O6NpS7trqwCsdh02y82"
        },
        "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
        }
    },
    "__jreviews": {
        "geomaps": {
            "ipaddress": "18.188.40.207"
        }
    }
}

Profile Information

Time

Memory

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

Time: 75.70 ms / 78.01 ms Memory: 2.551 MB / 3.29 MB Application: afterInitialise

Time: 1.87 ms / 79.87 ms Memory: 0.168 MB / 3.46 MB Application: Before Access::preloadComponents (all components)

Time: 0.45 ms / 80.33 ms Memory: 0.061 MB / 3.52 MB Application: After Access::preloadComponents (all components)

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

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

Time: 1.48 ms / 81.91 ms Memory: 0.095 MB / 3.62 MB Application: afterRoute

Time: 0.17 ms / 82.08 ms Memory: 0.021 MB / 3.64 MB Application: beforeRenderComponent com_jreviews

Time: 21.07 ms / 103.15 ms Memory: 4.412 MB / 8.05 MB Application: beforeRenderModule mod_jreviews_geomaps (Map (events))

Time: 3.87 ms / 107.02 ms Memory: 0.307 MB / 8.36 MB Application: afterRenderModule mod_jreviews_geomaps (Map (events))

Time: 0.30 ms / 107.31 ms Memory: -0.069 MB / 8.29 MB Application: afterRenderComponent com_jreviews

Time: 0.80 ms / 108.11 ms Memory: 0.025 MB / 8.32 MB Application: Before Access::getAssetRules (id:1 name:root.1)

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

Time: 1.08 ms / 109.21 ms Memory: 0.040 MB / 8.36 MB Application: afterDispatch

Time: 0.85 ms / 110.05 ms Memory: 0.048 MB / 8.41 MB Application: Before Access::getAssetRules (id:218 name:com_jfbconnect)

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

Time: 0.19 ms / 110.25 ms Memory: 0.026 MB / 8.44 MB Application: beforeRenderModule mod_custom (Footer)

Time: 0.16 ms / 110.41 ms Memory: 0.007 MB / 8.44 MB Application: afterRenderModule mod_custom (Footer)

Time: 0.15 ms / 110.56 ms Memory: -0.002 MB / 8.44 MB Application: beforeRenderModule mod_custom (og events)

Time: 0.10 ms / 110.66 ms Memory: 0.003 MB / 8.45 MB Application: afterRenderModule mod_custom (og events)

Time: 0.14 ms / 110.80 ms Memory: 0.008 MB / 8.45 MB Application: beforeRenderModule mod_sclogin (Login)

Time: 2.94 ms / 113.74 ms Memory: 0.150 MB / 8.60 MB Application: afterRenderModule mod_sclogin (Login)

Time: 0.08 ms / 113.82 ms Memory: -0.032 MB / 8.57 MB Application: beforeRenderModule mod_jreviews_advsearch (Search jreviews)

Time: 3.43 ms / 117.25 ms Memory: 0.166 MB / 8.74 MB Application: afterRenderModule mod_jreviews_advsearch (Search jreviews)

Time: 0.02 ms / 117.27 ms Memory: 0.005 MB / 8.74 MB Application: beforeRenderModule mod_jreviews_calendar (Calendar)

Time: 0.89 ms / 118.16 ms Memory: 0.081 MB / 8.82 MB Application: afterRenderModule mod_jreviews_calendar (Calendar)

Time: 0.02 ms / 118.19 ms Memory: 0.000 MB / 8.82 MB Application: beforeRenderModule mod_jreviews_fields (Countries)

Time: 2.42 ms / 120.61 ms Memory: 0.173 MB / 9.00 MB Application: afterRenderModule mod_jreviews_fields (Countries)

Time: 0.02 ms / 120.62 ms Memory: -0.003 MB / 8.99 MB Application: beforeRenderModule mod_jreviews_fields (Cities)

Time: 2.29 ms / 122.91 ms Memory: 0.146 MB / 9.14 MB Application: afterRenderModule mod_jreviews_fields (Cities)

Time: 0.11 ms / 123.02 ms Memory: 0.021 MB / 9.16 MB Application: beforeRenderModule mod_search (Search)

Time: 0.21 ms / 123.23 ms Memory: 0.014 MB / 9.17 MB Application: afterRenderModule mod_search (Search)

Time: 0.16 ms / 123.39 ms Memory: -0.001 MB / 9.17 MB Application: beforeRenderModule mod_sclogin (SCLogin)

Time: 2.29 ms / 125.67 ms Memory: 0.027 MB / 9.20 MB Application: afterRenderModule mod_sclogin (SCLogin)

Time: 22.29 ms / 147.96 ms Memory: 0.964 MB / 10.17 MB Application: afterRender

Database queries total: 26.57 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'363976646669386a32746b6c71666b6f74633730327232343335', 1, 1713240132, 0, '', 0)

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.03 ms
Update	0.13 ms
Waiting for query cache lock	0.02 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.06 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.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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: 1.43 ms After last query: 1.47 ms Query memory: 0.040 MB Memory before query: 1.080 MB Rows returned: 46

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

  FROM `jaf2q_extensions`

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

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.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.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.57 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.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.67 ms After last query: 22.28 ms Query memory: 0.021 MB Memory before query: 1.116 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.10 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.01 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.83 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.128 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.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.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 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.02 ms
Updating status	0.03 ms
Reset for next command	0.02 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: 1.79 ms After last query: 0.54 ms Query memory: 0.051 MB Memory before query: 1.153 MB Rows returned: 140

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

  FROM jaf2q_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.10 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.02 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 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.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:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.87 ms After last query: 5.53 ms Query memory: 0.022 MB Memory before query: 1.578 MB Rows returned: 0

Duplicate queries: #9

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.07 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.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.26 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.02 ms
Updating status	0.03 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.92 ms After last query: 2.67 ms Query memory: 0.022 MB Memory before query: 1.605 MB Rows returned: 0

Duplicate queries: #8

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.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.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.26 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.02 ms
Updating status	0.03 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.64 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 1.610 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.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.08 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 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.02 ms
Updating status	0.03 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.65 ms After last query: 0.70 ms Query memory: 0.021 MB Memory before query: 1.630 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.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.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 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.02 ms
Updating status	0.03 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.61 ms After last query: 4.73 ms Query memory: 0.024 MB Memory before query: 1.911 MB Rows returned: 1

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

  FROM `jaf2q_extensions`

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

Explain

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

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.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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.87 ms After last query: 5.55 ms Query memory: 0.006 MB Memory before query: 1.902 MB

UPDATE `jaf2q_extensions`

  SET `params` = '{\"mediaversion\":\"f0d5fef862ef70d50818893460fdbca3\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.07 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.12 ms
Updating	0.21 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.07 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.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.69 ms After last query: 3.95 ms Query memory: 0.042 MB Memory before query: 2.170 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.06 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.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.24 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.01 ms
Updating status	0.02 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.52 ms After last query: 2.46 ms Query memory: 0.024 MB Memory before query: 2.380 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.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.02 ms
Statistics	0.07 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.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
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.52 ms After last query: 5.81 ms Query memory: 0.022 MB Memory before query: 2.978 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.01 ms
System lock	0.00 ms
table lock	0.01 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.28 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 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.01 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.10 ms After last query: 0.02 ms Query memory: 0.006 MB Memory before query: 2.985 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.01 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.01 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.22 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 2.993 MB Rows returned: 0

SELECT *

  FROM `jaf2q_admintools_ipautoban`

  WHERE `ip` = '18.188.40.207'

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.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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 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
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.14 ms Query memory: 0.021 MB Memory before query: 3.013 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `jaf2q_admintools_redirects`

  WHERE ((`dest` = 'events/tag/city/worcestershire') OR (`dest` = 'events/tag/city/worcestershire') OR ('events/tag/city/worcestershire' 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.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 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.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
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.50 ms After last query: 1.41 ms Query memory: 0.069 MB Memory before query: 3.141 MB Rows returned: 34

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jaf2q_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	53	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.m.component_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.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.20 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.02 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:395
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:511
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:48
8	plgSystemJreviews_sef->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.25 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 3.265 MB Rows returned: 1

SELECT *

  FROM jaf2q_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

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.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.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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
10	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:109
9	JReviewsRouter->__construct()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:50
8	plgSystemJreviews_sef->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.33 ms After last query: 1.80 ms Query memory: 0.021 MB Memory before query: 3.388 MB Rows returned: 1

SELECT *

  FROM `jaf2q_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_jreviews') 
  AND `view` IN('') 
  AND `task` IN('','.') 
  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.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.03 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.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.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.38 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 3.462 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.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
Executing	0.00 ms
Sending data	0.12 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.28 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 3.528 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM jaf2q_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	bimdir_db.s.template,const	1	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.04 ms
Preparing	0.02 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.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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->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.15 ms After last query: 2.65 ms Query memory: 0.006 MB Memory before query: 4.252 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.41 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.259 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.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.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
checking permissions	0.18 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.23 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.265 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.02 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.23 ms After last query: 1.02 ms Query memory: 0.022 MB Memory before query: 4.707 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.35 ms After last query: 8.06 ms Query memory: 0.055 MB Memory before query: 7.286 MB Rows returned: 32

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.search = 1
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	ALL	search,entry_published,list_published	NO INDEX KEY COULD BE USED	NULL	NULL	35	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.01 ms
Statistics	0.05 ms
Preparing	0.01 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
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/models/field.php:1905
11	FieldModel->getFieldNames()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:476
10	ListingsRepositoryComponent->buildFieldsParamsArray()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1065
9	CategoriesController->search()	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.18 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 7.292 MB Rows returned: 1

SELECT
                    name, type
                
  FROM
                    jaf2q_jreviews_fields
                
  WHERE
                    name IN ('jr_city')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_fields	const	name	name	152	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.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:64
13	S2Model->query()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:682
12	ListingsRepositoryComponent->processFieldsConditions()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:336
11	ListingsRepositoryComponent->advancedSearch()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:268
10	ListingsRepositoryComponent->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1148
9	CategoriesController->search()	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.22 ms Query memory: 0.023 MB Memory before query: 7.310 MB Rows returned: 1

SELECT level, path 
  FROM jaf2q_categories 
  WHERE id = 23

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.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.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
15	JDatabaseDriver->loadRow()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
14	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:508
13	CategoryModel->findTree()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:687
12	CategoryModel->findChildren()	JROOT/components/com_jreviews/jreviews/repositories/categories_repository.php:54
11	CategoriesRepositoryComponent->getParents()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:297
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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.319 MB Rows returned: 0

SELECT
                Category.path
            
  FROM
                jaf2q_categories AS Category
            
  WHERE
                Category.extension = "com_content"
                
  AND Category.access NOT IN ( 1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	range	cat_idx,idx_access	idx_access	4	NULL	3	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.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
14	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:526
13	CategoryModel->findTree()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:687
12	CategoryModel->findChildren()	JROOT/components/com_jreviews/jreviews/repositories/categories_repository.php:54
11	CategoriesRepositoryComponent->getParents()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:297
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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.59 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 7.342 MB Rows returned: 1

SELECT
                Category.id AS `Category.cat_id`,
                Category.title AS `Category.title`,
                Category.path AS `Category.path`,
                IF(CategoryListingCount.listing_count > 0,CategoryListingCount.listing_count,0) AS `Category.listing_count`,
                Category.alias AS `Category.slug`,
                Category.level AS `Category.level`,
                Category.params AS `Category.params`,
                Category.parent_id AS `Category.parent_id`,
                Category.metadesc AS `Category.metadesc`,
                Category.metakey AS `Category.metakey`,
                JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
                JreviewsCategory.tmpl AS `Category.tmpl`,
                JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
                Directory.id AS `Directory.dir_id`,
                Directory.desc AS `Directory.title`,
                Directory.title AS `Directory.slug`
            
  FROM
                jaf2q_categories AS Category
             
  LEFT JOIN 
                (
                    SELECT
                        ParentCategory.id, COUNT(Listing.id) as listing_count
                    
  FROM
                        jaf2q_categories AS Category,
                        jaf2q_categories AS ParentCategory,
                        jaf2q_content AS Listing
                    
  WHERE
                         Category.lft BETWEEN ParentCategory.lft 
  AND ParentCategory.rgt
                        
  AND Category.id IN (SELECT id 
  FROM jaf2q_jreviews_categories 
  WHERE `option` = "com_content")
                        
  AND Category.id = Listing.catid
                        
  AND Category.extension = "com_content"
                        
  AND Category.level > 0
                         
  AND (Category.path = "events" OR Category.path LIKE "events/%")
                        
                            
  AND Listing.state = 1
                            
  AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2024-04-16 22:00:00" )
                            
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2024-04-15 22:00:00" )
                            
                    
  GROUP BY
                        ParentCategory.id
                ) AS CategoryListingCount 
  ON CategoryListingCount.id = Category.id

            
  INNER JOIN jaf2q_jreviews_categories AS JreviewsCategory 
  ON Category.id = JreviewsCategory.id 
  AND JreviewsCategory.option = "com_content"

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

            
  WHERE 1 = 1 
  AND (
               Category.published = 1
               
  AND Category.extension = "com_content"
                
  AND (Category.path = "events" OR Category.path LIKE "events/%")
                
  AND Category.level <= 2
               
               
             )

            
  ORDER BY
                Category.lft
                # Removed directory 
  from 
  order by because it makes the query SLOW
                # Instead we run a much faster query below to re-
  order the output array

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	Category	range\|filter	PRIMARY,cat_idx,idx_path	idx_path\|cat_idx	402\|203	NULL	2 (35%)	Using where; Using filesort; Using rowid filter
1	PRIMARY	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Category.id,const	1	Using where
1	PRIMARY	Directory	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.JreviewsCategory.dirid	1
1	PRIMARY	<derived2>	ref	key0	key0	5	bimdir_db.Category.id	10
2	DERIVED	jaf2q_jreviews_categories	ref	PRIMARY,option	option	152	const	6	Using where; Using index; Using temporary; Using filesort
2	DERIVED	Category	eq_ref	PRIMARY,cat_idx,idx_path,idx_left_right	PRIMARY	4	bimdir_db.jaf2q_jreviews_categories.id	1	Using where
2	DERIVED	Listing	ref	idx_state,idx_catid,jr_listing_count	jr_listing_count	5	bimdir_db.jaf2q_jreviews_categories.id,const	9	Using where; Using index
2	DERIVED	ParentCategory	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	17	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 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.05 ms
Optimizing	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Statistics	0.08 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
Executing	0.00 ms
Sending data	0.04 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
Removing tmp table	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
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:64
14	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:623
13	CategoryModel->findTree()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:687
12	CategoryModel->findChildren()	JROOT/components/com_jreviews/jreviews/repositories/categories_repository.php:54
11	CategoriesRepositoryComponent->getParents()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:297
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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.23 ms Query memory: 0.024 MB Memory before query: 7.350 MB Rows returned: 1

Duplicate queries: #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 = 23

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.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:1158
9	CategoriesController->search()	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.18 ms After last query: 0.01 ms Query memory: 0.024 MB Memory before query: 7.359 MB Rows returned: 6

Duplicate queries: #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.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:1158
9	CategoriesController->search()	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.80 ms After last query: 0.17 ms Query memory: 0.040 MB Memory before query: 7.387 MB Rows returned: 0

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 ( 
    (Field.jr_city = '*worcestershire*')
   
  AND Listing.catid IN (23)
   
  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-16 22:00:00" )
   
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-15 22:00:00" )
 )
 
  ORDER BY Field.featured DESC, Field.contentid DESC
 
  LIMIT 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 where; Using temporary; Using filesort
1	SIMPLE	Listing	eq_ref\|filter	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	idx_state\|idx_catid	5\|4	const,bimdir_db.Field.contentid	1 (2%)	Using index condition; Using where; Using rowid filter
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.10 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.01 ms
Removing tmp table	0.03 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:1158
9	CategoriesController->search()	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: 0.07 ms Query memory: 0.023 MB Memory before query: 7.385 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.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: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:1158
9	CategoriesController->search()	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.19 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 7.400 MB Rows returned: 1

SELECT
                    fieldid,
                    type,
                    metatitle,
                    options,
                    metakey,
                    metadesc
                
  FROM
                    jaf2q_jreviews_fields
                
  WHERE
                    name = 'jr_city' 
  AND `location` = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_fields	const	name	name	152	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.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
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/controllers/categories_controller.php:1192
11	CategoriesController->seo_fields()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:546
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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.18 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 7.410 MB Rows returned: 1

SELECT
                            FieldOption.optionid,
                            FieldOption.text,
                            FieldOption.description,
                            FieldOption.control_field,
                            FieldOption.control_value,
                            Field.fieldid AS control_fieldid
                        
  FROM
                            jaf2q_jreviews_fieldoptions AS FieldOption
                        
  LEFT JOIN
                            jaf2q_jreviews_fields AS Field 
  ON FieldOption.control_field = Field.name
                        
  WHERE
                            FieldOption.fieldid = 2
                            
  AND FieldOption.value = 'worcestershire'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	FieldOption	ref	fieldid,field_value	field_value	767	const	1	Using index condition; Using where
1	SIMPLE	Field	eq_ref	name	name	152	bimdir_db.FieldOption.control_field	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.04 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
12	S2Model->query()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1223
11	CategoriesController->seo_fields()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:546
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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: 0.09 ms Query memory: 0.040 MB Memory before query: 7.425 MB Rows returned: 1

SELECT ListingType.id AS `ListingType.listing_type_id`,
ListingType.title AS `ListingType.title`,
ListingType.groupid AS `ListingType.group_id`,
ListingType.state AS `ListingType.state`,
ListingType.search AS `ListingType.search`,
ListingType.config AS `ListingType.config`
 
  FROM jaf2q_jreviews_criteria AS ListingType

  INNER JOIN jaf2q_jreviews_categories AS JreviewCategory 
  ON ListingType.id = JreviewCategory.criteriaid 
  AND JreviewCategory.`option` = 'com_content'
 
  WHERE 1 = 1 
  AND ( 
   JreviewCategory.id = 23
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	JreviewCategory	const	PRIMARY,criteriaid,option	PRIMARY	156	const,const	1
1	SIMPLE	ListingType	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.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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
13	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/models/listing_type.php:118
12	ListingTypeModel->getListingType()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1278
11	CategoriesController->seo_fields()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:546
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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.04 ms Query memory: 0.026 MB Memory before query: 7.455 MB Rows returned: 0

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 IN (2)
 )
 
  ORDER BY CriteriaRating.ordering

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; Using filesort
1	SIMPLE	ListingType	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.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:1506
20	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
19	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
18	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
17	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/models/criteria_rating.php:47
16	CriteriaRatingModel->addCriteriaRatings()	JROOT/components/com_jreviews/jreviews/models/listing_type.php:125
15	ListingTypeModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
13	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/models/listing_type.php:118
12	ListingTypeModel->getListingType()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1278
11	CategoriesController->seo_fields()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:546
10	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
9	CategoriesController->search()	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.59 ms After last query: 0.64 ms Query memory: 0.119 MB Memory before query: 7.635 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.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: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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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: 3.32 ms Query memory: 0.028 MB Memory before query: 8.034 MB Rows returned: 6

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.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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:139
23	JReviewsPrepareModuleList()	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:389
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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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: 1.15 ms Query memory: 0.065 MB Memory before query: 8.207 MB Rows returned: 33

Duplicate queries: #52

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
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	ALL	entry_published,list_published	NO INDEX KEY COULD BE USED	NULL	NULL	35	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.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 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
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
32	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
31	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
30	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/models/field.php:1905
29	FieldModel->getFieldNames()	JROOT/components/com_jreviews/jreviews/controllers/common_controller.php:159
28	CommonController::_discoverIDs()	JROOT/components/com_jreviews_addons/geomaps/controllers/modules/module_geomaps_controller.php:63
27	ModuleGeomapsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
26	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
25	JreviewsModuleHelper::renderModule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php:42
21	include JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:53
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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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.18 ms After last query: 0.37 ms Query memory: 0.030 MB Memory before query: 8.232 MB Rows returned: 1

SELECT groupid 
  FROM jaf2q_jreviews_fields 
  WHERE name = 'jr_latitude'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_jreviews_fields	const	name	name	152	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.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
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
30	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
29	S2Model->query()	JROOT/components/com_jreviews/jreviews/repositories/listing_types_repository.php:53
28	ListingTypesRepositoryComponent->whereFieldExists()	JROOT/components/com_jreviews_addons/geomaps/controllers/modules/module_geomaps_controller.php:123
27	ModuleGeomapsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
26	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
25	JreviewsModuleHelper::renderModule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php:42
21	include JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:53
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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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.18 ms After last query: 0.03 ms Query memory: 0.033 MB Memory before query: 8.249 MB Rows returned: 6

SELECT ListingType.id,
ListingType.groupid
 
  FROM jaf2q_jreviews_criteria AS ListingType

Explain

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

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.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
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
32	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
31	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
30	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listing_types_repository.php:41
29	ListingTypesRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/repositories/listing_types_repository.php:57
28	ListingTypesRepositoryComponent->whereFieldExists()	JROOT/components/com_jreviews_addons/geomaps/controllers/modules/module_geomaps_controller.php:123
27	ModuleGeomapsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
26	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
25	JreviewsModuleHelper::renderModule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php:42
21	include JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:53
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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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: 0.04 ms Query memory: 0.036 MB Memory before query: 8.275 MB Rows returned: 9

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 IN (0,1,2,3,4,5)
 )
 
  ORDER BY CriteriaRating.ordering

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; Using filesort
1	SIMPLE	ListingType	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.CriteriaRating.listing_type_id	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.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
37	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
36	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
35	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
34	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/models/criteria_rating.php:47
33	CriteriaRatingModel->addCriteriaRatings()	JROOT/components/com_jreviews/jreviews/models/listing_type.php:125
32	ListingTypeModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
31	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
30	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listing_types_repository.php:41
29	ListingTypesRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/repositories/listing_types_repository.php:57
28	ListingTypesRepositoryComponent->whereFieldExists()	JROOT/components/com_jreviews_addons/geomaps/controllers/modules/module_geomaps_controller.php:123
27	ModuleGeomapsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
26	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
25	JreviewsModuleHelper::renderModule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php:42
21	include JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:53
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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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.06 ms Query memory: 0.032 MB Memory before query: 8.286 MB Rows returned: 2

SELECT ListingType.id,
ListingType.groupid
 
  FROM jaf2q_jreviews_criteria AS ListingType
 
  WHERE 1 = 1 
  AND ( 
   (ListingType.id IN (1,2))
 )

Explain

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

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
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
32	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
31	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
30	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
29	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listing_types_repository.php:38
28	ListingTypesRepositoryComponent->many()	JROOT/components/com_jreviews_addons/geomaps/controllers/modules/module_geomaps_controller.php:125
27	ModuleGeomapsController->index()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
26	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/includes/modules/helper.php:51
25	JreviewsModuleHelper::renderModule()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:574
22	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php:42
21	include JROOT/modules/mod_jreviews_geomaps/mod_jreviews_geomaps.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:53
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_thumbview.thtml:38
14	include JROOT/components/com_jreviews/jreviews/views/themes/default/listings/listings_thumbview.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:1158
9	CategoriesController->search()	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.18 ms After last query: 2.07 ms Query memory: 0.021 MB Memory before query: 8.306 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.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: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.18 ms After last query: 0.35 ms Query memory: 0.020 MB Memory before query: 8.321 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.21 ms After last query: 2.83 ms Query memory: 0.023 MB Memory before query: 8.515 MB Rows returned: 1

Duplicate queries: #72

SELECT * 
  FROM jaf2q_menu 
  WHERE id='101'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jaf2q_menu	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.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/modules/mod_sclogin/helper.php:306
14	modSCLoginHelper->getLoginRedirect()	JROOT/modules/mod_sclogin/mod_sclogin.php:25
13	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:625
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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.27 ms After last query: 3.31 ms Query memory: 0.059 MB Memory before query: 8.690 MB Rows returned: 33

Duplicate queries: #44

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
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	ALL	entry_published,list_published	NO INDEX KEY COULD BE USED	NULL	NULL	35	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.07 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
22	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
21	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
20	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/models/field.php:1905
19	FieldModel->getFieldNames()	JROOT/components/com_jreviews/jreviews/controllers/common_controller.php:159
18	CommonController::_discoverIDs()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:91
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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.19 ms Query memory: 0.026 MB Memory before query: 8.699 MB Rows returned: 1

Duplicate queries: #56 #60 #66

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (23)

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.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.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 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.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:161
20	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:296
19	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:140
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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.02 ms Query memory: 0.026 MB Memory before query: 8.710 MB Rows returned: 1

SELECT
                    ParentCategory.path
                
  FROM
                    jaf2q_categories AS Category
                
  LEFT JOIN
                    jaf2q_categories AS ParentCategory 
  ON ParentCategory.id = Category.parent_id
                
  WHERE
                    Category.id IN (23)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ParentCategory	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.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.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:1550
22	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:177
20	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:296
19	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:140
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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: 8.723 MB Rows returned: 1

Duplicate queries: #58

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,CONCAT(REPEAT('─', IF(Category.level>0,Category.level - 1,1)), ' ',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 = 'events' OR Category.path LIKE 'events/%'))
			
  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.01 ms
Statistics	0.05 ms
Preparing	0.01 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:267
20	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:296
19	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:140
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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.02 ms Query memory: 0.026 MB Memory before query: 8.732 MB Rows returned: 1

Duplicate queries: #53 #60 #66

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (23)

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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:161
20	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:304
19	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:140
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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: 0.02 ms Query memory: 0.026 MB Memory before query: 8.743 MB Rows returned: 1

SELECT
                    ParentCategory.path
                
  FROM
                    jaf2q_categories AS Category
                
  LEFT JOIN
                    jaf2q_categories AS ParentCategory 
  ON ParentCategory.id = Category.parent_id
                
  WHERE
                    Category.id IN (1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ParentCategory	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

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.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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:177
20	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:304
19	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:140
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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.31 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 8.756 MB Rows returned: 1

Duplicate queries: #55

SELECT
                Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,CONCAT(REPEAT('─', IF(Category.level>0,Category.level - 1,1)), ' ',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 = 'events' OR Category.path LIKE 'events/%'))
			
  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.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.01 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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:267
20	CategoryModel->getCategoryList()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:304
19	AdvancedSearchThemeComponent->categories()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:140
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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.37 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 8.768 MB Rows returned: 1

SELECT
                    Field.fieldid AS `Field.id`,
                    Field.name AS `Field.name`,
                    Field.title AS `Field.title`,
                    Field.type AS `Field.type`,
                    Field.description AS `Field.description`,
                    Field.options AS `Field.params`,
                    Field.required AS `Field.required`,
                    `
  Group`.groupid AS `
  Group.group_id`,
                    `
  Group`.title AS `
  Group.title`
                
  FROM
                    jaf2q_jreviews_fields AS Field
                
  INNER JOIN
                    jaf2q_jreviews_groups AS `
  Group` 
  ON (`
  Group`.groupid = Field.groupid 
  AND `
  Group`.groupid 
  AND `
  Group`.type = "content" )
                
  WHERE
                    Field.name IN ('category','jr_country') 
  AND Field.location = "content"
                
  ORDER BY 
  Group.ordering, Field.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Field	range	name,groupid	name	152	NULL	2	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	Group	eq_ref	PRIMARY,type	PRIMARY	4	bimdir_db.Field.groupid	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.02 ms
Optimizing	0.01 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.10 ms
Creating sort index	0.01 ms
Removing tmp table	0.03 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1749
20	FieldModel->getFieldsArrayFromNames()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:441
19	AdvancedSearchThemeComponent->fields()	JROOT/components/com_jreviews/jreviews/controllers/components/advanced_search_theme.php:181
18	AdvancedSearchThemeComponent->render()	JROOT/components/com_jreviews/jreviews/controllers/modules/module_advanced_search_controller.php:93
17	ModuleAdvancedSearchController->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_advsearch/mod_jreviews_advsearch.php:40
10	include JROOT/modules/mod_jreviews_advsearch/mod_jreviews_advsearch.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: 1.83 ms Query memory: 0.025 MB Memory before query: 8.943 MB Rows returned: 1

Duplicate queries: #53 #56 #66

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (23)

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.03 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.22 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 8.955 MB Rows returned: 1

Duplicate queries: #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 = 'events' OR Category.path LIKE 'events/%'))
			
  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.01 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.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
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.17 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 8.965 MB Rows returned: 1

Duplicate queries: #34 #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 = 23

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.03 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.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.11 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 8.975 MB Rows returned: 6

Duplicate queries: #35 #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.24 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 8.985 MB Rows returned: 1

SELECT
                jr_country AS value, count(*) AS total
            
  FROM
                jaf2q_jreviews_content AS Field
            
  LEFT JOIN
                jaf2q_content AS Listing 
  ON Listing.id = Field.contentid
            
  WHERE
                jr_country <> ""
                
  AND Listing.catid IN (23) 
                
  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-16 22:00:00" )
                
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-15 22:00:00" )
            
  GROUP BY
                jr_country
            
  ORDER BY
                jr_country

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	2	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.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.04 ms
Preparing	0.01 ms
Creating tmp table	0.01 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.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.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.23 ms After last query: 0.05 ms Query memory: 0.034 MB Memory before query: 9.011 MB Rows returned: 16

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_country'
 )
 
  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	16	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.02 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.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.13 ms After last query: 1.02 ms Query memory: 0.025 MB Memory before query: 9.092 MB Rows returned: 1

Duplicate queries: #53 #56 #60

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (23)

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.00 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.20 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 9.104 MB Rows returned: 1

Duplicate queries: #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 = 'events' OR Category.path LIKE 'events/%'))
			
  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.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
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.16 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 9.114 MB Rows returned: 1

Duplicate queries: #34 #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 = 23

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.03 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.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.11 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 9.124 MB Rows returned: 6

Duplicate queries: #35 #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.21 ms After last query: 0.01 ms Query memory: 0.025 MB Memory before query: 9.134 MB Rows returned: 1

SELECT
                jr_city AS value, count(*) AS total
            
  FROM
                jaf2q_jreviews_content AS Field
            
  LEFT JOIN
                jaf2q_content AS Listing 
  ON Listing.id = Field.contentid
            
  WHERE
                jr_city <> ""
                
  AND Listing.catid IN (23) 
                
  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-16 22:00:00" )
                
  AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2024-04-15 22:00:00" )
            
  GROUP BY
                jr_city
            
  ORDER BY
                jr_city

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	2	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.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.03 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 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.24 ms After last query: 0.05 ms Query memory: 0.035 MB Memory before query: 9.151 MB Rows returned: 40

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_city'
 )
 
  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	40	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.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End 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.14 ms After last query: 1.17 ms Query memory: 0.023 MB Memory before query: 9.202 MB Rows returned: 1

Duplicate queries: #51

SELECT * 
  FROM jaf2q_menu 
  WHERE id='101'

Explain

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

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.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/modules/mod_sclogin/helper.php:306
14	modSCLoginHelper->getLoginRedirect()	JROOT/modules/mod_sclogin/mod_sclogin.php:25
13	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:625
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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: 4.22 ms Query memory: 0.022 MB Memory before query: 9.202 MB Rows returned: 0

SELECT *
 
  FROM jaf2q_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.bimlar.com/events/tag/city/worcestershire'
 
  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.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.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.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: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.22 ms After last query: 18.84 ms Query memory: 0.027 MB Memory before query: 9.792 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.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.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: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.]

57 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT                     path                 
  FROM                     jaf2q_categories

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

3 × 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`

3 × SELECT id 
  FROM jaf2q_jreviews_categories

```
2 × SELECT * 
  FROM jaf2q_menu
```

2 × SELECT `manifest_cache` 
  FROM `jaf2q_extensions`

2 × 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'

2 × SELECT                 Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid AS listing_type_id,CONCAT(REPEAT('─', IF(Category.level>0,Category.level - 1,1)), ' ',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'

2 × SELECT                     ParentCategory.path                 
  FROM                     jaf2q_categories AS Category                 
  LEFT JOIN                     jaf2q_categories AS ParentCategory 
  ON ParentCategory.id = Category.parent_id

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

2 × 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

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

1 × SELECT                 id             
  FROM                 jaf2q_jreviews_categories

1 × SELECT                     fieldid,                     type,                     metatitle,                     options,                     metakey,                     metadesc                 
  FROM                     jaf2q_jreviews_fields

1 × SELECT                             FieldOption.optionid,                             FieldOption.text,                             FieldOption.description,                             FieldOption.control_field,                             FieldOption.control_value,                             Field.fieldid AS control_fieldid                         
  FROM                             jaf2q_jreviews_fieldoptions AS FieldOption                         
  LEFT JOIN                             jaf2q_jreviews_fields AS Field 
  ON FieldOption.control_field = Field.name

1 × SELECT ListingType.id AS `ListingType.listing_type_id`, ListingType.title AS `ListingType.title`, ListingType.groupid AS `ListingType.group_id`, ListingType.state AS `ListingType.state`, ListingType.search AS `ListingType.search`, ListingType.config AS `ListingType.config`  
  FROM jaf2q_jreviews_criteria AS ListingType 
  INNER JOIN jaf2q_jreviews_categories AS JreviewCategory 
  ON ListingType.id = JreviewCategory.criteriaid 
  AND JreviewCategory.`option` = 'com_content'

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                 jr_city AS value, count(*) AS total             
  FROM                 jaf2q_jreviews_content AS Field             
  LEFT JOIN                 jaf2q_content AS Listing 
  ON Listing.id = Field.contentid

1 × SELECT groupid 
  FROM jaf2q_jreviews_fields

1 × SELECT ListingType.id, ListingType.groupid  
  FROM jaf2q_jreviews_criteria AS ListingTyp

1 × SELECT ListingType.id, ListingType.groupid  
  FROM jaf2q_jreviews_criteria AS ListingType

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

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 *  
  FROM jaf2q_jmap_metainfo

1 × SELECT                     Field.fieldid AS `Field.id`,                     Field.name AS `Field.name`,                     Field.title AS `Field.title`,                     Field.type AS `Field.type`,                     Field.description AS `Field.description`,                     Field.options AS `Field.params`,                     Field.required AS `Field.required`,                     `
  Group`.groupid AS `
  Group.group_id`,                     `
  Group`.title AS `
  Group.title`                 
  FROM                     jaf2q_jreviews_fields AS Field                 
  INNER JOIN                     jaf2q_jreviews_groups AS `
  Group` 
  ON (`
  Group`.groupid = Field.groupid 
  AND `
  Group`.groupid 
  AND `
  Group`.type = "content" )

1 × SELECT                 jr_country 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_opengraph_action`

1 × SELECT `data` 
  FROM `jaf2q_session`

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 m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jaf2q_menu AS m 
  LEFT JOIN jaf2q_extensions AS e 
  ON m.component_id = e.extension_id

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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM jaf2q_extensions

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_languages
```

1 × SELECT `session_id` 
  FROM `jaf2q_session`

1 × SELECT * 
  FROM `jaf2q_admintools_wafblacklists`

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

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

1 × SELECT value 
  FROM jaf2q_jreviews_config

1 × SELECT name 
  FROM jaf2q_jreviews_addons

1 × SELECT                     name, type                 
  FROM                     jaf2q_jreviews_fields

1 × SELECT level, path 
  FROM jaf2q_categories

1 × SELECT                 Category.path             
  FROM                 jaf2q_categories AS Category

1 × SELECT                 Category.id AS `Category.cat_id`,                 Category.title AS `Category.title`,                 Category.path AS `Category.path`,                 IF(CategoryListingCount.listing_count > 0,CategoryListingCount.listing_count,0) AS `Category.listing_count`,                 Category.alias AS `Category.slug`,                 Category.level AS `Category.level`,                 Category.params AS `Category.params`,                 Category.parent_id AS `Category.parent_id`,                 Category.metadesc AS `Category.metadesc`,                 Category.metakey AS `Category.metakey`,                 JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,                 JreviewsCategory.tmpl AS `Category.tmpl`,                 JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,                 Directory.id AS `Directory.dir_id`,                 Directory.desc AS `Directory.title`,                 Directory.title AS `Directory.slug`             
  FROM                 jaf2q_categories AS Category              
  LEFT JOIN                  (                     SELECT                         ParentCategory.id, COUNT(Listing.id) as listing_count                     
  FROM                         jaf2q_categories AS Category,                         jaf2q_categories AS ParentCategory,                         jaf2q_content AS Listing

1 × SELECT * 
  FROM jaf2q_acymailing_confi

OTHER Tables:

1 × INSERT INTO `jaf2q_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'363976646669386a32746b6c71666b6f74633730327232343335', 1, 1713240132, 0, '', 0

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

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

BIM Events in « Worcestershire »

Countries

Cities

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

74 Queries Logged 26.57 ms

20 duplicate found!

57 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: