Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1634329041,
                "last": 1634329041,
                "now": 1634329041
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [
                "1"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 10.54 ms / 10.54 ms Memory: 0.395 MB / 0.76 MB Application: afterLoad

Time: 98.54 ms / 109.08 ms Memory: 3.981 MB / 4.74 MB Application: afterInitialise

Time: 10.91 ms / 119.99 ms Memory: 0.629 MB / 5.37 MB Application: afterRoute

Time: 4.88 ms / 124.87 ms Memory: 0.195 MB / 5.57 MB Application: beforeRenderComponent com_content

Time: 39.77 ms / 164.64 ms Memory: 2.072 MB / 7.64 MB Application: afterRenderComponent com_content

Time: 7.51 ms / 172.15 ms Memory: 0.095 MB / 7.74 MB Application: afterDispatch

Time: 5.30 ms / 177.45 ms Memory: 0.149 MB / 7.88 MB Application: beforeRenderModule mod_custom (Flash VIDEO LINKS)

Time: 1.13 ms / 178.58 ms Memory: 0.025 MB / 7.91 MB Application: afterRenderModule mod_custom (Flash VIDEO LINKS)

Time: 0.24 ms / 178.82 ms Memory: 0.013 MB / 7.92 MB Application: beforeRenderModule mod_custom (webmaster email)

Time: 4.24 ms / 183.06 ms Memory: 0.771 MB / 8.69 MB Application: afterRenderModule mod_custom (webmaster email)

Time: 0.26 ms / 183.32 ms Memory: 0.013 MB / 8.71 MB Application: beforeRenderModule mod_custom (Sponsors)

Time: 0.54 ms / 183.85 ms Memory: 0.003 MB / 8.71 MB Application: afterRenderModule mod_custom (Sponsors)

Time: 0.23 ms / 184.08 ms Memory: 0.013 MB / 8.72 MB Application: beforeRenderModule mod_custom (5 Doormat T - W)

Time: 0.52 ms / 184.61 ms Memory: 0.003 MB / 8.72 MB Application: afterRenderModule mod_custom (5 Doormat T - W)

Time: 0.23 ms / 184.84 ms Memory: 0.013 MB / 8.74 MB Application: beforeRenderModule mod_custom (4 Doormat O - S)

Time: 0.53 ms / 185.37 ms Memory: 0.003 MB / 8.74 MB Application: afterRenderModule mod_custom (4 Doormat O - S)

Time: 0.23 ms / 185.60 ms Memory: 0.013 MB / 8.75 MB Application: beforeRenderModule mod_custom (3 Doormat H - M)

Time: 0.53 ms / 186.12 ms Memory: 0.004 MB / 8.76 MB Application: afterRenderModule mod_custom (3 Doormat H - M)

Time: 0.23 ms / 186.35 ms Memory: 0.013 MB / 8.77 MB Application: beforeRenderModule mod_custom (2 Doormat E - G)

Time: 0.53 ms / 186.88 ms Memory: 0.003 MB / 8.77 MB Application: afterRenderModule mod_custom (2 Doormat E - G)

Time: 0.22 ms / 187.10 ms Memory: 0.014 MB / 8.79 MB Application: beforeRenderModule mod_custom (1 Doormat A - C)

Time: 0.51 ms / 187.61 ms Memory: 0.003 MB / 8.79 MB Application: afterRenderModule mod_custom (1 Doormat A - C)

Time: 0.22 ms / 187.83 ms Memory: 0.013 MB / 8.80 MB Application: beforeRenderModule mod_custom (Video Home)

Time: 0.51 ms / 188.33 ms Memory: 0.003 MB / 8.81 MB Application: afterRenderModule mod_custom (Video Home)

Time: 0.23 ms / 188.57 ms Memory: 0.013 MB / 8.82 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.50 ms / 189.07 ms Memory: 0.003 MB / 8.82 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.25 ms / 189.32 ms Memory: 0.017 MB / 8.84 MB Application: beforeRenderModule mod_ariextmenu (Top Menu)

Time: 9.24 ms / 198.56 ms Memory: 0.297 MB / 9.14 MB Application: afterRenderModule mod_ariextmenu (Top Menu)

Time: 0.23 ms / 198.79 ms Memory: 0.003 MB / 9.14 MB Application: beforeRenderModule mod_jdlanguage (Languages)

Time: 12.91 ms / 211.70 ms Memory: 0.348 MB / 9.49 MB Application: afterRenderModule mod_jdlanguage (Languages)

Time: 7.51 ms / 219.21 ms Memory: 0.139 MB / 9.63 MB Application: afterRender

Database queries total: 30.09 ms

Memory Usage

Database Queries

55 Queries Logged 30.09 ms

8 duplicate found!

8 duplicates: #33 #36 #39 #42 #45 #48 #51 #54

Query Time: 0.47 ms Query memory: 0.023 MB Memory before query: 2.497 MB Rows returned: 0

SELECT `data`

  FROM `js_session`

  WHERE `session_id` = 'a61491ec15795469e3239329f1fc4347'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_session	const	PRIMARY	PRIMARY	575	const	1

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
15	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
14	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/libraries/jdiction/database/jddatabase.php:138
12	JdDatabase->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
11	JSessionStorageDatabase->read()	Same as call in the line below.
10	session_start()	JROOT/libraries/joomla/session/handler/native.php:79
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:628
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: 0.81 ms After last query: 2.80 ms Query memory: 0.004 MB Memory before query: 2.628 MB

DELETE 

  FROM `js_session`

  WHERE `time` < '1634325441'

Explain

EXPLAIN not possible on query: DELETE FROM `js_session` WHERE `time` < '1634325441'

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.07 ms
Updating	0.37 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.11 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
7	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
6	JdDatabase->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: 0.39 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.634 MB Rows returned: 0

SELECT `session_id`

  FROM `js_session`

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

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
10	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
9	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1731
8	JDatabaseDriver->loadResult()	JROOT/libraries/jdiction/database/jddatabase.php:138
7	JdDatabase->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: 0.46 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 2.639 MB

INSERT INTO `js_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('a61491ec15795469e3239329f1fc4347', 0, '1634329041')

Explain

EXPLAIN not possible on query: INSERT INTO `js_session` (`session_id`, `client_id`, `time`) VALUES ('a61491ec15795469e3239329f1fc4347', 0, '1634329041')

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.11 ms
Waiting for query cache lock	0.01 ms
Update	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.10 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
8	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
7	JdDatabase->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: 0.94 ms After last query: 3.71 ms Query memory: 0.024 MB Memory before query: 2.899 MB Rows returned: 36

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

  FROM js_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_extensions	ref	extension	extension	62	const	36	Using index condition

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.51 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.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 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.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
11	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
10	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
8	JdDatabase->loadObjectList()	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: 0.10 ms After last query: 1.29 ms Query memory: 0.022 MB Memory before query: 3.056 MB Rows returned: 1

SELECT b.id

  FROM js_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
12	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
11	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1541
10	JDatabaseDriver->loadColumn()	JROOT/libraries/jdiction/database/jddatabase.php:164
9	JdDatabase->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: 0.09 ms After last query: 0.47 ms Query memory: 0.021 MB Memory before query: 3.090 MB Rows returned: 5

SELECT id, rules

  FROM `js_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
11	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
10	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1497
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/jdiction/database/jddatabase.php:204
8	JdDatabase->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: 1.35 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.101 MB Rows returned: 50

SELECT folder AS type, element AS name, params

  FROM js_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_extensions	ref	extension	extension	62	const	63	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.88 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.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
9	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
8	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
6	JdDatabase->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: 0.11 ms After last query: 1.91 ms Query memory: 0.023 MB Memory before query: 3.251 MB Rows returned: 8

SELECT *

  FROM js_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
11	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
10	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
8	JdDatabase->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
7	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:61
6	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
5	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
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: 0.53 ms After last query: 0.40 ms Query memory: 0.021 MB Memory before query: 3.278 MB Rows returned: 9

SELECT element

  FROM js_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_extensions	ref	extension	extension	62	const	18	Using index condition; Using where

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.13 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.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
11	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
10	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
8	JdDatabase->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
7	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:72
6	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
5	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
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: 0.79 ms After last query: 49.84 ms Query memory: 0.031 MB Memory before query: 4.109 MB Rows returned: 81

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Checking permissions	0.38 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
29	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
28	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1541
27	JDatabaseDriver->loadColumn()	JROOT/libraries/jdiction/database/jddatabase.php:164
26	JdDatabase->loadColumn()	JROOT/libraries/jdiction/database/driver/mysqli.php:201
25	JdDatabaseAdapter->getTableList()	JROOT/libraries/jdiction/database/jddatabase.php:676
24	JdDatabase->getTableList()	JROOT/libraries/jdiction/database/jddatabase.php:494
23	JdDatabase->addJoinKeys()	JROOT/libraries/jdiction/database/jddatabase.php:460
22	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
21	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
20	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:258
19	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
8	PlgSystemLanguageFilter->onAfterInitialise()	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.19 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 4.135 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `js_extensions`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.49 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.20 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.12 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
30	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
29	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
27	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/database/driver/mysqli.php:163
26	JdDatabaseAdapter->getTableColumns()	JROOT/libraries/jdiction/database/jddatabase.php:709
25	JdDatabase->getTableColumns()	JROOT/libraries/jdiction/database/jddatabase.php:645
24	JdDatabase->getPrimaryKey()	JROOT/libraries/jdiction/database/jddatabase.php:542
23	JdDatabase->addJoinKeys()	JROOT/libraries/jdiction/database/jddatabase.php:460
22	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
21	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
20	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:258
19	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
8	PlgSystemLanguageFilter->onAfterInitialise()	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.17 ms After last query: 0.08 ms Query memory: 0.033 MB Memory before query: 4.166 MB Rows returned: 24

SHOW FULL COLUMNS 
  FROM `js_menu`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.42 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.23 ms
Closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
30	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
29	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
27	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/database/driver/mysqli.php:163
26	JdDatabaseAdapter->getTableColumns()	JROOT/libraries/jdiction/database/jddatabase.php:709
25	JdDatabase->getTableColumns()	JROOT/libraries/jdiction/database/jddatabase.php:645
24	JdDatabase->getPrimaryKey()	JROOT/libraries/jdiction/database/jddatabase.php:542
23	JdDatabase->addJoinKeys()	JROOT/libraries/jdiction/database/jddatabase.php:460
22	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
21	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
20	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:258
19	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
8	PlgSystemLanguageFilter->onAfterInitialise()	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.65 ms After last query: 0.09 ms Query memory: 0.070 MB Memory before query: 4.203 MB Rows returned: 28

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,`e`.`extension_id` AS `JD_MAGIC_KEY_1`,`m`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	eumen.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.73 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.27 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
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.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
23	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
22	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
21	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
20	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:258
19	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
8	PlgSystemLanguageFilter->onAfterInitialise()	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.10 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 4.327 MB Rows returned: 8

SELECT lang_id, lang_code

  FROM js_languages

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_languages	index	NULL	idx_langcode	21	NULL	8	Using index

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
26	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
25	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1497
24	JDatabaseDriver->loadAssocList()	JROOT/libraries/jdiction/database/jddatabase.php:204
23	JdDatabase->loadAssocList()	JROOT/libraries/jdiction/database/jddatabase.php:740
22	JdDatabase->setLanguage()	JROOT/libraries/jdiction/database/jddatabase.php:760
21	JdDatabase->getLanguage()	JROOT/libraries/jdiction/database/jddatabase.php:378
20	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:258
19	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
8	PlgSystemLanguageFilter->onAfterInitialise()	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.09 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 4.342 MB Rows returned: 0

SELECT *

  FROM js_jd_store

  WHERE idLang='1' 
  AND referenceTable='#__menu'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	ref	idLang	idLang	204	const,const	1	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
26	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
25	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
23	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
22	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
21	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
20	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:258
19	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
8	PlgSystemLanguageFilter->onAfterInitialise()	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.59 ms After last query: 4.16 ms Query memory: 0.068 MB Memory before query: 4.759 MB Rows returned: 28

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 js_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	eumen.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.69 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.26 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.03 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.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
17	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
16	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
14	JdDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/plugins/system/jdiction/jdiction.php:122
10	plgSystemjDiction->parseRule()	JROOT/libraries/cms/router/router.php:593
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:567
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:223
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
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: 0.56 ms After last query: 9.10 ms Query memory: 0.023 MB Memory before query: 5.409 MB Rows returned: 1

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

  FROM js_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.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.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 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.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
15	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
14	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/libraries/jdiction/database/jddatabase.php:230
12	JdDatabase->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:157
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
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: 0.65 ms After last query: 0.14 ms Query memory: 0.005 MB Memory before query: 5.401 MB

UPDATE `js_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.11 ms
Updating	0.12 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.06 ms
Query end	0.01 ms
Commit	0.12 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
11	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
10	JdDatabase->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
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: 0.89 ms After last query: 1.81 ms Query memory: 0.020 MB Memory before query: 5.559 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM js_template_styles as s

  LEFT JOIN js_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	62	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.32 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.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
8	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
7	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
5	JdDatabase->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: 0.12 ms After last query: 5.92 ms Query memory: 0.024 MB Memory before query: 6.038 MB Rows returned: 1

SELECT a.rules

  FROM js_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.01 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
17	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
16	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1541
15	JDatabaseDriver->loadColumn()	JROOT/libraries/jdiction/database/jddatabase.php:164
14	JdDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:246
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 0.10 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 6.065 MB Rows returned: 2

SELECT b.rules

  FROM js_assets AS a

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

  WHERE (a.name = 'com_content')

  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	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	10	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
18	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
17	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1541
16	JDatabaseDriver->loadColumn()	JROOT/libraries/jdiction/database/jddatabase.php:164
15	JdDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:246
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.35 ms After last query: 0.65 ms Query memory: 0.033 MB Memory before query: 6.111 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `js_content`

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.50 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.28 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.12 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/database/driver/mysqli.php:163
15	JdDatabaseAdapter->getTableColumns()	JROOT/libraries/jdiction/database/jddatabase.php:709
14	JdDatabase->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 0.48 ms After last query: 3.57 ms Query memory: 0.023 MB Memory before query: 6.342 MB Rows returned: 1

SELECT *

  FROM js_content

  WHERE `id` = '2'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
14	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
13	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1456
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/jdiction/database/jddatabase.php:186
11	JdDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 0.63 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 6.349 MB

UPDATE js_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'

Explain

EXPLAIN not possible on query: UPDATE js_content SET `hits` = (`hits` + 1) WHERE `id` = '2'

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.06 ms
Updating	0.10 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.15 ms
Query end	0.01 ms
Commit	0.11 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
12	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
11	JdDatabase->execute()	JROOT/libraries/joomla/table/table.php:1249
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.63 ms After last query: 1.74 ms Query memory: 0.025 MB Memory before query: 6.462 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM js_content AS a

  LEFT JOIN js_categories AS c 
  on c.id = a.catid

  LEFT JOIN js_users AS u 
  on u.id = a.created_by

  LEFT JOIN js_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN js_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM js_categories AS cat JOIN js_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('en-GB','*') 
  AND a.id = 2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-10-15 20:17:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-10-15 20:17:21') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.32 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
Init	0.14 ms
Optimizing	0.07 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Statistics	0.21 ms
Preparing	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.05 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1653
14	JDatabaseDriver->loadObject()	JROOT/libraries/jdiction/database/jddatabase.php:230
13	JdDatabase->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:401
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.05 ms After last query: 2.47 ms Query memory: 0.025 MB Memory before query: 6.625 MB Rows returned: 2

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

  FROM js_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM js_categories AS cat JOIN js_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN js_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=11

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	eumen.c.id	10	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	5	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.29 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.17 ms
Optimizing	0.06 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Statistics	0.27 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.20 ms
Creating sort index	0.09 ms
Removing tmp table	0.03 ms
Creating sort index	0.87 ms
Creating sort index	0.09 ms
Removing tmp table	0.12 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.00 ms
Removing tmp table	0.12 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
17	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
16	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
14	JdDatabase->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 0.12 ms After last query: 1.38 ms Query memory: 0.023 MB Memory before query: 6.759 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `js_contentitem_tag_map` AS m 

  INNER JOIN `js_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	15	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	eumen.t.id	5	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
15	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
14	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
12	JdDatabase->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.47 ms After last query: 24.98 ms Query memory: 0.025 MB Memory before query: 7.851 MB Rows returned: 12

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

  FROM js_modules AS m

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

  LEFT JOIN js_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 <= '2021-10-15 20:17:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-10-15 20:17:21') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  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,idx_language	published	1	const	46	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	eumen.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	eumen.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.16 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.17 ms
Preparing	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.55 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.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
15	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
14	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
12	JdDatabase->loadObjectList()	JROOT/libraries/cms/module/helper.php:410
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:353
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/eumennet/index.php:50
7	require JROOT/templates/eumennet/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.14 ms After last query: 24.57 ms Query memory: 0.024 MB Memory before query: 9.248 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `js_menu` AS `c`

  INNER JOIN `js_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `js_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `js_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 101

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.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
17	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
16	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
14	JdDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:319
12	MenusHelper::getAssociations()	JROOT/modules/mod_jdlanguage/helper.php:49
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.75 ms After last query: 1.05 ms Query memory: 0.024 MB Memory before query: 9.268 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `js_content` AS `c`

  INNER JOIN `js_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `js_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `js_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `js_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 2

Explain

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

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.15 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.01 ms
Executing	0.03 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.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
17	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
16	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
14	JdDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:46
12	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_jdlanguage/helper.php:59
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 9.275 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 9.271 MB Rows returned: 1

Duplicate queries: #36 #39 #42 #45 #48 #51 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.10 ms After last query: 0.60 ms Query memory: 0.024 MB Memory before query: 9.280 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('nl-NL', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 9.294 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='2' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.10 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 9.306 MB Rows returned: 1

Duplicate queries: #33 #39 #42 #45 #48 #51 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.48 ms Query memory: 0.024 MB Memory before query: 9.313 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('pdt-DE', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.08 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 9.327 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='7' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.08 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 9.338 MB Rows returned: 1

Duplicate queries: #33 #36 #42 #45 #48 #51 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.10 ms After last query: 0.48 ms Query memory: 0.024 MB Memory before query: 9.346 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('de-DE', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 9.359 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='3' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 9.372 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #45 #48 #51 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.12 ms After last query: 0.50 ms Query memory: 0.024 MB Memory before query: 9.379 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('pl-PL', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 9.393 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='6' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 9.404 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #42 #48 #51 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.08 ms After last query: 0.50 ms Query memory: 0.024 MB Memory before query: 9.412 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('fr-FR', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.08 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 9.425 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='4' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.08 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 9.436 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #42 #45 #51 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.48 ms Query memory: 0.024 MB Memory before query: 9.444 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('es-ES', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 9.458 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='8' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 9.469 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #42 #45 #48 #54

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.08 ms After last query: 0.48 ms Query memory: 0.024 MB Memory before query: 9.476 MB Rows returned: 1

SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1`

  FROM js_menu

  WHERE id='101' 
  AND language in ('ru-RU', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_menu	const	PRIMARY,idx_language	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1764
14	JDatabaseDriver->loadRow()	JROOT/libraries/jdiction/database/jddatabase.php:366
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 9.490 MB Rows returned: 1

SELECT *

  FROM js_jd_store

  WHERE idLang='5' 
  AND referenceTable='#__menu' 
  AND idReference in (101)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js_jd_store	const	idLang	idLang	208	const,const,const	1

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/jdiction/jdiction.php:725
15	jDiction->getTranslation()	JROOT/libraries/jdiction/jdiction.php:572
14	jDiction->translate()	JROOT/libraries/jdiction/database/jddatabase.php:378
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:234
12	JdDatabase->loadObject()	JROOT/modules/mod_jdlanguage/helper.php:99
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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.09 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 9.504 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #42 #45 #48 #51

SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2`

  FROM js_menu AS p , js_menu AS n

  WHERE n.lft BETWEEN p.lft 
  AND p.rgt 
  AND n.id = '101' 
  AND p.alias != 'root' 
  AND p.published > 0 
  AND p.menutype = 'mainmenu' 
  AND n.menutype = 'mainmenu'

  ORDER BY p.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n	const	PRIMARY,idx_menutype,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	p	range	idx_menutype,idx_left_right,idx_alias	idx_left_right	4	NULL	7	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
16	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:465
15	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1802
14	JDatabaseDriver->loadRowList()	JROOT/libraries/jdiction/database/jddatabase.php:369
13	JdDatabase->loadTranslation()	JROOT/libraries/jdiction/database/jddatabase.php:171
12	JdDatabase->loadColumn()	JROOT/modules/mod_jdlanguage/helper.php:115
11	modJdLanguageHelper::getLink()	JROOT/modules/mod_jdlanguage/mod_jdlanguage.php:28
10	include JROOT/modules/mod_jdlanguage/mod_jdlanguage.php	JROOT/libraries/cms/module/helper.php:190
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
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: 3.29 ms After last query: 4.27 ms Query memory: 0.026 MB Memory before query: 9.608 MB Rows returned: 2

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

  FROM js_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM js_categories AS cat JOIN js_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN js_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=23

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	eumen.c.id	10	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	5	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.01 ms
Checking query cache for query	0.32 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
Init	0.19 ms
Optimizing	0.07 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Statistics	0.29 ms
Preparing	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.20 ms
Creating sort index	0.15 ms
Removing tmp table	0.03 ms
Creating sort index	0.90 ms
Creating sort index	0.09 ms
Removing tmp table	0.12 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
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/jdiction/database/driver/mysqli.php:77
19	JdDatabaseAdapter->execute()	JROOT/libraries/jdiction/database/jddatabase.php:476
18	JdDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/jdiction/database/jddatabase.php:254
16	JdDatabase->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/router.php:151
13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:483
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
10	JRouter->build()	JROOT/libraries/cms/router/site.php:134
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:81
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1074
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.]

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

8 × SELECT p.alias,`p`.`id` AS `JD_MAGIC_KEY_1`,`n`.`id` AS `JD_MAGIC_KEY_2` 
  FROM js_menu AS p , js_menu AS n

8 × SELECT id, home, title, menutype,`js_menu`.`id` AS `JD_MAGIC_KEY_1` 
  FROM js_menu

```
8 × SELECT * 
  FROM js_jd_store
```

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

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM js_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM js_categories AS cat JOIN js_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `js_content` AS `c` 
  INNER JOIN `js_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `js_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `js_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `js_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `js_menu` AS `c` 
  INNER JOIN `js_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `js_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `js_menu` AS `c2` 
  ON a2.id = c2.`id`

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

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `js_contentitem_tag_map` AS m  
  INNER JOIN `js_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM js_content AS a 
  LEFT JOIN js_categories AS c 
  on c.id = a.catid 
  LEFT JOIN js_users AS u 
  on u.id = a.created_by 
  LEFT JOIN js_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN js_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM js_categories AS cat JOIN js_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM js_content
```

1 × SELECT `data` 
  FROM `js_session`

1 × SELECT a.rules 
  FROM js_assets AS a

1 × SELECT `session_id` 
  FROM `js_session`

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 js_menu AS m 
  LEFT JOIN js_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT lang_id, lang_code 
  FROM js_language

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,`e`.`extension_id` AS `JD_MAGIC_KEY_1`,`m`.`id` AS `JD_MAGIC_KEY_2` 
  FROM js_menu AS m 
  LEFT JOIN js_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT element 
  FROM js_extensions

```
1 × SELECT * 
  FROM js_languages
```

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

1 × SELECT id, rules 
  FROM `js_viewlevels

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

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

OTHER Tables:

```
1 × DELETE  
  FROM `js_session`
```

1 × INSERT INTO `js_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('a61491ec15795469e3239329f1fc4347', 0, '1634329041'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `js_extensions

1 × SHOW FULL COLUMNS 
  FROM `js_menu

1 × UPDATE `js_extensions` 
  SET `params` = '{\"mediaversion\":\"a0a8cbdb624ce82cb15ca795eefcaac1\"}'

1 × SHOW FULL COLUMNS 
  FROM `js_content

1 × UPDATE js_content 
  SET `hits` = (`hits` + 1)

Welcome! Start your journey here

Watch the video

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

55 Queries Logged 30.09 ms

8 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: