Navisworks tutorial: Running the clash | lynda.com - Navisworks Essential Training

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713616531,
                "last": 1713616531,
                "now": 1713616531
            },
            "client": {
                "forwarded": "18.223.111.48"
            },
            "token": "DJ0SQX7yk2geQ368jmDJLN6WsaJTDLt7"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__findCount": {
        "PaidOrder": {
            "1e1c3ffed3cafc212cb3a8213d0133b2": "0",
            "f571e4f26bd26286bd65795dd8ce8719": "0"
        }
    },
    "__jreviews": {
        "MediaView393": true
    }
}

Profile Information

Time

Memory

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

Time: 31.17 ms / 34.25 ms Memory: 2.570 MB / 3.31 MB Application: afterInitialise

Time: 1.74 ms / 35.99 ms Memory: 0.175 MB / 3.49 MB Application: Before Access::preloadComponents (all components)

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

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

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

Time: 1.07 ms / 37.55 ms Memory: 0.087 MB / 3.64 MB Application: afterRoute

Time: 0.15 ms / 37.71 ms Memory: 0.021 MB / 3.66 MB Application: beforeRenderComponent com_jreviews

Time: 28.11 ms / 65.81 ms Memory: 4.046 MB / 7.71 MB Application: afterRenderComponent com_jreviews

Time: 0.74 ms / 66.55 ms Memory: 0.021 MB / 7.73 MB Application: Before Access::getAssetRules (id:1 name:root.1)

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

Time: 1.12 ms / 67.69 ms Memory: 0.040 MB / 7.77 MB Application: afterDispatch

Time: 4.83 ms / 72.52 ms Memory: 0.511 MB / 8.28 MB Application: Before Access::getAssetRules (id:218 name:com_jfbconnect)

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

Time: 0.35 ms / 72.88 ms Memory: 0.019 MB / 8.31 MB Application: beforeRenderModule mod_jreviews_advsearch (Search jreviews all)

Time: 2.06 ms / 74.94 ms Memory: 0.139 MB / 8.44 MB Application: afterRenderModule mod_jreviews_advsearch (Search jreviews all)

Time: 0.02 ms / 74.96 ms Memory: 0.001 MB / 8.44 MB Application: beforeRenderModule mod_jreviews_fields (Skills)

Time: 4.99 ms / 79.95 ms Memory: 0.382 MB / 8.83 MB Application: afterRenderModule mod_jreviews_fields (Skills)

Time: 0.02 ms / 79.97 ms Memory: 0.001 MB / 8.83 MB Application: beforeRenderModule mod_jreviews_fields (Related solutions)

Time: 3.52 ms / 83.49 ms Memory: 0.254 MB / 9.08 MB Application: afterRenderModule mod_jreviews_fields (Related solutions)

Time: 0.02 ms / 83.51 ms Memory: 0.002 MB / 9.08 MB Application: beforeRenderModule mod_jreviews_fields (Instructors)

Time: 3.16 ms / 86.67 ms Memory: 0.290 MB / 9.37 MB Application: afterRenderModule mod_jreviews_fields (Instructors)

Time: 5.70 ms / 92.37 ms Memory: 0.758 MB / 10.13 MB Application: afterRender

Database queries total: 17.58 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'63387639636f386a716b336969387037613536306f646b716b31', 1, 1713616531, 0, '', 0)

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 for update	0.02 ms
Update	0.07 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.06 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
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

SELECT id, rules

  FROM `jaf2q_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.20 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.id

  FROM jaf2q_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #7

SELECT `manifest_cache`

  FROM `jaf2q_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:778
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php: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.53 ms After last query: 1.79 ms Query memory: 0.022 MB Memory before query: 1.609 MB Rows returned: 0

Duplicate queries: #6

SELECT `manifest_cache`

  FROM `jaf2q_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 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.01 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.35 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 1.614 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
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.33 ms After last query: 0.40 ms Query memory: 0.021 MB Memory before query: 1.635 MB Rows returned: 0

SELECT *

  FROM `jaf2q_admintools_wafexceptions`

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

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:554
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:465
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:848
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE `jaf2q_extensions`

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

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

Explain

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

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 for update	0.08 ms
Updating	0.10 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

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

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

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

SELECT setting,value 
  FROM jaf2q_jfbconnect_config

Explain

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

Profile

Status	Duration
Starting	0.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.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:305
14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:337
13	JFBConnectModelConfig->get()	JROOT/administrator/components/com_jfbconnect/models/config.php:384
12	JFBConnectModelConfig->getSetting()	JROOT/components/com_jfbconnect/libraries/provider.php:32
11	JFBConnectProvider->__construct()	JROOT/components/com_jfbconnect/libraries/provider/vk.php:20
10	JFBConnectProviderVk->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:55
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 1.27 ms Query memory: 0.024 MB Memory before query: 2.377 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.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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.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
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.40 ms After last query: 3.54 ms Query memory: 0.022 MB Memory before query: 2.975 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.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.19 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
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.08 ms After last query: 0.01 ms Query memory: 0.005 MB Memory before query: 2.981 MB


  SET NAMES utf8mb4 COLLATE utf8mb4_general_ci

Explain

EXPLAIN not possible on query: SET NAMES utf8mb4 COLLATE utf8mb4_general_ci

Profile

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

Call Stack

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

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

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

SELECT *

  FROM `jaf2q_admintools_ipautoban`

  WHERE `ip` = '18.223.111.48'

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.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
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

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

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

Query Time: 0.19 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 3.008 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `jaf2q_admintools_redirects`

  WHERE ((`dest` = 'training/videos') OR (`dest` = 'training/videos?m=QT77S') OR ('training/videos?m=QT77S' 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.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.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.18 ms After last query: 2.56 ms Query memory: 0.022 MB Memory before query: 3.397 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2603
12	JReviewsRouter->isJReviewsCategory()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1342
11	JReviewsRouter->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 3.416 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

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

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

Query Time: 0.34 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 3.489 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.11 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

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

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

Query Time: 0.10 ms After last query: 2.67 ms Query memory: 0.006 MB Memory before query: 4.272 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.27 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 4.278 MB Rows returned: 1

SHOW TABLES LIKE '%_jreviews_config'

Explain

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

Profile

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

Call Stack

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

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

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

SELECT value 
  FROM jaf2q_jreviews_config 
  WHERE id = 'cms_secret'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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: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.20 ms After last query: 0.95 ms Query memory: 0.022 MB Memory before query: 4.727 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.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
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.21 ms After last query: 7.92 ms Query memory: 0.009 MB Memory before query: 7.090 MB

INSERT INTO jaf2q_jreviews_config ( id, value ) 
  VALUES ('paid_last_notifications','1713616531') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value)

Explain

EXPLAIN not possible on query: INSERT INTO jaf2q_jreviews_config ( id, value ) VALUES ('paid_last_notifications','1713616531') ON DUPLICATE KEY UPDATE value = VALUES(value)

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 for update	0.01 ms
Update	0.05 ms
Waiting for query cache lock	0.00 ms
Update	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.02 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/database.php:33
18	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:82
16	JReviews\Models\ConfigurationModel->store()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:763
15	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:55
14	PaidlistingsCronFunctionsComponent->run()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:122
13	PaidlistingsCronFunctionsComponent->processNotifications()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:46
12	PaidlistingsCronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.40 ms After last query: 0.49 ms Query memory: 0.073 MB Memory before query: 7.099 MB Rows returned: 581

Duplicate queries: #29

SELECT
                    *
                
  FROM
                    jaf2q_jreviews_config AS `Config`

Explain

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

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
Sending data	0.25 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:64
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:54
19	JReviews\Models\ConfigurationModel->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:687
18	JReviews\Services\Configuration->getSettings()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:559
17	JReviews\Services\Configuration->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:803
16	JReviews\Services\Configuration->clearCacheConfig()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:765
15	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:55
14	PaidlistingsCronFunctionsComponent->run()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:122
13	PaidlistingsCronFunctionsComponent->processNotifications()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:46
12	PaidlistingsCronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.32 ms After last query: 6.72 ms Query memory: 0.025 MB Memory before query: 7.139 MB Rows returned: 1

SELECT COUNT(*)
 
  FROM jaf2q_jreviews_paid_orders AS `PaidOrder`
 
  WHERE 1 = 1 
  AND ( 
   DATEDIFF(DATE(PaidOrder.order_expires),CURDATE()) BETWEEN 5 
  AND 10
   
  AND PaidOrder.order_active = 1
   
  AND PaidOrder.order_notify1 = 0
   
  AND (PaidOrder.payment_type = 0 OR PaidOrder.payment_type = 2)
   
  AND PaidOrder.order_never_expires = 0
   
  AND PaidOrder.order_id_renewal = 0
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	PaidOrder	ref	order_id_renewal,payment_type,order_active,order_notify1,order_never_expires	order_never_expires	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
16	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:286
15	S2ModelCore->findCount()	JROOT/components/com_jreviews_addons/paidlistings/controllers/components/paidlistings_notifications.php:144
14	PaidlistingsNotificationsComponent->checkExpiringOrders()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:135
13	PaidlistingsCronFunctionsComponent->processNotifications()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:46
12	PaidlistingsCronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT COUNT(*)
 
  FROM jaf2q_jreviews_paid_orders AS `PaidOrder`
 
  WHERE 1 = 1 
  AND ( 
   DATEDIFF(DATE(PaidOrder.order_expires),CURDATE()) <= 5
   
  AND PaidOrder.order_active = 1
   
  AND PaidOrder.order_notify2 = 0
   
  AND (PaidOrder.payment_type = 0 OR PaidOrder.payment_type = 2)
   
  AND PaidOrder.order_never_expires = 0
   
  AND PaidOrder.order_id_renewal = 0
 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	PaidOrder	ref	order_id_renewal,payment_type,order_active,order_notify2,order_never_expires	order_never_expires	1	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.03 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.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
16	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:286
15	S2ModelCore->findCount()	JROOT/components/com_jreviews_addons/paidlistings/controllers/components/paidlistings_notifications.php:184
14	PaidlistingsNotificationsComponent->checkExpiringOrders()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:135
13	PaidlistingsCronFunctionsComponent->processNotifications()	JROOT/components/com_jreviews_addons/paidlistings/plugins/paidlistings_cron_functions.php:46
12	PaidlistingsCronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.06 ms Query memory: 0.009 MB Memory before query: 7.156 MB

INSERT INTO jaf2q_jreviews_config ( id, value ) 
  VALUES ('media_likes_rebuild_last','1713616531') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value)

Explain

EXPLAIN not possible on query: INSERT INTO jaf2q_jreviews_config ( id, value ) VALUES ('media_likes_rebuild_last','1713616531') ON DUPLICATE KEY UPDATE value = VALUES(value)

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 for update	0.01 ms
Update	0.02 ms
Waiting for query cache lock	0.00 ms
Update	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
18	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:82
16	JReviews\Models\ConfigurationModel->store()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:763
15	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:58
14	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:119
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.34 ms After last query: 0.40 ms Query memory: 0.073 MB Memory before query: 7.165 MB Rows returned: 581

Duplicate queries: #25

SELECT
                    *
                
  FROM
                    jaf2q_jreviews_config AS `Config`

Explain

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

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.21 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.00 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:64
20	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:54
19	JReviews\Models\ConfigurationModel->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:687
18	JReviews\Services\Configuration->getSettings()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:559
17	JReviews\Services\Configuration->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:803
16	JReviews\Services\Configuration->clearCacheConfig()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:765
15	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:58
14	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:119
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.28 ms After last query: 0.35 ms Query memory: 0.008 MB Memory before query: 7.179 MB

INSERT INTO
				jaf2q_jreviews_media (media_id, likes_up, likes_total)
				(SELECT
					media_id AS media_id,
					SUM(IF(vote = 1, 1, 0)) AS likes_up,
					COUNT(*) AS likes_total
				
  FROM jaf2q_jreviews_media_likes
				
				
  GROUP BY media_id
				
  ORDER BY NULL
				)
			
  ON DUPLICATE KEY UPDATE
				likes_up = 
  VALUES(likes_up),
				likes_total = 
  VALUES(likes_total);

Explain

EXPLAIN not possible on query: INSERT INTO jaf2q_jreviews_media (media_id, likes_up, likes_total) (SELECT media_id AS media_id, SUM(IF(vote = 1, 1, 0)) AS likes_up, COUNT(*) AS likes_total FROM jaf2q_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_up = VALUES(likes_up), likes_total = VALUES(likes_total);

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.01 ms
Preparing	0.00 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:177
14	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:125
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.34 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 7.187 MB Rows returned: 1

SELECT @max_likes := MAX(likes_total) 
  FROM jaf2q_jreviews_media;

Explain

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

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
Sending data	0.19 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:181
14	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:125
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.01 ms Query memory: 0.008 MB Memory before query: 7.196 MB

INSERT INTO
					jaf2q_jreviews_media (media_id, likes_rank)
					(SELECT
						media_id AS media_id,
						(SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank
					
  FROM
						jaf2q_jreviews_media_likes
					
  GROUP BY
						media_id
					
  ORDER BY
						NULL
					)
				
  ON DUPLICATE KEY UPDATE
						likes_rank = 
  VALUES(likes_rank);

Explain

EXPLAIN not possible on query: INSERT INTO jaf2q_jreviews_media (media_id, likes_rank) (SELECT media_id AS media_id, (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank FROM jaf2q_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_rank = VALUES(likes_rank);

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.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
15	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:183
14	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:125
13	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
12	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
11	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
10	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
9	MyController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
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.20 ms Query memory: 0.023 MB Memory before query: 7.346 MB Rows returned: 1

SELECT
				listing_id, review_id, extension, Listing.created_by AS owner_id
			
  FROM
				jaf2q_jreviews_media AS Media
			
  LEFT JOIN
				jaf2q_content AS Listing 
  ON Listing.id = Media.listing_id
			
  WHERE
				media_id = 393

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Media	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	Listing	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.05 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
11	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media.php:1148
10	MediaModel->getListingInfo()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:752
9	MediaController->videoGallery()	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.21 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 7.356 MB

UPDATE
                    jaf2q_jreviews_media AS Media
                
  SET
                    views = views + 1
                
  WHERE
                    media_id = 393

Explain

EXPLAIN not possible on query: UPDATE jaf2q_jreviews_media AS Media SET views = views + 1 WHERE media_id = 393

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 for update	0.02 ms
Updating	0.02 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
11	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:508
10	S2ModelCore->views()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:773
9	MediaController->videoGallery()	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.32 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 7.369 MB Rows returned: 3

SELECT Media.media_id AS `Media.media_id`,
Media.media_type AS `Media.media_type`,
IF ( Media.media_type = "video" 
  AND Media.embed != "",Media.embed,Media.media_type) AS `Media.drive`,
Media.media_function AS `Media.media_function`,
Media.listing_id AS `Media.listing_id`,
Media.extension AS `Media.extension`,
Media.review_id AS `Media.review_id`,
Media.name AS `Media.name`,
Media.filename AS `Media.filename`,
Media.file_extension AS `Media.file_extension`,
Media.rel_path AS `Media.rel_path`,
Media.media_info AS `Media.media_info`,
Media.metadata AS `Media.metadata`,
Media.embed AS `Media.embed`,
Media.title AS `Media.title`,
Media.description AS `Media.description`,
Media.duration AS `Media.duration`,
Media.filesize AS `Media.filesize`,
Media.created AS `Media.created`,
Media.modified AS `Media.modified`,
Media.approved AS `Media.approved`,
Media.published AS `Media.published`,
Media.access AS `Media.access`,
INET_NTOA(Media.ipaddress) AS `Media.ipaddress`,
Media.views AS `Media.views`,
Media.main_media AS `Media.main_media`,
Media.likes_up AS `Media.likes_up`,
Media.likes_total AS `Media.likes_total`,
Media.likes_rank AS `Media.likes_rank`,
Media.ordering AS `Media.ordering`,
Media.user_id AS `Media.user_id`,
Media.user_id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.block AS `User.block`,
IF(User.email <> "", User.email, Media.email) AS `User.email`
 
  FROM jaf2q_jreviews_media AS Media

  LEFT JOIN jaf2q_users AS User 
  ON Media.user_id = User.id
 
  WHERE 1 = 1 
  AND ( 
   Media.listing_id = 253
   
  AND Media.media_type = "video"
   
  AND Media.extension = 'com_content'
   
  AND Media.published = 1
   
  AND Media.approved = 1
 )
 
  ORDER BY `Media.media_type`, `Media.ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Media	ref	count,listing	listing	306	const,const	5	Using index condition; Using where; Using filesort
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Media.user_id	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	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.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
12	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:824
9	MediaController->videoGallery()	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.36 ms After last query: 0.13 ms Query memory: 0.043 MB Memory before query: 7.410 MB Rows returned: 1

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

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

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

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

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

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

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Listing	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	Totals	const	PRIMARY	PRIMARY	156	const,const	1
1	SIMPLE	Field	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	JreviewsCategory	const	PRIMARY,option	PRIMARY	156	const,const	1
1	SIMPLE	Category	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	Directory	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	User	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	Claim	ref	listing_id,user_id,approved	listing_id	4	const	1	Using where

Profile

Status	Duration
Starting	0.07 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.03 ms
Optimizing	0.02 ms
Statistics	0.09 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.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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
18	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:423
17	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
16	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:187
15	EverywhereComponent->runEverywhereModels()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:220
14	EverywhereComponent->plgAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
13	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:106
12	MyModel->plgAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:443
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:824
9	MediaController->videoGallery()	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.15 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 7.448 MB Rows returned: 1

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

						listing_id IN (253)

						
  AND published = 1 
  AND approved = 1

						
  AND access IN (1,5)

						
  AND main_media = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
22	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
21	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media.php:1536
20	MediaModel->addMediaDetail()	JROOT/components/com_jreviews/jreviews/models/media.php:1155
19	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:818
18	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:447
17	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
16	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:187
15	EverywhereComponent->runEverywhereModels()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:220
14	EverywhereComponent->plgAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
13	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:106
12	MyModel->plgAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:443
11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:824
9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.15 ms Query memory: 0.031 MB Memory before query: 7.563 MB Rows returned: 2

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

  FROM `jaf2q_categories` AS `s`

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

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

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
27	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
26	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
25	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2513
24	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1036
23	JReviewsRouter->buildRule()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
21	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1164
15	cmsFramework::route()	JROOT/components/com_s2framework/s2framework/libs/view/helpers/html.php:151
14	HtmlHelper->sefLink()	JROOT/components/com_jreviews/jreviews/views/themes/default/media/video_gallery.thtml:106
13	include JROOT/components/com_jreviews/jreviews/views/themes/default/media/video_gallery.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
12	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
11	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
10	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:881
9	MediaController->videoGallery()	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: 3.43 ms Query memory: 0.021 MB Memory before query: 7.719 MB Rows returned: 0

SELECT *

  FROM `jaf2q_opengraph_action`

  WHERE `published`='1'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.17 ms After last query: 0.39 ms Query memory: 0.020 MB Memory before query: 7.732 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.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
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.63 ms After last query: 1.50 ms Query memory: 0.117 MB Memory before query: 7.840 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.02 ms
Optimizing	0.01 ms
Statistics	0.04 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.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406
19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:377
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:645
12	T3Template->countModules()	JROOT/templates/purity_iii/tpls/blocks/header.php:62
11	include JROOT/templates/purity_iii/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:195
10	T3Template->loadBlock()	JROOT/templates/purity_iii/tpls/corporate.php:38
9	include JROOT/templates/purity_iii/tpls/corporate.php	JROOT/plugins/system/t3/includes/core/template.php:221
8	T3Template->loadLayout()	JROOT/templates/purity_iii/index.php:35
7	require JROOT/templates/purity_iii/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 5.30 ms Query memory: 0.027 MB Memory before query: 8.471 MB Rows returned: 5

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' 
			
  ORDER BY
				Category.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	Category	ALL	PRIMARY,cat_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	17	Using where; Using filesort
1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	bimdir_db.Category.id,const	1	Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 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.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.17 ms After last query: 1.25 ms Query memory: 0.025 MB Memory before query: 8.567 MB Rows returned: 1

Duplicate queries: #49 #55

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (50)

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

Duplicate queries: #50 #56

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 = 'training' OR Category.path LIKE 'training/%'))
			
  ORDER BY
				Category.lft

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.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.23 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 8.589 MB Rows returned: 1

Duplicate queries: #51 #57

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 = 50

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.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

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

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

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

Duplicate queries: #52 #58

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

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

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

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

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	32	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	bimdir_db.Listing.id	1	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 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.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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.32 ms After last query: 0.10 ms Query memory: 0.030 MB Memory before query: 8.637 MB Rows returned: 21

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_skills'
 )
 
  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	21	Using where; Using filesort

Profile

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

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

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

Duplicate queries: #43 #55

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (50)

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

Duplicate queries: #44 #56

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 = 'training' OR Category.path LIKE 'training/%'))
			
  ORDER BY
				Category.lft

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 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.15 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 8.948 MB Rows returned: 1

Duplicate queries: #45 #57

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 = 50

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

Duplicate queries: #46 #58

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.34 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 8.968 MB Rows returned: 13

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	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: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.27 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 8.990 MB Rows returned: 25

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

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.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
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.12 ms After last query: 1.98 ms Query memory: 0.025 MB Memory before query: 9.182 MB Rows returned: 1

Duplicate queries: #43 #49

SELECT
                    path
                
  FROM
                    jaf2q_categories
                
  WHERE
                    id IN (50)

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.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 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.19 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 9.194 MB Rows returned: 1

Duplicate queries: #44 #50

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 = 'training' OR Category.path LIKE 'training/%'))
			
  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.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
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.15 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 9.204 MB Rows returned: 1

Duplicate queries: #45 #51

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 = 50

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

Duplicate queries: #46 #52

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.00 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.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.25 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 9.225 MB Rows returned: 14

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

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	32	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.01 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.07 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	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
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.18 ms After last query: 0.05 ms Query memory: 0.029 MB Memory before query: 9.247 MB Rows returned: 14

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_instructor'
 )
 
  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	14	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.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
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.21 ms After last query: 3.73 ms Query memory: 0.022 MB Memory before query: 9.478 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.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.19 ms After last query: 2.25 ms Query memory: 0.027 MB Memory before query: 9.775 MB Rows returned: 84

SELECT * 
  FROM jaf2q_acymailing_config

Explain

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

Profile

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

Call Stack

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

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

49 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

3 × SELECT id 
  FROM jaf2q_jreviews_categories

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

3 × SELECT                     path                 
  FROM                     jaf2q_categories

2 × SELECT COUNT(*)  
  FROM jaf2q_jreviews_paid_orders AS `PaidOrder`

2 × SELECT `manifest_cache` 
  FROM `jaf2q_extensions`

2 × SELECT                     *                 
  FROM                     jaf2q_jreviews_config AS `Config

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 c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `jaf2q_categories` AS `s` 
  INNER JOIN `jaf2q_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT * 
  FROM `jaf2q_opengraph_action`

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

1 × SELECT `data` 
  FROM `jaf2q_session`

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

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

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

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

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

1 × SELECT *  
  FROM jaf2q_jmap_metainfo

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

1 × SELECT     listing_id, review_id, extension, Listing.created_by AS owner_id    
  FROM     jaf2q_jreviews_media AS Media    
  LEFT JOIN     jaf2q_content AS Listing 
  ON Listing.id = Media.listing_id

1 × SELECT Media.media_id AS `Media.media_id`, Media.media_type AS `Media.media_type`, IF ( Media.media_type = "video" 
  AND Media.embed != "",Media.embed,Media.media_type) AS `Media.drive`, Media.media_function AS `Media.media_function`, Media.listing_id AS `Media.listing_id`, Media.extension AS `Media.extension`, Media.review_id AS `Media.review_id`, Media.name AS `Media.name`, Media.filename AS `Media.filename`, Media.file_extension AS `Media.file_extension`, Media.rel_path AS `Media.rel_path`, Media.media_info AS `Media.media_info`, Media.metadata AS `Media.metadata`, Media.embed AS `Media.embed`, Media.title AS `Media.title`, Media.description AS `Media.description`, Media.duration AS `Media.duration`, Media.filesize AS `Media.filesize`, Media.created AS `Media.created`, Media.modified AS `Media.modified`, Media.approved AS `Media.approved`, Media.published AS `Media.published`, Media.access AS `Media.access`, INET_NTOA(Media.ipaddress) AS `Media.ipaddress`, Media.views AS `Media.views`, Media.main_media AS `Media.main_media`, Media.likes_up AS `Media.likes_up`, Media.likes_total AS `Media.likes_total`, Media.likes_rank AS `Media.likes_rank`, Media.ordering AS `Media.ordering`, Media.user_id AS `Media.user_id`, Media.user_id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.block AS `User.block`, IF(User.email <> "", User.email, Media.email) AS `User.email`  
  FROM jaf2q_jreviews_media AS Media 
  LEFT JOIN jaf2q_users AS User 
  ON Media.user_id = User.id

1 × SELECT * 
  FROM `jaf2q_admintools_ipautoban`

1 × SELECT id, rules 
  FROM `jaf2q_viewlevels

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

1 × SELECT `value` 
  FROM `jaf2q_admintools_storage`

1 × SELECT * 
  FROM `jaf2q_admintools_wafexceptions`

1 × SELECT setting,value 
  FROM jaf2q_jfbconnect_confi

1 × SELECT value 
  FROM jaf2q_jfbconnect_config

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

1 × SELECT `session_id` 
  FROM `jaf2q_session`

1 × SELECT                 count(*)             
  FROM                 jaf2q_jreviews_categories

1 × SELECT * 
  FROM `jaf2q_admintools_wafblacklists`

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

1 × SELECT value 
  FROM jaf2q_jreviews_config

1 × SELECT name 
  FROM jaf2q_jreviews_addons

1 × SELECT @max_likes := MAX(likes_total) 
  FROM jaf2q_jreviews_media

1 × SELECT * 
  FROM jaf2q_acymailing_confi

OTHER Tables:

1 × INSERT INTO `jaf2q_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'63387639636f386a716b336969387037613536306f646b716b31', 1, 1713616531, 0, '', 0

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

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

1 × INSERT INTO jaf2q_jreviews_config ( id, value ) 
  VALUES ('paid_last_notifications','1713616531') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value

1 × INSERT INTO jaf2q_jreviews_config ( id, value ) 
  VALUES ('media_likes_rebuild_last','1713616531') 
  ON DUPLICATE KEY UPDATE value = 
  VALUES(value

1 × INSERT INTO     jaf2q_jreviews_media (media_id, likes_up, likes_total)     (SELECT      media_id AS media_id,      SUM(IF(vote = 1, 1, 0)) AS likes_up,      COUNT(*) AS likes_total     
  FROM jaf2q_jreviews_media_likes          
  GROUP BY media_id

1 × INSERT INTO      jaf2q_jreviews_media (media_id, likes_rank)      (SELECT       media_id AS media_id,       (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank      
  FROM       jaf2q_jreviews_media_likes      
  GROUP BY       media_id

1 × UPDATE                     jaf2q_jreviews_media AS Media                 
  SET                     views = views + 1

Sidebar

Navisworks Essential Training: VIDEOS