Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1696440101,
                "last": 1696440101,
                "now": 1696440101
            },
            "token": "FYK0cfJph65EFgimgeRCiXLq8yHoVe0h"
        },
        "registry": {
            "mobilejoomla": {
                "cache": "ZY9bDoJADEX30hUA8UHufPqvSzCVqTCBETIdNYawdxmRxMSvJue26bmMHKNiB7LycJWQYZRf4jm094GMIgOlkeegINyd1+SC7Iu1CiK3p7OxIeMWXKy4EVc38Zc7z7Vc++A5KpnjTMv5n\/MSX4MsYAsaOLBPRhnGSbEBsbeWzClta7SHjlUJRfKdw+VWsU9ltI39x\/2\/yDRNbw==",
                "markup": ""
            }
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Memory Usage

Database Queries

43 Queries Logged 93.94 ms

14 duplicate found!

2 duplicates: #14 #18

2 duplicates: #15 #19

2 duplicates: #16 #20

4 duplicates: #33 #38 #39 #40

2 duplicates: #36 #41

2 duplicates: #37 #42

Query Time: 2.76 ms Query memory: 0.018 MB Memory before query: 3.162 MB Rows returned: 0

SELECT `data`

  FROM `m2vn6_session`

  WHERE `session_id` = 'jrt0n8nq2769k0gg0gh4hh05t3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m2vn6_session	const	PRIMARY	PRIMARY	766	const	1

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
Checking query cache for query	0.09 ms
checking permissions	0.03 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
Waiting for query cache lock	0.07 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	1.05 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.73 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 2.50 ms After last query: 8.67 ms Query memory: 0.008 MB Memory before query: 3.404 MB

DELETE 

  FROM `m2vn6_session`

  WHERE `time` < '1696439201'

Explain

EXPLAIN not possible on query: DELETE FROM `m2vn6_session` WHERE `time` < '1696439201'

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:765
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 2.01 ms After last query: 0.30 ms Query memory: 0.012 MB Memory before query: 3.416 MB Rows returned: 0

SELECT `session_id`

  FROM `m2vn6_session`

  WHERE `session_id` = 'jrt0n8nq2769k0gg0gh4hh05t3' 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.03 ms
Checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Waiting for query cache lock	1.24 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.04 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.26 ms After last query: 0.34 ms Query memory: 0.009 MB Memory before query: 3.429 MB

INSERT INTO `m2vn6_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('jrt0n8nq2769k0gg0gh4hh05t3', 0, '1696440101')

Explain

EXPLAIN not possible on query: INSERT INTO `m2vn6_session` (`session_id`, `client_id`, `time`) VALUES ('jrt0n8nq2769k0gg0gh4hh05t3', 0, '1696440101')

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 5.39 ms After last query: 10.47 ms Query memory: 0.024 MB Memory before query: 3.866 MB Rows returned: 38

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

  FROM m2vn6_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m2vn6_extensions	ref	extension	extension	82	const	38	Using index condition

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.11 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.06 ms
init	0.09 ms
Optimizing	0.04 ms
Statistics	1.03 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	2.84 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.34 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.73 ms After last query: 4.61 ms Query memory: 0.014 MB Memory before query: 4.057 MB Rows returned: 2

SELECT b.id

  FROM m2vn6_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.03 ms
starting	0.01 ms
Checking query cache for query	0.12 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.05 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	1.49 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.04 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.32 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.98 ms After last query: 1.64 ms Query memory: 0.013 MB Memory before query: 4.121 MB Rows returned: 5

SELECT id, rules

  FROM `m2vn6_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.23 ms
After opening tables	0.05 ms
System lock	0.03 ms
table lock	0.03 ms
Waiting for query cache lock	0.07 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.96 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.39 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.15 ms After last query: 0.53 ms Query memory: 0.013 MB Memory before query: 4.140 MB Rows returned: 61

SELECT folder AS type, element AS name, params

  FROM m2vn6_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.02 ms
Checking query cache for query	0.09 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
Optimizing	0.07 ms
Statistics	0.11 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.78 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.39 ms
Waiting for query cache lock	0.04 ms
Updating status	0.02 ms
Storing result in query cache	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 12.87 ms After last query: 91.97 ms Query memory: 0.023 MB Memory before query: 7.857 MB Rows returned: 0

SELECT `data` 
  FROM `m2vn6_mj_amdd` 
  WHERE `ua`='CCBot/2.0 (https://commoncrawl.org/faq/)'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.08 ms
checking permissions	0.03 ms
Opening tables	10.52 ms
After opening tables	0.04 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.02 ms
closing tables	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	1.24 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.05 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
18	JDatabaseDriver->loadResult()	JROOT/plugins/mobile/amdd/amdd/database/joomla/db.joomla.php:61
17	AmddDatabaseJoomla->getDevice()	JROOT/plugins/mobile/amdd/amdd/amdd.php:82
16	Amdd::getDevice()	JROOT/plugins/mobile/amdd/amdd/amdd.php:51
15	Amdd::getCapabilities()	JROOT/plugins/mobile/amdd/amdd.php:39
14	plgMobileAmdd->onDeviceDetection()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
10	JApplicationBase->triggerEvent()	JROOT/plugins/system/mobilebot/mobilebot.php:106
9	plgSystemMobileBot->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.29 ms After last query: 4.05 ms Query memory: 0.017 MB Memory before query: 8.069 MB Rows returned: 1

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'pro_plugin'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.52 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.20 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:103
11	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:68
10	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1258
9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 7.07 ms Query memory: 0.017 MB Memory before query: 8.445 MB Rows returned: 1

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'geoblock'

Explain

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

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Waiting for query cache lock	0.05 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.21 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:73
11	SecuritycheckprosModelGeoblock->load()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:38
10	SecuritycheckprosModelGeoblock->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1286
9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.22 ms After last query: 23.93 ms Query memory: 0.014 MB Memory before query: 8.700 MB

DELETE 
  FROM `m2vn6_securitycheckpro_dynamic_blacklist` 
  WHERE (DATE_ADD(`timeattempt`, INTERVAL 600 SECOND)) < NOW();

Explain

EXPLAIN not possible on query: DELETE FROM `m2vn6_securitycheckpro_dynamic_blacklist` WHERE (DATE_ADD(`timeattempt`, INTERVAL 600 SECOND)) < NOW();

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:664
11	plgSystemSecuritycheckpro->pasar_a_historico()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:699
10	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1346
9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 0.27 ms Query memory: 0.017 MB Memory before query: 8.716 MB Rows returned: 1

SELECT COUNT(*) 
  from `m2vn6_securitycheckpro_dynamic_blacklist` 
  WHERE (`ip` = '34.204.181.91' 
  AND `counter` >= 5)

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
Checking query cache for query	0.07 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.02 ms
Updating status	0.13 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:639
11	plgSystemSecuritycheckpro->chequear_ip_en_lista_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:701
10	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1346
9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 5.75 ms Query memory: 0.017 MB Memory before query: 9.165 MB Rows returned: 1

Duplicate queries: #18

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'filemanager_resume'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199
11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:207
10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.34 ms Query memory: 0.017 MB Memory before query: 9.182 MB Rows returned: 1

Duplicate queries: #19

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'fileintegrity_resume'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207
11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:207
10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.21 ms Query memory: 0.017 MB Memory before query: 9.199 MB Rows returned: 1

Duplicate queries: #20

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'malwarescan_resume'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215
11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:207
10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.23 ms Query memory: 0.017 MB Memory before query: 9.213 MB Rows returned: 1

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'cron_plugin'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:103
11	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:68
10	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:154
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->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.40 ms Query memory: 0.018 MB Memory before query: 9.236 MB Rows returned: 1

Duplicate queries: #14

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'filemanager_resume'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199
12	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:207
11	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:159
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->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.21 ms Query memory: 0.018 MB Memory before query: 9.254 MB Rows returned: 1

Duplicate queries: #15

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'fileintegrity_resume'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207
12	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:207
11	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:159
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->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.24 ms Query memory: 0.018 MB Memory before query: 9.272 MB Rows returned: 1

Duplicate queries: #16

SELECT `storage_value`

  FROM `m2vn6_securitycheckpro_storage`

  WHERE `storage_key` = 'malwarescan_resume'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215
12	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:207
11	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:159
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 0.20 ms Query memory: 0.016 MB Memory before query: 9.287 MB Rows returned: 1

SELECT `last_task`

  FROM `m2vn6_securitycheckpro_file_manager`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m2vn6_securitycheckpro_file_manager	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102
10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:159
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->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.17 ms Query memory: 0.016 MB Memory before query: 9.302 MB Rows returned: 1

SELECT `last_check_integrity`

  FROM `m2vn6_securitycheckpro_file_manager`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m2vn6_securitycheckpro_file_manager	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:110
10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:159
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.33 ms Query memory: 0.015 MB Memory before query: 9.310 MB Rows returned: 1

SELECT cron_tasks_launched 
  FROM m2vn6_securitycheckpro_file_manager 
  WHERE id=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m2vn6_securitycheckpro_file_manager	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:171
9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.66 ms After last query: 9.97 ms Query memory: 0.025 MB Memory before query: 9.885 MB Rows returned: 2

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

  FROM m2vn6_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	2	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	dpadm_prevenade.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.10 ms
checking permissions	0.02 ms
Opening tables	0.15 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
Waiting for query cache lock	0.06 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	1.07 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.57 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.21 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.42 ms After last query: 2.08 ms Query memory: 0.024 MB Memory before query: 9.977 MB Rows returned: 1

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

  FROM m2vn6_extensions

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/mobilebot/mobilebot.php:354
9	plgSystemMobileBot->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.24 ms After last query: 4.98 ms Query memory: 0.017 MB Memory before query: 10.116 MB

UPDATE `m2vn6_extensions`

  SET `params` = '{\"mediaversion\":\"2b5e9b9e1016997ffcc03a9cc1fca0d8\"}'

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/mobilebot/mobilebot.php:354
9	plgSystemMobileBot->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.86 ms After last query: 5.21 ms Query memory: 0.016 MB Memory before query: 10.467 MB Rows returned: 0

SELECT p.folder AS type, p.element AS name 
  FROM m2vn6_mj_plugins AS mj 
  LEFT JOIN m2vn6_extensions AS p 
  ON p.extension_id=mj.id 
  WHERE mj.markup='desktop'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	2.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.05 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/mobilebot/mobilebot.php:744
10	plgSystemMobileBot->filterExtensions()	JROOT/plugins/system/mobilebot/mobilebot.php:392
9	plgSystemMobileBot->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.39 ms After last query: 0.18 ms Query memory: 0.016 MB Memory before query: 10.482 MB Rows returned: 0

SELECT m.id, m.position 
  FROM m2vn6_mj_modules AS mj 
  LEFT JOIN m2vn6_modules AS m 
  ON m.id=mj.id 
  WHERE mj.markup='desktop'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	4.57 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.07 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.03 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/mobilebot/mobilebot.php:756
10	plgSystemMobileBot->filterExtensions()	JROOT/plugins/system/mobilebot/mobilebot.php:392
9	plgSystemMobileBot->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.45 ms After last query: 3.43 ms Query memory: 0.013 MB Memory before query: 10.566 MB Rows returned: 1

SELECT *

  FROM m2vn6_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 6.28 ms After last query: 0.81 ms Query memory: 0.010 MB Memory before query: 10.587 MB Rows returned: 11

SELECT id, home, template, s.params

  FROM m2vn6_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	10	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	dpadm_prevenade.e.element	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	3.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.06 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.04 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	1.80 ms
Waiting for query cache lock	0.02 ms
Sending data	0.50 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.21 ms After last query: 21.30 ms Query memory: 0.028 MB Memory before query: 11.403 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `m2vn6_bagrid_bagrids`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_bagrid/tables/bagrids.php:17
14	bagridTableBagrids->__construct()	JROOT/libraries/joomla/table/table.php:305
13	JTable::getInstance()	JROOT/components/com_bagrid/models/page.php:15
12	bagridModelPage->getTable()	JROOT/components/com_bagrid/models/page.php:22
11	bagridModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_bagrid/views/page/view.html.php:17
9	bagridViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_bagrid/bagrid.php:13
6	require_once JROOT/components/com_bagrid/bagrid.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.56 ms After last query: 3.09 ms Query memory: 0.044 MB Memory before query: 11.486 MB Rows returned: 1

SELECT *

  FROM `m2vn6_bagrid_bagrids`

  WHERE `id`=30

Explain

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

Profile

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
Checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.05 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.74 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.23 ms
Waiting for query cache lock	0.02 ms
Sending data	0.67 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
12	JDatabaseDriver->loadObject()	JROOT/components/com_bagrid/models/page.php:33
11	bagridModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_bagrid/views/page/view.html.php:17
9	bagridViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_bagrid/bagrid.php:13
6	require_once JROOT/components/com_bagrid/bagrid.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.39 ms After last query: 3.42 ms Query memory: 0.019 MB Memory before query: 11.859 MB Rows returned: 0

Duplicate queries: #38 #39 #40

SELECT tag_id

  FROM m2vn6_bagrid_tags_map

  WHERE `page_id` = 30

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	2.48 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.03 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.17 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.08 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_bagrid/helpers/bagrid.php:312
12	bagridHelper::getPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:890
11	bagridHelper::addPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:815
10	bagridHelper::checkMOdules()	JROOT/components/com_bagrid/views/page/view.html.php:40
9	bagridViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_bagrid/bagrid.php:13
6	require_once JROOT/components/com_bagrid/bagrid.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.31 ms After last query: 3.08 ms Query memory: 0.021 MB Memory before query: 11.962 MB Rows returned: 1

SELECT a.rules

  FROM m2vn6_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	4.29 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.12 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.53 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
14	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
13	JUser->authorise()	JROOT/components/com_bagrid/views/page/tmpl/default.php:13
12	include JROOT/components/com_bagrid/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/components/com_bagrid/views/page/view.html.php:43
9	bagridViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_bagrid/bagrid.php:13
6	require_once JROOT/components/com_bagrid/bagrid.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.17 ms After last query: 1.91 ms Query memory: 0.023 MB Memory before query: 12.020 MB Rows returned: 2

SELECT b.rules

  FROM m2vn6_assets AS a

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

  WHERE (a.name = 'com_bagrid')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	68	Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.09 ms
checking permissions	0.02 ms
Opening tables	0.40 ms
After opening tables	0.02 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.93 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Creating tmp table	0.13 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.76 ms
Creating sort index	0.11 ms
Removing tmp table	0.17 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.21 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
15	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
13	JUser->authorise()	JROOT/components/com_bagrid/views/page/tmpl/default.php:13
12	include JROOT/components/com_bagrid/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/components/com_bagrid/views/page/view.html.php:43
9	bagridViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_bagrid/bagrid.php:13
6	require_once JROOT/components/com_bagrid/bagrid.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.02 ms After last query: 12.24 ms Query memory: 0.015 MB Memory before query: 12.583 MB Rows returned: 1

Duplicate queries: #41

SELECT theme

  FROM m2vn6_bagrid_bagrids

  WHERE `id` = '30'

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
Waiting for query cache lock	0.04 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.07 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.33 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
10	JDatabaseDriver->loadResult()	JROOT/components/com_bagrid/helpers/bagrid.php:716
9	bagridHelper::getTheme()	JROOT/components/com_bagrid/helpers/bagrid.php:683
8	bagridHelper::checkParams()	JROOT/templates/gridboxcore/index.php:23
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 0.19 ms Query memory: 0.015 MB Memory before query: 12.597 MB Rows returned: 1

Duplicate queries: #42

SELECT params

  FROM m2vn6_template_styles

  WHERE `id`='13'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.15 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.29 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
10	JDatabaseDriver->loadResult()	JROOT/components/com_bagrid/helpers/bagrid.php:697
9	bagridHelper::getThemeParams()	JROOT/components/com_bagrid/helpers/bagrid.php:684
8	bagridHelper::checkParams()	JROOT/templates/gridboxcore/index.php:23
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.97 ms Query memory: 0.016 MB Memory before query: 12.686 MB Rows returned: 0

Duplicate queries: #33 #39 #40

SELECT tag_id

  FROM m2vn6_bagrid_tags_map

  WHERE `page_id` = 30

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	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.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_bagrid/helpers/bagrid.php:312
10	bagridHelper::getPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:890
9	bagridHelper::addPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:815
8	bagridHelper::checkMOdules()	JROOT/templates/gridboxcore/index.php:29
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.19 ms Query memory: 0.016 MB Memory before query: 12.702 MB Rows returned: 0

Duplicate queries: #33 #38 #40

SELECT tag_id

  FROM m2vn6_bagrid_tags_map

  WHERE `page_id` = 30

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_bagrid/helpers/bagrid.php:312
10	bagridHelper::getPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:890
9	bagridHelper::addPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:815
8	bagridHelper::checkMOdules()	JROOT/templates/gridboxcore/index.php:30
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->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.21 ms Query memory: 0.016 MB Memory before query: 12.717 MB Rows returned: 0

Duplicate queries: #33 #38 #39

SELECT tag_id

  FROM m2vn6_bagrid_tags_map

  WHERE `page_id` = 30

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.03 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.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_bagrid/helpers/bagrid.php:312
10	bagridHelper::getPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:890
9	bagridHelper::addPageTags()	JROOT/components/com_bagrid/helpers/bagrid.php:815
8	bagridHelper::checkMOdules()	JROOT/templates/gridboxcore/index.php:31
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 5.56 ms Query memory: 0.017 MB Memory before query: 13.126 MB Rows returned: 1

Duplicate queries: #36

SELECT theme

  FROM m2vn6_bagrid_bagrids

  WHERE `id` = '30'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
11	JDatabaseDriver->loadResult()	JROOT/components/com_bagrid/helpers/bagrid.php:716
10	bagridHelper::getTheme()	JROOT/components/com_bagrid/helpers/bagrid.php:683
9	bagridHelper::checkParams()	JROOT/templates/gridboxcore/style.php:14
8	include_once JROOT/templates/gridboxcore/style.php	JROOT/templates/gridboxcore/index.php:155
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.20 ms Query memory: 0.017 MB Memory before query: 13.142 MB Rows returned: 1

Duplicate queries: #37

SELECT params

  FROM m2vn6_template_styles

  WHERE `id`='13'

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	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.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
11	JDatabaseDriver->loadResult()	JROOT/components/com_bagrid/helpers/bagrid.php:697
10	bagridHelper::getThemeParams()	JROOT/components/com_bagrid/helpers/bagrid.php:684
9	bagridHelper::checkParams()	JROOT/templates/gridboxcore/style.php:14
8	include_once JROOT/templates/gridboxcore/style.php	JROOT/templates/gridboxcore/index.php:155
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.36 ms After last query: 3.20 ms Query memory: 0.020 MB Memory before query: 13.016 MB Rows returned: 6

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM m2vn6_modules AS m

  LEFT JOIN m2vn6_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-10-04 17:21:42') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-04 17:21:42') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	10	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	dpadm_prevenade.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	dpadm_prevenade.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.18 ms
checking permissions	0.02 ms
Opening tables	2.01 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Waiting for query cache lock	0.01 ms
closing tables	0.05 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.65 ms
Preparing	0.10 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.13 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/gridboxcore/index.php:182
7	require JROOT/templates/gridboxcore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT `storage_value` 
  FROM `m2vn6_securitycheckpro_storage`

4 × SELECT tag_id 
  FROM m2vn6_bagrid_tags_map

2 × SELECT params 
  FROM m2vn6_template_styles

2 × SELECT theme 
  FROM m2vn6_bagrid_bagrids

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM m2vn6_extensions

1 × SELECT m.id, m.position 
  FROM m2vn6_mj_modules AS mj 
  LEFT JOIN m2vn6_modules AS m 
  ON m.id=mj.id

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

```
1 × SELECT * 
  FROM m2vn6_languages
```

1 × SELECT * 
  FROM `m2vn6_bagrid_bagrids`

1 × SELECT a.rules 
  FROM m2vn6_assets AS a

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM m2vn6_modules AS m 
  LEFT JOIN m2vn6_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN m2vn6_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 × SELECT p.folder AS type, p.element AS name 
  FROM m2vn6_mj_plugins AS mj 
  LEFT JOIN m2vn6_extensions AS p 
  ON p.extension_id=mj.id

1 × SELECT cron_tasks_launched 
  FROM m2vn6_securitycheckpro_file_manager

1 × SELECT folder AS type, element AS name, params 
  FROM m2vn6_extensions

1 × SELECT id, rules 
  FROM `m2vn6_viewlevels

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

1 × SELECT `session_id` 
  FROM `m2vn6_session`

1 × SELECT `data` 
  FROM `m2vn6_mj_amdd`

1 × SELECT COUNT(*) 
  from `m2vn6_securitycheckpro_dynamic_blacklist`

1 × SELECT `data` 
  FROM `m2vn6_session`

1 × SELECT `last_check_integrity` 
  FROM `m2vn6_securitycheckpro_file_manager

1 × SELECT `last_task` 
  FROM `m2vn6_securitycheckpro_file_manager

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM m2vn6_menu AS m 
  LEFT JOIN m2vn6_extensions AS e 
  ON m.component_id = e.extension_id

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `m2vn6_bagrid_bagrids

1 × UPDATE `m2vn6_extensions` 
  SET `params` = '{\"mediaversion\":\"2b5e9b9e1016997ffcc03a9cc1fca0d8\"}'

1 × DELETE 
  FROM `m2vn6_securitycheckpro_dynamic_blacklist`

1 × INSERT INTO `m2vn6_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('jrt0n8nq2769k0gg0gh4hh05t3', 0, '1696440101'

```
1 × DELETE  
  FROM `m2vn6_session`
```

Bebida isotónica rehidratante en México.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

43 Queries Logged 93.94 ms

14 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: