RRRG membership

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1737565526,
                "last": 1737565526,
                "now": 1737565526
            },
            "token": "DplGndeH9mXYdyWLwtSJWwpvKUVFea53"
        },
        "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
        },
        "application": {
            "queue": []
        },
        "gantry-4f21ee7afb0560aab13fd695c8950b03-name": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-logo-type": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-logo-custom-image": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-background": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-button-bgcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-button-textcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-button-bordercolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-body-pattern": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-header-style": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-menu-border-width": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-showcase-gradient-direction": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-showcase-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-showcase-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-showcase-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-showcase-pattern": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-feature-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-feature-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-feature-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-maintop-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-maintop-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-maintop-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-bottom-gradient-direction": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-bottom-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-bottom-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-bottom-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-bottom-pattern": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-footer-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-footer-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-footer-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-footer-pattern": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-copyright-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-copyright-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-copyright-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-copyright-pattern": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-box3-linkcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-box3-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-box3-heading": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-box3-button-bgcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-box3-button-textcolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-box3-button-bordercolor": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-title3-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-title4-text": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-socialicons-border": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-branding-logo": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-font-family": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-font-size-is": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-menu-type": null,
        "gantry-4f21ee7afb0560aab13fd695c8950b03-layout-mode": null
    }
}

Profile Information

Memory Usage

Database Queries

39 Queries Logged 46.95 ms

2 duplicate found!

2 duplicates: #13 #32

Query Time: 0.68 ms Query memory: 0.023 MB Memory before query: 1.038 MB Rows returned: 1

SELECT `data`

  FROM `rpo_session`

  WHERE `session_id` = X'6465366338646462336264343730353265663063316635373338363862616634'

Explain

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

Profile

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

Call Stack

#	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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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:386
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.58 ms After last query: 1.52 ms Query memory: 0.021 MB Memory before query: 1.131 MB Rows returned: 5

SELECT id, rules

  FROM `rpo_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
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:225
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.72 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.143 MB Rows returned: 2

SELECT b.id

  FROM rpo_usergroups AS a

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

  WHERE a.id = 11

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.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 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
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.04 ms
Reset for next command	0.03 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:318
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:225
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.79 ms After last query: 4.49 ms Query memory: 0.022 MB Memory before query: 1.603 MB Rows returned: 1

SELECT `value`

  FROM `rpo_admintools_storage`

  WHERE `key` = 'cparams'

Explain

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

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.03 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.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.06 ms
Reset for next command	0.03 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:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 1.612 MB Rows returned: 0

SELECT *

  FROM `rpo_admintools_wafexceptions`

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

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.05 ms
Reset for next command	0.02 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:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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: 6.06 ms Query memory: 0.021 MB Memory before query: 1.982 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `rpo_admintools_redirects`

  WHERE ((`dest` = 'user-profile/pluginclass/cbpaidsubscriptions.html') OR (`dest` = 'user-profile/pluginclass/cbpaidsubscriptions.html?do=accessdenied&accesstype=menus&accessvalue=2412&accessurl=') OR ('user-profile/pluginclass/cbpaidsubscriptions.html?do=accessdenied&accesstype=menus&accessvalue=2412&accessurl=' 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	rpo_admintools_redirects	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.18 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.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.05 ms
Reset for next command	0.03 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:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.92 ms After last query: 5.24 ms Query memory: 0.350 MB Memory before query: 4.337 MB Rows returned: 509

SELECT * 
  FROM rpo_hikashop_config

Explain

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

Profile

Status	Duration
Starting	0.13 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	1.38 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
12	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1432
11	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3531
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:194
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:72
8	plgSystemHikashopgeolocation->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:668
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:225
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: 5.34 ms Query memory: 0.007 MB Memory before query: 5.902 MB

UPDATE `rpo_extensions`

  SET `params` = '{\"mediaversion\":\"4c1fdc0b14de8b7127ea3676d590823e\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.15 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.13 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3689
10	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:194
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:72
8	plgSystemHikashopgeolocation->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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.41 ms Query memory: 0.021 MB Memory before query: 5.987 MB Rows returned: 0

SELECT * 
  FROM rpo_hikashop_geolocation 
  WHERE geolocation_ip ='3.147.195.28' 
  AND geolocation_type='visit' 
  ORDER BY geolocation_created DESC

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.14 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.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:219
10	plgSystemHikashopgeolocation->getZone()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:196
9	plgSystemHikashopgeolocation->process()	JROOT/plugins/system/hikashopgeolocation/hikashopgeolocation.php:72
8	plgSystemHikashopgeolocation->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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 6.77 ms Query memory: 0.028 MB Memory before query: 6.464 MB Rows returned: 1

SELECT `params`
 
  FROM `rpo_comprofiler_plugin`
 
  WHERE `id` = 1

Explain

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

Profile

Status	Duration
Starting	0.13 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.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:354
26	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
25	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
24	CB\Application\CBApplication::CB\Application\{closure}()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
22	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:78
21	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
20	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
19	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
18	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
17	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
16	CB\Legacy\LegacyFoundationFunctions->__construct()	Same as call in the line below.
15	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:645
14	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
13	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
12	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:35
11	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/components/com_comprofiler/router.php:36
10	ComprofilerRouter->loadCB()	JROOT/components/com_comprofiler/router.php:281
9	ComprofilerRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
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:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.31 ms After last query: 1.45 ms Query memory: 0.050 MB Memory before query: 6.540 MB Rows returned: 34

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `rpo_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,6)
 
  ORDER BY `ordering`

Explain

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

Profile

Status	Duration
Starting	0.16 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.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.56 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
12	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
10	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/router.php:366
9	ComprofilerRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
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:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 1.80 ms Query memory: 0.023 MB Memory before query: 6.933 MB Rows returned: 1

SELECT *
 
  FROM `rpo_cbsubs_config`
 
  WHERE `id` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:423
14	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:137
13	CBLib\Database\Table\Table->load()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidTable.php:157
12	cbpaidTable->load()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidApp.php:81
11	getcbpaidTabHandler::settingsParams()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidSubscriptionsMgr.php:217
10	cbpaidSubscriptionsMgr->checkExpireMe()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:102
9	cbpaidSysPlugin->checkExpireMe()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:177
8	plgSystemcbpaidsubsbot->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:1190
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:225
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: 5.26 ms After last query: 0.44 ms Query memory: 0.192 MB Memory before query: 6.990 MB Rows returned: 11

Duplicate queries: #32

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  LEFT JOIN `rpo_cbsubs_plans` AS b 
  ON b.`id` = a.`parent`
 
  WHERE a.published = 1
 
  GROUP BY a.id
 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` )  ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` )  ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	published_allownew_allowreg_parent_ordering	published_allownew_allowreg_parent_ordering	1	const	11	Using where; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	renownre.a.parent	1	Using where

Profile

Status	Duration
Starting	0.19 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.15 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.04 ms
Creating tmp table	0.27 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	2.81 ms
Creating sort index	0.81 ms
Removing tmp table	0.40 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.14 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
17	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
16	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:143
15	cbpaidPlansMgr->loadPublishedPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:583
14	cbpaidBot->getControllingPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:615
13	cbpaidBot->checkAccess()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:436
12	cbpaidBot->onAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1209
11	cbpaidContentOnAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:119
10	cbpaidSysPlugin::registerOnRealStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:129
9	cbpaidSysPlugin->triggerSysPlugins()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:178
8	plgSystemcbpaidsubsbot->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.96 ms Query memory: 0.028 MB Memory before query: 7.273 MB Rows returned: 12

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `rpo_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,6)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpo_comprofiler_plugin	ref	type_pub_order,idx_folder,published_ordering	type_pub_order	404	const,const	12	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
16	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:162
15	cbpaidPlansMgr->loadPublishedPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:583
14	cbpaidBot->getControllingPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:615
13	cbpaidBot->checkAccess()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:436
12	cbpaidBot->onAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1209
11	cbpaidContentOnAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:119
10	cbpaidSysPlugin::registerOnRealStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:129
9	cbpaidSysPlugin->triggerSysPlugins()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:178
8	plgSystemcbpaidsubsbot->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:1190
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:225
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.72 ms After last query: 3.95 ms Query memory: 0.029 MB Memory before query: 7.996 MB Rows returned: 15

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `rpo_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,6)
 
  AND `type` = 'user/plug_cbpaidsubscriptions/plugin'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpo_comprofiler_plugin	ALL	type_pub_order,idx_folder,published_ordering	NO INDEX KEY COULD BE USED	NULL	NULL	47	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
16	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:163
15	cbpaidPlansMgr->loadPublishedPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:583
14	cbpaidBot->getControllingPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:615
13	cbpaidBot->checkAccess()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:436
12	cbpaidBot->onAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1209
11	cbpaidContentOnAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:119
10	cbpaidSysPlugin::registerOnRealStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:129
9	cbpaidSysPlugin->triggerSysPlugins()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:178
8	plgSystemcbpaidsubsbot->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.31 ms After last query: 17.57 ms Query memory: 0.027 MB Memory before query: 9.021 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `rpo_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `rpo_users`

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.97 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
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.17 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Removing tmp table	0.32 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
14	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
12	Joomla\CMS\User\User::getTable()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:191
11	CB\Database\Table\UserTable->_reinitNonComprofileVars()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:132
10	CB\Database\Table\UserTable->__construct()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194
9	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
8	CBuser::getInstance()	JROOT/components/com_comprofiler/comprofiler.php:632
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 9.138 MB Rows returned: 1

SELECT * 
  FROM rpo_comprofiler_plugin p
 
  WHERE p.published = 1 
  AND p.element = 'cbpaidsubscriptions'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	element,idx_folder,published_ordering	element	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.17 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.04 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
10	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
9	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1714
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 11.31 ms Query memory: 0.025 MB Memory before query: 9.458 MB Rows returned: 1

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `rpo_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,6)
 
  AND `type` = 'templates'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpo_comprofiler_plugin	ref	type_pub_order,idx_folder,published_ordering	type_pub_order	404	const,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.19 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.05 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
16	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.html.php:390
15	HTML_comprofiler::_cbTemplateLoad()	JROOT/components/com_comprofiler/comprofiler.html.php:1014
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 5.50 ms Query memory: 0.033 MB Memory before query: 9.591 MB Rows returned: 17

SELECT * 
  FROM rpo_comprofiler_tabs t
 
  WHERE t.enabled = 1
 
  ORDER BY t.ordering_register, t.position, t.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	enabled_position_ordering,orderedit_enabled_pos_order,orderreg_enabled_pos_order	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1044
16	cbTabs->_getTabsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:829
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.80 ms After last query: 0.12 ms Query memory: 0.033 MB Memory before query: 9.645 MB Rows returned: 13

SELECT f.* 
  FROM rpo_comprofiler_fields f
 
  INNER JOIN rpo_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1 
  AND f.registration > 0 
  AND t.enabled = 1
 
  ORDER BY t.ordering_register, t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	tabid_pub_prof_order,registration_published_order,published_ordering	NO INDEX KEY COULD BE USED	NULL	NULL	54	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref\|filter	PRIMARY,enabled_position_ordering,orderedit_enabled_pos_order,orderreg_enabled_pos_order	PRIMARY\|enabled_position_ordering	4\|1	renownre.f.tabid	1 (81%)	Using where; Using rowid filter

Profile

Status	Duration
Starting	0.19 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.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.20 ms
Preparing	0.05 ms
Creating tmp table	0.08 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	1.29 ms
Creating sort index	0.15 ms
Removing tmp table	0.33 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1160
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
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: 4.35 ms After last query: 0.15 ms Query memory: 0.160 MB Memory before query: 9.710 MB Rows returned: 9

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  LEFT JOIN `rpo_cbsubs_plans` AS b 
  ON b.`id` = a.`parent`
 
  WHERE a.published = 1 
  AND a.allow_newsubscriptions = 1 
  AND a.allow_registration = 1 
  AND a.allow_frontend = 1
 
  GROUP BY a.id
 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` )  ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` )  ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	published_allownew_allowreg_parent_ordering,fe_published_allownew_allowreg_parent_order,allownew_published_upgrade_fe_parent_order	fe_published_allownew_allowreg_parent_order	4	const,const,const,const	9	Using where; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	renownre.a.parent	1	Using where

Profile

Status	Duration
Starting	0.21 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.15 ms
Optimizing	0.08 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.23 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	2.32 ms
Creating sort index	0.55 ms
Removing tmp table	0.28 ms
Creating sort index	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
25	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
24	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
23	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:143
22	cbpaidPlansMgr->loadPublishedPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:415
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
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.75 ms After last query: 0.33 ms Query memory: 0.086 MB Memory before query: 9.810 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  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

Profile

Status	Duration
Starting	0.12 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.08 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.83 ms After last query: 3.18 ms Query memory: 0.071 MB Memory before query: 9.862 MB Rows returned: 0

SELECT m.*
 
  FROM `rpo_cbsubs_promotions` AS m
 
  WHERE m.`published` = 1
 
  ORDER BY m.`priority`, m.`ordering`

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.12 ms
checking permissions	0.01 ms
Opening tables	0.97 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.18 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.07 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
36	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
35	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:522
34	CBLib\Database\Table\Table->loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidTable.php:219
33	cbpaidTable->loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidTable.php:397
32	cbpaidTable->loadThisMatchingList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php:238
31	cbpaidpromotionTotalizertype::getInstances()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php:918
30	cbpaidpromotionTotalizertype::getPromotionsApplicableForPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubspromotion/cbsubs.promotion.php:2104
29	getcbsubspromotionTab->onCPayAfterDisplayProductPeriodPrice()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
28	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
27	cbPluginHandler->trigger()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/misc/cbpaidItem.php:180
26	cbpaidItem->displayPeriodPrice()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/product/cbpaidProduct.php:1014
25	cbpaidProduct->substitutionStrings()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/product/cbpaidProduct.php:1037
24	cbpaidProduct->getPersonalized()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1069
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
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.82 ms Query memory: 0.086 MB Memory before query: 9.919 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 2

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 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.12 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 1.96 ms Query memory: 0.086 MB Memory before query: 9.960 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 1

Explain

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

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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.61 ms Query memory: 0.086 MB Memory before query: 10.001 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 10

Explain

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

Profile

Status	Duration
Starting	0.07 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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.59 ms Query memory: 0.086 MB Memory before query: 10.043 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 11

Explain

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

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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.59 ms Query memory: 0.086 MB Memory before query: 10.084 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 3

Explain

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

Profile

Status	Duration
Starting	0.07 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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.59 ms Query memory: 0.086 MB Memory before query: 10.126 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 4

Explain

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

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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.59 ms Query memory: 0.086 MB Memory before query: 10.167 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 5

Explain

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

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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.57 ms Query memory: 0.086 MB Memory before query: 10.208 MB Rows returned: 1

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  WHERE a.`id` = 6

Explain

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

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.01 ms
init	0.05 ms
Optimizing	0.02 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.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
26	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:70
25	cbpaidInstanciator->getObject()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:56
24	cbpaidPlansMgr->loadPlan()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:1067
23	cbpaidControllerUI->_checkPlansForUpgrade()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:916
22	cbpaidControllerUI->_planGetAndCheckReqParamArray()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:426
21	cbpaidControllerUI->getAndCheckChosenRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:498
20	getcbpaidsubscriptionsTab->_getRegistrationChoosenPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:1118
19	getcbpaidsubscriptionsTab->onAfterFieldsFetch()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
18	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
17	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1207
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:835
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.67 ms After last query: 2.83 ms Query memory: 0.195 MB Memory before query: 10.541 MB Rows returned: 11

Duplicate queries: #13

SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a
 
  LEFT JOIN `rpo_cbsubs_plans` AS b 
  ON b.`id` = a.`parent`
 
  WHERE a.published = 1
 
  GROUP BY a.id
 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` )  ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` )  ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	published_allownew_allowreg_parent_ordering	published_allownew_allowreg_parent_ordering	1	const	11	Using where; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	renownre.a.parent	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
22	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/models/table/cbpaidInstanciator.php:92
21	cbpaidInstanciator->_loadTrueObjects()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/libraries/cbpaidPlansMgr.php:143
20	cbpaidPlansMgr->loadPublishedPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerUI.php:34
19	cbpaidControllerUI->getShowRegistrationPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.php:458
18	getcbpaidsubscriptionsTab->getDisplayRegistration()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
17	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
16	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:861
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 12.95 ms Query memory: 0.038 MB Memory before query: 10.996 MB Rows returned: 16

SELECT * 
  FROM rpo_comprofiler_tabs t
 
  WHERE t.enabled=1
 
  AND t.viewaccesslevel IN (1,6)
 
  ORDER BY t.position, t.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	enabled_position_ordering,orderedit_enabled_pos_order,orderreg_enabled_pos_order	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where; Using filesort

Profile

Status	Duration
Starting	0.14 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.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:403
27	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:455
26	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:429
25	CBfldProtectbysub->_getTab()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:397
24	CBfldProtectbysub->_checkIfFieldTabAllowed()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:261
23	CBfldProtectbysub->_authField()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:346
22	CBfldProtectbysub->onBeforegetFieldRow()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
21	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1292
20	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1071
19	cbPluginHandler->callField()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1579
18	cbTabs->_getSingleFieldContent()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1494
17	cbTabs->_getFieldsContents()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1256
16	cbTabs->_getEditTabContents()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:881
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.41 ms After last query: 6.92 ms Query memory: 0.035 MB Memory before query: 11.085 MB Rows returned: 47

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

  FROM `rpo_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_cbjuice2','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_foxcontact','com_gantry','com_hikaserial','com_hikashop','com_installer','com_jce','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsmediagallery','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpo_assets	range	idx_asset_name	idx_asset_name	202	NULL	48	Using index condition

Profile

Status	Duration
Starting	0.20 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.07 ms
Optimizing	0.02 ms
Statistics	0.18 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.59 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
31	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
30	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
29	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
28	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
27	Joomla\CMS\User\User->authorise()	JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:310
26	CBLib\Cms\Joomla\Joomla3\CmsUser->isAuthorizedToPerformActionOnAsset()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:214
25	CBLib\Entity\User\User->isAuthorizedToPerformActionOnAsset()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:275
24	CBLib\Entity\User\User->isSuperAdmin()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:231
23	CBLib\Entity\User\User->canViewAccessLevel()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308
22	CBLib\Entity\User\User->isGlobalModerator()	JROOT/components/com_comprofiler/plugin/libraries/CB/Plugin/AntiSpam/Field/CaptchaField.php:59
21	CB\Plugin\AntiSpam\Field\CaptchaField->getFieldRow()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
20	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1075
19	cbPluginHandler->callField()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1579
18	cbTabs->_getSingleFieldContent()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1494
17	cbTabs->_getFieldsContents()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1256
16	cbTabs->_getEditTabContents()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:881
15	cbTabs->getEditTabs()	JROOT/components/com_comprofiler/comprofiler.html.php:1067
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.58 ms After last query: 8.46 ms Query memory: 0.026 MB Memory before query: 11.342 MB Rows returned: 0

SELECT `id`
 
  FROM `rpo_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=saveregisters%' OR `link` LIKE 'index.php?option=com_comprofiler&task=saveregisters%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,6 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpo_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	536	Using where

Profile

Status	Duration
Starting	0.24 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.05 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	1.67 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:354
22	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:214
21	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:984
20	CBframework->viewUrl()	JROOT/components/com_comprofiler/plugin/templates/default/default.php:881
19	CBRegistrationView_html_default->_renderLayout()	JROOT/libraries/CBLib/CB/Legacy/cbTemplateHandler.php:30
18	cbTemplateHandler->draw()	JROOT/libraries/CBLib/CB/Legacy/cbRegistrationView.php:96
17	cbRegistrationView->drawLayout()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
16	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1170
15	cbPluginHandler->callTemplate()	JROOT/components/com_comprofiler/comprofiler.html.php:1141
14	HTML_comprofiler::registerForm()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerOffer.php:80
13	cbpaidControllerOffer::displaySpecificPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_deniedview.php:228
12	cbpaidContentAccessDeniedView->display()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/controllers/cbpaidControllerCBComponent.php:162
11	CBplug_cbpaidsubscriptions->getCBpluginComponent()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:879
10	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1611
9	cbTabs->_callTabPlugin()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1725
8	cbTabs->tabClassPluginTabs()	JROOT/components/com_comprofiler/comprofiler.php:732
7	tabClass()	JROOT/components/com_comprofiler/comprofiler.php:284
6	require_once JROOT/components/com_comprofiler/comprofiler.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:225
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.95 ms After last query: 18.92 ms Query memory: 0.025 MB Memory before query: 12.632 MB Rows returned: 0

SELECT ts.template

  FROM rpo_template_styles AS ts

  INNER JOIN rpo_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 716 
  AND m.template_style_id != 0

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.25 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/cloudbase3/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/cloudbase3/index.php:80
7	require JROOT/templates/cloudbase3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.03 ms Query memory: 0.025 MB Memory before query: 12.640 MB Rows returned: 1

SELECT template

  FROM rpo_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpo_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/cloudbase3/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/cloudbase3/index.php:80
7	require JROOT/templates/cloudbase3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.22 ms After last query: 17.40 ms Query memory: 0.026 MB Memory before query: 16.128 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `rpo_template_styles`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `rpo_template_styles`

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.90 ms
After opening tables	0.01 ms
System lock	0.02 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
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.14 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.32 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 16.149 MB Rows returned: 1

SELECT *

  FROM rpo_template_styles

  WHERE `id` = '120'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.]

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a

4 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `rpo_comprofiler_plugin`

3 × SELECT a.* 
  FROM `rpo_cbsubs_plans` AS a  
  LEFT JOIN `rpo_cbsubs_plans` AS b 
  ON b.`id` = a.`parent`

2 × SELECT * 
  FROM rpo_comprofiler_tabs t

1 × SELECT * 
  FROM rpo_comprofiler_plugin p

1 × SELECT template 
  FROM rpo_template_styles

1 × SELECT ts.template 
  FROM rpo_template_styles AS ts 
  INNER JOIN rpo_menu AS m 
  ON ts.id=m.template_style_id

```
1 × SELECT `id`  
  FROM `rpo_menu`
```

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

1 × SELECT m.*  
  FROM `rpo_cbsubs_promotions` AS m

1 × SELECT f.* 
  FROM rpo_comprofiler_fields f  
  INNER JOIN rpo_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

1 × SELECT `data` 
  FROM `rpo_session`

1 × SELECT id, rules 
  FROM `rpo_viewlevels

1 × SELECT *  
  FROM `rpo_cbsubs_config`

1 × SELECT `params`  
  FROM `rpo_comprofiler_plugin`

1 × SELECT * 
  FROM rpo_hikashop_geolocation

1 × SELECT * 
  FROM rpo_hikashop_confi

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

1 × SELECT * 
  FROM `rpo_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `rpo_admintools_storage`

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

1 × SELECT * 
  FROM rpo_template_styles

OTHER Tables:

1 × UPDATE `rpo_extensions` 
  SET `params` = '{\"mediaversion\":\"4c1fdc0b14de8b7127ea3676d590823e\"}'

1 × SHOW FULL COLUMNS 
  FROM `rpo_users

1 × SHOW FULL COLUMNS 
  FROM `rpo_template_styles

Message

Join us!

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

39 Queries Logged 46.95 ms

2 duplicate found!

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: