Members Directory

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1539776493,
                "last": 1539776493,
                "now": 1539776493
            },
            "token": "wuufWPCnBJ8VDJSYuFdEI2ApbRlslKUZ"
        },
        "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
        },
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-name": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-topblock-background": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-topblock-overlay": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-topblock-link": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-main-body": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-main-color": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-bottomblock-background": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-bottomblock-overlay": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-bottomblock-link": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-font-family": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-font-size-is": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-menu-type": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-layout-mode": null,
        "halcyon-03bf1706e6c6e4d7212dce780568bfda-typography-style": null
    }
}

Profile Information

Time

Memory

Time: 3.33 ms / 3.33 ms Memory: 0.558 MB / 0.89 MB Application: afterLoad

Time: 1279.30 ms / 1282.63 ms Memory: 3.019 MB / 3.91 MB Application: afterInitialise

Time: 15.19 ms / 1297.82 ms Memory: 1.411 MB / 5.32 MB Application: Before Access::preloadComponents (all components)

Time: 0.39 ms / 1298.21 ms Memory: 0.083 MB / 5.40 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 1298.25 ms Memory: 0.000 MB / 5.40 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.35 ms / 1298.59 ms Memory: 0.009 MB / 5.41 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 0.27 ms / 1298.86 ms Memory: 0.000 MB / 5.41 MB Application: afterRoute

Time: 1.18 ms / 1300.04 ms Memory: 0.087 MB / 5.50 MB Application: beforeRenderComponent com_comprofiler

Time: 97.31 ms / 1397.35 ms Memory: 1.068 MB / 6.56 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.08 ms / 1397.43 ms Memory: 0.007 MB / 6.57 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 173.88 ms / 1571.31 ms Memory: 1.380 MB / 7.95 MB Application: afterRenderComponent com_comprofiler

Time: 12.52 ms / 1583.83 ms Memory: 0.473 MB / 8.42 MB Application: afterDispatch

Time: 508.03 ms / 2091.87 ms Memory: 1.291 MB / 9.72 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 7.12 ms / 2098.99 ms Memory: 0.539 MB / 10.25 MB Application: afterRenderModule mod_roknavmenu ()

Time: 0.11 ms / 2099.09 ms Memory: 0.000 MB / 10.22 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 2.78 ms / 2101.88 ms Memory: 0.374 MB / 10.60 MB Application: afterRenderModule mod_roknavmenu ()

Time: 351.13 ms / 2453.00 ms Memory: 1.681 MB / 12.28 MB Application: beforeRenderModule mod_jevents_legend (Events List)

Time: 2.81 ms / 2455.81 ms Memory: 0.171 MB / 12.45 MB Application: Before Access::getAssetRules (id:1483 name:com_jevents)

Time: 0.12 ms / 2455.93 ms Memory: 0.007 MB / 12.46 MB Application: After Access::getAssetRules (id:1483 name:com_jevents)

Time: 1.17 ms / 2457.10 ms Memory: 0.001 MB / 12.46 MB Application: afterRenderModule mod_jevents_legend (Events List)

Time: 0.07 ms / 2457.17 ms Memory: 0.003 MB / 12.46 MB Application: beforeRenderModule mod_cblogin (LogIn To Site (side))

Time: 8.11 ms / 2465.28 ms Memory: 0.413 MB / 12.88 MB Application: afterRenderModule mod_cblogin (LogIn To Site (side))

Time: 117.35 ms / 2582.63 ms Memory: 0.142 MB / 13.02 MB Application: beforeRenderModule mod_cblogin (Login-Top)

Time: 1.66 ms / 2584.29 ms Memory: 0.013 MB / 13.03 MB Application: afterRenderModule mod_cblogin (Login-Top)

Time: 21.51 ms / 2605.81 ms Memory: 0.000 MB / 11.50 MB Application: afterRender

Database queries total: 632.86 ms

Memory Usage

Database Queries

57 Queries Logged 632.86 ms

8 duplicate found!

2 duplicates: #5 #6

2 duplicates: #13 #14

2 duplicates: #23 #25

2 duplicates: #39 #45

Query Time: 186.00 ms Query memory: 0.007 MB Memory before query: 1.155 MB Rows returned: 0

SELECT `session_id`

  FROM `j25_session`

  WHERE `session_id` = 'cn18c1d1vndll85arooi7jnlt0' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	180.57 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.07 ms
updating status	0.01 ms
Waiting for query cache lock	2.02 ms
updating status	0.05 ms
Waiting for query cache lock	0.35 ms
updating status	0.00 ms
storing result in query cache	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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: 32.56 ms After last query: 0.28 ms Query memory: 0.005 MB Memory before query: 1.163 MB

INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('cn18c1d1vndll85arooi7jnlt0', 1, '1539776493', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('cn18c1d1vndll85arooi7jnlt0', 1, '1539776493', 0, '', 0)

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.02 ms
update	30.79 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	0.77 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.24 ms After last query: 2.03 ms Query memory: 0.007 MB Memory before query: 1.350 MB Rows returned: 6

SELECT id, rules

  FROM `j25_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 1.365 MB Rows returned: 2

SELECT b.id

  FROM j25_usergroups AS a

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

  WHERE a.id = 2

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
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:195
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: 51.02 ms After last query: 5.54 ms Query memory: 0.009 MB Memory before query: 1.852 MB Rows returned: 0

Duplicate queries: #6

SELECT `manifest_cache`

  FROM `j25_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	50.07 ms
init	0.11 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.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.88 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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: 44.06 ms After last query: 2.54 ms Query memory: 0.009 MB Memory before query: 1.883 MB Rows returned: 0

Duplicate queries: #5

SELECT `manifest_cache`

  FROM `j25_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	40.30 ms
init	0.01 ms
checking query cache for query	0.51 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
Waiting for query cache lock	0.03 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	2.47 ms
updating status	0.02 ms
Waiting for query cache lock	0.04 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.27 ms Query memory: 0.009 MB Memory before query: 1.891 MB Rows returned: 1

SELECT `value`

  FROM `j25_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_admintools_storage	const	PRIMARY	PRIMARY	402	const	1	100.00

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.82 ms After last query: 0.50 ms Query memory: 0.008 MB Memory before query: 1.914 MB Rows returned: 0

SELECT `query`

  FROM `j25_admintools_wafexceptions`

  WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_comprofiler') 
  AND (`view` IS NULL OR `view` = '' OR `view` = 'userslist')

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_admintools_wafexceptions	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 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
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.16 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.15 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/admintools/main.php:633
10	plgSystemAdmintools->loadWAFExceptionsByOption()	JROOT/plugins/system/admintools/admintools/main.php:471
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.82 ms Query memory: 0.008 MB Memory before query: 2.000 MB Rows returned: 20

SELECT `path`

  FROM j25_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.12 ms Query memory: 0.008 MB Memory before query: 2.010 MB Rows returned: 0

SELECT `file`

  FROM j25_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.12 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.07 ms Query memory: 0.008 MB Memory before query: 2.017 MB Rows returned: 52

SELECT *

  FROM j25_rsfirewall_configuration

Explain

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

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.82 ms After last query: 2.76 ms Query memory: 0.010 MB Memory before query: 2.178 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `j25_rsfirewall_logs`

Explain

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

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.21 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RSFirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.28 ms After last query: 5.24 ms Query memory: 0.009 MB Memory before query: 2.593 MB Rows returned: 1

Duplicate queries: #14

SELECT template

  FROM j25_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	2.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.07 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.08 ms Query memory: 0.010 MB Memory before query: 2.603 MB Rows returned: 1

Duplicate queries: #13

SELECT template

  FROM j25_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.20 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.16 ms After last query: 1.62 ms Query memory: 0.007 MB Memory before query: 2.786 MB Rows returned: 4

SELECT extension, file, type

  FROM j25_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.08 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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: 92.69 ms After last query: 2.39 ms Query memory: 0.008 MB Memory before query: 2.845 MB

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"3634906809389799d0b59a6cace4cb1a\"}'

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

Explain

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

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.02 ms
init	0.10 ms
updating	0.07 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	1.00 ms
query end	91.14 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.06 ms
updating status	0.88 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/twbootstrap/twbootstrap.php:164
7	PlgSystemTwbootstrap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.82 ms Query memory: 0.008 MB Memory before query: 2.880 MB Rows returned: 0

SELECT ts.template  
  FROM j25_menu as m  
  INNER JOIN j25_template_styles as ts 
  ON ts.id = m.template_style_id  
  WHERE m.id=502

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 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
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.12 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/twbootstrap/twbootstrap.php:653
9	PlgSystemTwbootstrap->getCurrentTplName()	JROOT/plugins/system/twbootstrap/twbootstrap.php:804
8	PlgSystemTwbootstrap->_initFolders()	JROOT/plugins/system/twbootstrap/twbootstrap.php:174
7	PlgSystemTwbootstrap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.07 ms Query memory: 0.008 MB Memory before query: 2.888 MB Rows returned: 1

SELECT template 
  FROM j25_template_styles  
  WHERE client_id=0  
  AND home = 1

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	8.85 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/twbootstrap/twbootstrap.php:686
10	PlgSystemTwbootstrap->getDefaultTplName()	JROOT/plugins/system/twbootstrap/twbootstrap.php:659
9	PlgSystemTwbootstrap->getCurrentTplName()	JROOT/plugins/system/twbootstrap/twbootstrap.php:804
8	PlgSystemTwbootstrap->_initFolders()	JROOT/plugins/system/twbootstrap/twbootstrap.php:174
7	PlgSystemTwbootstrap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.38 ms After last query: 8.72 ms Query memory: 0.008 MB Memory before query: 3.055 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

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

Profile

Status	Duration
starting	0.14 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Filling schema table	0.74 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:338
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.20 ms Query memory: 0.008 MB Memory before query: 3.067 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `j25_admintools_redirects`

  WHERE ((`dest` = 'index.php') OR (`dest` = 'index.php?option=com_comprofiler&view=userslist&listid=2&searchmode=0&Itemid=502&
  limit=50&limitstart=200') OR ('index.php?option=com_comprofiler&view=userslist&listid=2&searchmode=0&Itemid=502&
  limit=50&limitstart=200' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 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
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	5.26 ms
Waiting for query cache lock	0.02 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1763
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.85 ms After last query: 5.20 ms Query memory: 0.009 MB Memory before query: 3.186 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `j25_extensions`

Explain

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.19 ms Query memory: 0.007 MB Memory before query: 3.223 MB Rows returned: 1

SELECT `extension_id`

  FROM `j25_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.13 ms Query memory: 0.007 MB Memory before query: 3.232 MB Rows returned: 1

Duplicate queries: #25

SELECT *

  FROM j25_extensions

  WHERE `extension_id` = '10081'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.05 ms
updating status	0.05 ms
Waiting for query cache lock	0.27 ms
updating status	0.01 ms
storing result in query cache	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.68 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 3.239 MB Rows returned: 1

SELECT `extension_id`

  FROM `j25_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 3.246 MB Rows returned: 1

Duplicate queries: #23

SELECT *

  FROM j25_extensions

  WHERE `extension_id` = '10081'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.05 ms After last query: 811.81 ms Query memory: 0.011 MB Memory before query: 3.444 MB Rows returned: 1

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

  FROM j25_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_advancedmodules'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.09 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
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.37 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.53 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
15	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
14	RokSprocket_Addon_AdvancedModuleManager->__construct()	Same as call in the line below.
13	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
12	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
11	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
10	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
9	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
8	plgSystemRokSprocket->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 6.05 ms Query memory: 0.007 MB Memory before query: 4.035 MB Rows returned: 0

SELECT *

  FROM j25_rsfirewall_hashes

  WHERE (`type`='3.8.12' OR `type`='protect') 
  AND `flag`!='C'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:993
8	plgSystemRSFirewall->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 4.044 MB Rows returned: 0

SELECT *

  FROM j25_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1016
8	plgSystemRSFirewall->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.008 MB Memory before query: 4.053 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM j25_rsfirewall_lists

  WHERE (`ip`='54.224.118.247' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_rsfirewall_lists	ref	published,type,ip	type	1	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
9	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1052
8	plgSystemRSFirewall->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.08 ms Query memory: 0.008 MB Memory before query: 4.060 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM j25_rsfirewall_lists

  WHERE (`ip`='54.224.118.247' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_rsfirewall_lists	ALL	published,type,ip	NO INDEX KEY COULD BE USED	NULL	NULL	97	75.26	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
9	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1056
8	plgSystemRSFirewall->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.35 ms Query memory: 0.007 MB Memory before query: 4.072 MB Rows returned: 0

SELECT *

  FROM j25_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:661
9	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1109
8	plgSystemRSFirewall->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 3.21 ms Query memory: 0.017 MB Memory before query: 4.404 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_comprofiler_plugin	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
26	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
25	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
24	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:45
23	CB\Application\CBApplication::CB\Application\{closure}()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
21	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70
20	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605
19	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
18	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:179
17	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
16	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109
15	CB\Legacy\LegacyFoundationFunctions->__construct()	Same as call in the line below.
14	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643
13	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
12	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132
11	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33
10	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:154
9	plgSystemcbpaidsubsbot->loadCBSubs()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:170
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 1.80 ms Query memory: 0.011 MB Memory before query: 4.600 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_cbsubs_config	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.04 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:414
14	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:135
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:76
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:101
9	cbpaidSysPlugin->checkExpireMe()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:176
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.95 ms Query memory: 0.012 MB Memory before query: 4.722 MB Rows returned: 8

SELECT a.* 
  FROM `j25_cbsubs_plans` AS a
 
  LEFT JOIN `j25_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	filtered	Extra
1	SIMPLE	a	ref	published_allownew_allowreg_parent_ordering	published_allownew_allowreg_parent_ordering	1	const	8	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	ocradgor_new.a.parent	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.09 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
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:573
14	cbpaidBot->getControllingPlans()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:605
13	cbpaidBot->checkAccess()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:430
12	cbpaidBot->onAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1182
11	cbpaidContentOnAlittleMoreAfterStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:118
10	cbpaidSysPlugin::registerOnRealStart()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sysplug.php:128
9	cbpaidSysPlugin->triggerSysPlugins()	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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 3.41 ms Query memory: 0.012 MB Memory before query: 5.329 MB Rows returned: 50

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

  FROM `j25_assets`

  WHERE `name` IN ('root.1','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_allvideoshare','com_banners','com_breezingforms','com_cache','com_categories','com_cbjuice2','com_checkin','com_chronoforms','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_dropfiles','com_dtregister','com_finder','com_gantry','com_installer','com_jdbexport','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_monthlyarchive','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_redirect','com_rokgallery','com_roksprocket','com_rsfirewall','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	filtered	Extra
1	SIMPLE	j25_assets	range	idx_asset_name	idx_asset_name	202	NULL	51	100.00	Using index condition

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.12 ms After last query: 2.66 ms Query memory: 0.009 MB Memory before query: 5.602 MB Rows returned: 10

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_comprofiler_plugin	ref	type_pub_order,idx_folder	type_pub_order	304	const,const	10	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
12	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
11	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
10	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
9	cbPluginHandler->loadPluginGroup()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:276
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.71 ms After last query: 2.67 ms Query memory: 0.013 MB Memory before query: 6.475 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `j25_users`

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.18 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.04 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
15	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
13	Joomla\CMS\User\User::getTable()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:160
12	CB\Database\Table\UserTable->_reinitNonComprofileVars()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:120
11	CB\Database\Table\UserTable->__construct()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194
10	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
9	CBuser::getInstance()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:283
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 91.59 ms After last query: 0.14 ms Query memory: 0.008 MB Memory before query: 6.509 MB Rows returned: 4

SELECT *
 
  FROM `j25_comprofiler_lists`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN  (1, 2, 5) 
 
  ORDER BY `ordering`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 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
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	90.67 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.11 ms
Sending data	0.15 ms
end	0.04 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.07 ms
updating status	0.18 ms
Waiting for query cache lock	0.15 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
10	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
9	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:297
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.55 ms After last query: 0.61 ms Query memory: 0.009 MB Memory before query: 6.541 MB Rows returned: 1

Duplicate queries: #45

SELECT *
 
  FROM `j25_comprofiler_lists`
 
  WHERE `listid` = 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_comprofiler_lists	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.11 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
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:414
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:135
10	CBLib\Database\Table\Table->load()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:45
9	cbUsersList::getInstance()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:326
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.96 ms After last query: 1.04 ms Query memory: 0.009 MB Memory before query: 6.652 MB Rows returned: 5

SELECT f.* 
  FROM j25_comprofiler_fields f
 
  INNER JOIN j25_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1 
  AND f.searchable = 1 
  AND t.enabled = 1 
  AND t.viewaccesslevel IN  (1, 2, 5) 
 
  ORDER BY t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,enabled_position_ordering,orderreg_enabled_pos_order,orderedit_enabled_pos_order	NO INDEX KEY COULD BE USED	NULL	NULL	20	60.00	Using where; Using temporary; Using filesort
1	SIMPLE	f	ref	tabid_pub_prof_order	tabid_pub_prof_order	6	ocradgor_new.t.tabid,const	3	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.01 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.02 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.29 ms
Copying to tmp table	0.83 ms
Sorting result	0.06 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
12	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
11	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
10	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:953
9	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:370
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.05 ms After last query: 0.66 ms Query memory: 0.009 MB Memory before query: 6.686 MB Rows returned: 24

SELECT f.* 
  FROM j25_comprofiler_fields f
 
  INNER JOIN j25_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE ( f.published = 1 OR f.name = 'name' ) 
  AND ( f.profile > 0 OR f.name = 'username' OR f.name = 'name') 
  AND t.enabled = 1 
  AND t.viewaccesslevel IN  (1, 2, 5) 
 
  ORDER BY t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,enabled_position_ordering,orderreg_enabled_pos_order,orderedit_enabled_pos_order	NO INDEX KEY COULD BE USED	NULL	NULL	20	60.00	Using where; Using temporary; Using filesort
1	SIMPLE	f	ref	tabid_pub_prof_order	tabid_pub_prof_order	5	ocradgor_new.t.tabid	4	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.24 ms
Copying to tmp table	0.38 ms
Sorting result	0.12 ms
Sending data	0.13 ms
Waiting for query cache lock	0.31 ms
Sending data	0.16 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.08 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	2.27 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
12	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
11	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
10	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:953
9	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:376
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 29.68 ms After last query: 2.20 ms Query memory: 0.007 MB Memory before query: 6.850 MB Rows returned: 1

SELECT COUNT( DISTINCT u.id ) 
  FROM j25_users u
 JOIN j25_user_usergroup_map g 
  ON g.`user_id` = u.`id`
 JOIN j25_comprofiler ue 
  ON ue.`id` = u.`id`
 
  WHERE u.block = 0
 
  AND ue.approved = 1
 
  AND ue.confirmed = 1
 
  AND ue.banned = 0
 
  AND g.group_id IN  (2)   
  AND ( `cb_ocramember` = 'yes' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g	index	PRIMARY	PRIMARY	8	NULL	3456	75.00	Using where; Using index
1	SIMPLE	u	eq_ref	PRIMARY,gid_block	PRIMARY	4	ocradgor_new.g.user_id	1	100.00	Using where
1	SIMPLE	ue	eq_ref	PRIMARY,apprconfbanid	PRIMARY	4	ocradgor_new.u.id	1	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 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.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.61 ms
preparing	0.05 ms
executing	0.04 ms
Sending data	0.25 ms
Waiting for query cache lock	0.01 ms
Sending data	0.00 ms
storing result in query cache	28.03 ms
end	0.06 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
9	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:460
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 80.14 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 6.858 MB Rows returned: 50

SELECT DISTINCT ue.*, u.*, '' AS 'NA' 
  FROM j25_users u
 JOIN j25_user_usergroup_map g 
  ON g.`user_id` = u.`id`
 JOIN j25_comprofiler ue 
  ON ue.`id` = u.`id`
 
  WHERE u.block = 0
 
  AND ue.approved = 1
 
  AND ue.confirmed = 1
 
  AND ue.banned = 0
 
  AND g.group_id IN  (2)   
  AND ( `cb_ocramember` = 'yes' ) 
 
  ORDER BY `lastname` ASC 
  LIMIT 200, 50

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ue	ALL	PRIMARY,apprconfbanid	NO INDEX KEY COULD BE USED	NULL	NULL	3898	75.01	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,gid_block	PRIMARY	4	ocradgor_new.ue.id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	8	ocradgor_new.ue.id,const	1	100.00	Using where; Using index; Distinct

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.43 ms
Copying to tmp table	0.05 ms
Waiting for query cache lock	0.00 ms
Copying to tmp table	0.00 ms
storing result in query cache	71.83 ms
Sorting result	5.53 ms
Sending data	1.29 ms
end	0.01 ms
removing tmp table	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.08 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
10	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
9	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:471
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 3.87 ms Query memory: 0.010 MB Memory before query: 7.574 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_comprofiler_plugin	ref	type_pub_order,idx_folder	type_pub_order	304	const,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
13	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
12	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
11	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.html.php:328
10	HTML_comprofiler::_cbTemplateLoad()	JROOT/components/com_comprofiler/comprofiler.html.php:404
9	HTML_comprofiler::usersList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:513
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 8.80 ms Query memory: 0.014 MB Memory before query: 7.741 MB Rows returned: 1

Duplicate queries: #39

SELECT *
 
  FROM `j25_comprofiler_lists`
 
  WHERE `listid` = 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_comprofiler_lists	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:414
19	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:135
18	CBLib\Database\Table\Table->load()	JROOT/components/com_comprofiler/router.php:161
17	ComprofilerRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:643
11	CBframework->cbSef()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
10	CBframework->viewUrl()	JROOT/components/com_comprofiler/comprofiler.html.php:465
9	HTML_comprofiler::usersList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:513
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.69 ms Query memory: 0.015 MB Memory before query: 7.757 MB Rows returned: 10

SELECT * 
  FROM j25_comprofiler_tabs t
 
  WHERE t.enabled=1
 
  AND t.viewaccesslevel IN (1,2,5)
 
  ORDER BY t.position, t.ordering

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.03 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
21	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
20	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:428
19	CBfldProtectbysub->_getTab()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:396
18	CBfldProtectbysub->_checkIfFieldTabAllowed()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:260
17	CBfldProtectbysub->_authField()	JROOT/components/com_comprofiler/plugin/user/plug_cbsubsfieldstabsprotect/cbsubs.fieldstabsprotect.php:345
16	CBfldProtectbysub->onBeforegetFieldRow()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:885
15	cbPluginHandler->call()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1298
14	cbPluginHandler->trigger()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077
13	cbPluginHandler->callField()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1370
12	cbTabs->_getSingleFieldContent()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1285
11	cbTabs->_getFieldsContents()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1087
10	cbTabs->getSearchableContents()	JROOT/components/com_comprofiler/comprofiler.html.php:478
9	HTML_comprofiler::usersList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:513
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:746
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.74 ms After last query: 42.73 ms Query memory: 0.010 MB Memory before query: 7.959 MB Rows returned: 30

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

  FROM j25_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 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
Waiting for query cache lock	0.04 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.22 ms
Sending data	0.26 ms
Waiting for query cache lock	0.01 ms
Sending data	0.23 ms
Waiting for query cache lock	0.01 ms
Sending data	0.23 ms
Waiting for query cache lock	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406
14	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:358
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:335
9	Joomla\CMS\Helper\ModuleHelper::_load()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:257
8	cbpaidAccessModuleHelper::myLoad()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:499
7	cbpaidBot->_checkModules()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1016
6	cbpaidsubsbot_onAfterDispatch_Alt()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 3.00 ms Query memory: 0.011 MB Memory before query: 8.184 MB Rows returned: 1

SELECT a.mirror_id

  FROM j25_advancedmodules AS a

  WHERE a.moduleid = 248

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:456
15	PlgSystemAdvancedModuleHelper->getMirrorModuleIdById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:257
14	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:164
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:358
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:335
9	Joomla\CMS\Helper\ModuleHelper::_load()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:257
8	cbpaidAccessModuleHelper::myLoad()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:499
7	cbpaidBot->_checkModules()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1016
6	cbpaidsubsbot_onAfterDispatch_Alt()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.09 ms Query memory: 0.011 MB Memory before query: 8.195 MB Rows returned: 1

SELECT a.params

  FROM j25_advancedmodules AS a

  WHERE a.moduleid = 248

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:490
15	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:293
14	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:164
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:358
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:335
9	Joomla\CMS\Helper\ModuleHelper::_load()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:257
8	cbpaidAccessModuleHelper::myLoad()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:499
7	cbpaidBot->_checkModules()	JROOT/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubscontent/cbsubs.content_access.php:1016
6	cbpaidsubsbot_onAfterDispatch_Alt()	JROOT/libraries/joomla/event/dispatcher.php:165
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 517.34 ms Query memory: 0.012 MB Memory before query: 9.842 MB Rows returned: 0

SELECT ts.template

  FROM j25_template_styles AS ts

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

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

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:201
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/rt_halcyon_responsive/features/fusionmenu.php:58
10	GantryFeatureFusionMenu->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/rt_halcyon_responsive/index.php:94
7	require JROOT/templates/rt_halcyon_responsive/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.10 ms Query memory: 0.012 MB Memory before query: 9.854 MB Rows returned: 1

SELECT template

  FROM j25_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:201
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/rt_halcyon_responsive/features/fusionmenu.php:58
10	GantryFeatureFusionMenu->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/rt_halcyon_responsive/index.php:94
7	require JROOT/templates/rt_halcyon_responsive/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 363.86 ms Query memory: 0.013 MB Memory before query: 12.499 MB Rows returned: 68

SELECT f.* 
  FROM j25_comprofiler_fields f
 
  INNER JOIN j25_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1
 
  ORDER BY t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	ALL	tabid_pub_prof_order	NO INDEX KEY COULD BE USED	NULL	NULL	76	75.00	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	ocradgor_new.f.tabid	1	100.00

Profile

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.08 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:953
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
15	CBuser->getField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1075
14	CBuser->_evaluateCbFields()	Same as call in the line below.
13	preg_replace_callback()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1125
12	CBuser->_evaluateCbFields()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:640
11	CBuser->replaceUserVars()	JROOT/modules/mod_cblogin/mod_cblogin.php:134
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 4.93 ms Query memory: 0.011 MB Memory before query: 12.857 MB Rows returned: 0

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	112	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/bootstrap-horizontal.php:15
11	require JROOT/modules/mod_cblogin/tmpl/bootstrap-horizontal.php	JROOT/modules/mod_cblogin/mod_cblogin.php:219
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.43 ms Query memory: 0.011 MB Memory before query: 12.869 MB Rows returned: 0

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	112	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/bootstrap-horizontal.php:146
11	require JROOT/modules/mod_cblogin/tmpl/bootstrap-horizontal.php	JROOT/modules/mod_cblogin/mod_cblogin.php:219
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.31 ms Query memory: 0.011 MB Memory before query: 12.880 MB Rows returned: 2

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	112	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.06 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/bootstrap-horizontal.php:161
11	require JROOT/modules/mod_cblogin/tmpl/bootstrap-horizontal.php	JROOT/modules/mod_cblogin/mod_cblogin.php:219
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.18 ms After last query: 123.37 ms Query memory: 0.013 MB Memory before query: 11.217 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `j25_template_styles`

Explain

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

Profile

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.33 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 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.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.07 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.15 ms Query memory: 0.010 MB Memory before query: 11.243 MB Rows returned: 1

SELECT *

  FROM j25_template_styles

  WHERE `id` = '19'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_template_styles	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.07 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.]

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
3 × SELECT `id`  
  FROM `j25_menu`
```

3 × SELECT *  
  FROM `j25_comprofiler_lists`

3 × SELECT f.* 
  FROM j25_comprofiler_fields f  
  INNER JOIN j25_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

2 × SELECT template 
  FROM j25_template_styles

2 × SELECT `manifest_cache` 
  FROM `j25_extensions`

2 × SELECT `ip`,`reason` 
  FROM j25_rsfirewall_lists

2 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `j25_comprofiler_plugin`

```
2 × SELECT * 
  FROM j25_extensions
```

2 × SELECT template 
  FROM j25_template_styles as s

2 × SELECT `extension_id` 
  FROM `j25_extensions`

1 × SELECT `session_id` 
  FROM `j25_session`

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

1 × SELECT DISTINCT ue.*, u.*, '' AS 'NA' 
  FROM j25_users u  JOIN j25_user_usergroup_map g 
  ON g.`user_id` = u.`id`  JOIN j25_comprofiler ue 
  ON ue.`id` = u.`id`

1 × SELECT COUNT( DISTINCT u.id ) 
  FROM j25_users u  JOIN j25_user_usergroup_map g 
  ON g.`user_id` = u.`id`  JOIN j25_comprofiler ue 
  ON ue.`id` = u.`id`

1 × SELECT *  
  FROM `j25_cbsubs_config`

1 × SELECT * 
  FROM j25_comprofiler_tabs t

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

1 × SELECT a.mirror_id 
  FROM j25_advancedmodules AS a

1 × SELECT a.params 
  FROM j25_advancedmodules AS a

1 × SELECT ts.template 
  FROM j25_template_styles AS ts 
  INNER JOIN j25_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT a.* 
  FROM `j25_cbsubs_plans` AS a  
  LEFT JOIN `j25_cbsubs_plans` AS b 
  ON b.`id` = a.`parent`

1 × SELECT * 
  FROM j25_rsfirewall_snapshots

1 × SELECT `params`  
  FROM `j25_comprofiler_plugin`

1 × SELECT * 
  FROM j25_rsfirewall_exceptions

1 × SELECT id, rules 
  FROM `j25_viewlevels

1 × SELECT * 
  FROM j25_rsfirewall_hashes

1 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM j25_extensions

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

1 × SELECT ts.template  
  FROM j25_menu as m  
  INNER JOIN j25_template_styles as ts 
  ON ts.id = m.template_style_id

1 × SELECT extension, file, type 
  FROM j25_rokcommon_configs

1 × SELECT * 
  FROM j25_rsfirewall_configuratio

1 × SELECT `file` 
  FROM j25_rsfirewall_hashes

1 × SELECT `path` 
  FROM j25_rsfirewall_ignored

1 × SELECT `query` 
  FROM `j25_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `j25_admintools_storage`

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

1 × SELECT * 
  FROM j25_template_styles

OTHER Tables:

1 × INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('cn18c1d1vndll85arooi7jnlt0', 1, '1539776493', 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `j25_rsfirewall_logs

1 × UPDATE `j25_extensions` 
  SET `params` = '{\"mediaversion\":\"3634906809389799d0b59a6cace4cb1a\"}'

1 × SHOW VARIABLES LIKE "collation_database

1 × SHOW FULL COLUMNS 
  FROM `j25_extensions

1 × SHOW FULL COLUMNS 
  FROM `j25_users

1 × SHOW FULL COLUMNS 
  FROM `j25_template_styles