Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1503406646,
                "last": 1503406646,
                "now": 1503406646
            },
            "token": "MgyL2IgWZbtMyrOtZY2PrlfokAiKr7Dg"
        },
        "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,
            "gid": 1
        },
        "com_mailto": {
            "links": {
                "596b49f4cd5d380d3cab8ec377aeab58a89df852": {
                    "link": "http:\/\/www.born-magazine.com\/index.php\/en\/born-magazine-3-cocktail-launch.html",
                    "expiry": 1503406646
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 7.36 ms / 7.36 ms Memory: 0.600 MB / 0.81 MB Application: afterLoad

Time: 104.81 ms / 112.17 ms Memory: 7.309 MB / 8.11 MB Application: afterInitialise

Time: 44.52 ms / 156.69 ms Memory: 1.340 MB / 9.45 MB Application: afterRoute

Time: 1.59 ms / 158.28 ms Memory: 0.076 MB / 9.53 MB Application: beforeRenderComponent com_k2

Time: 84.13 ms / 242.40 ms Memory: 3.799 MB / 13.33 MB Application: afterRenderComponent com_k2

Time: 2.67 ms / 245.07 ms Memory: 0.133 MB / 13.46 MB Application: afterDispatch

Time: 320.45 ms / 565.52 ms Memory: 5.239 MB / 18.70 MB Application: beforeRenderModule mod_pwebbox (Flotante inglés)

Time: 7.83 ms / 573.35 ms Memory: 0.496 MB / 19.20 MB Application: afterRenderModule mod_pwebbox (Flotante inglés)

Time: 0.21 ms / 573.56 ms Memory: 0.000 MB / 19.16 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 1.38 ms / 574.94 ms Memory: 0.004 MB / 19.17 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.20 ms / 575.14 ms Memory: 0.006 MB / 19.17 MB Application: beforeRenderModule mod_k2_content (Recent Posts)

Time: 15.49 ms / 590.63 ms Memory: 0.315 MB / 19.49 MB Application: afterRenderModule mod_k2_content (Recent Posts)

Time: 0.30 ms / 590.93 ms Memory: 0.000 MB / 19.40 MB Application: beforeRenderModule mod_k2_comments (Latest Comments)

Time: 4.76 ms / 595.69 ms Memory: 0.097 MB / 19.49 MB Application: afterRenderModule mod_k2_comments (Latest Comments)

Time: 0.22 ms / 595.90 ms Memory: 0.000 MB / 19.49 MB Application: beforeRenderModule mod_k2_tools (Tags)

Time: 29.27 ms / 625.17 ms Memory: 0.540 MB / 20.03 MB Application: afterRenderModule mod_k2_tools (Tags)

Time: 0.32 ms / 625.49 ms Memory: 0.000 MB / 19.99 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 8.11 ms / 633.60 ms Memory: 0.301 MB / 20.29 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 8688.19 ms / 9321.79 ms Memory: 3.830 MB / 24.12 MB Application: afterRender

Database queries total: 482.87 ms

Memory Usage

Database Queries

68 Queries Logged 482.87 ms

18 duplicate found!

2 duplicates: #18 #39

2 duplicates: #36 #49

2 duplicates: #38 #63

4 duplicates: #42 #43 #44 #64

2 duplicates: #45 #65

2 duplicates: #46 #66

2 duplicates: #47 #67

2 duplicates: #48 #68

Query Time: 0.63 ms Query memory: 0.018 MB Memory before query: 2.699 MB Rows returned: 0

SELECT `data`

  FROM `born_session`

  WHERE `session_id` = 'a3301915ebb74698f2d3d7fdfa0d8799'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.62 ms After last query: 2.28 ms Query memory: 0.012 MB Memory before query: 2.902 MB Rows returned: 0

SELECT `session_id`

  FROM `born_session`

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

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.26 ms After last query: 0.14 ms Query memory: 0.009 MB Memory before query: 2.914 MB

INSERT INTO `born_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('a3301915ebb74698f2d3d7fdfa0d8799', 0, '1503406646')

Explain

EXPLAIN not possible on query: INSERT INTO `born_session` (`session_id`, `client_id`, `time`) VALUES ('a3301915ebb74698f2d3d7fdfa0d8799', 0, '1503406646')

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.13 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.00 ms
query end	0.63 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.36 ms After last query: 3.75 ms Query memory: 0.024 MB Memory before query: 3.286 MB Rows returned: 44

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

  FROM born_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	extension	extension	82	const	44	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.13 ms After last query: 1.57 ms Query memory: 0.014 MB Memory before query: 3.458 MB Rows returned: 1

SELECT b.id

  FROM born_usergroups AS a

  LEFT JOIN born_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	11	Using index

Profile

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

Call Stack

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

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

Query Time: 0.51 ms After last query: 0.57 ms Query memory: 0.013 MB Memory before query: 3.514 MB Rows returned: 5

SELECT id, rules

  FROM `born_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_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
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
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.27 ms After last query: 0.22 ms Query memory: 0.014 MB Memory before query: 3.533 MB Rows returned: 94

SELECT folder AS type, element AS name, params

  FROM born_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	born_extensions	ref	extension	extension	82	const	126	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.28 ms
Sending data	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.53 ms After last query: 2.41 ms Query memory: 0.016 MB Memory before query: 3.799 MB Rows returned: 2

SELECT *

  FROM born_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
8	JDatabaseDriver->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.46 ms After last query: 0.44 ms Query memory: 0.013 MB Memory before query: 3.837 MB Rows returned: 5

SELECT element

  FROM born_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	born_extensions	ref	extension	extension	82	const	10	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
8	JDatabaseDriver->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.68 ms After last query: 23.25 ms Query memory: 0.013 MB Memory before query: 5.644 MB Rows returned: 1

SELECT `enabled`

  FROM `born_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
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: 5.50 ms After last query: 11.73 ms Query memory: 0.048 MB Memory before query: 6.333 MB Rows returned: 116

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

  LEFT JOIN born_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	704	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db672374894.m.component_id	1

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	1.33 ms
Sending data	0.28 ms
Waiting for query cache lock	0.01 ms
Sending data	0.78 ms
Waiting for query cache lock	0.01 ms
Sending data	0.21 ms
Waiting for query cache lock	0.01 ms
Sending data	0.51 ms
Waiting for query cache lock	0.01 ms
Sending data	0.28 ms
Waiting for query cache lock	0.00 ms
Sending data	0.73 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 7.29 ms After last query: 26.72 ms Query memory: 0.029 MB Memory before query: 8.272 MB Rows returned: 28

SELECT id, home, template, s.params

  FROM born_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	db672374894.e.element	3	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.09 ms
Waiting for query cache lock	0.01 ms
Sending data	0.22 ms
Waiting for query cache lock	0.00 ms
Sending data	0.36 ms
Waiting for query cache lock	0.01 ms
Sending data	0.89 ms
Waiting for query cache lock	0.01 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Sending data	0.70 ms
Waiting for query cache lock	0.01 ms
Sending data	0.34 ms
Waiting for query cache lock	0.00 ms
Sending data	0.29 ms
Waiting for query cache lock	0.00 ms
Sending data	0.39 ms
Waiting for query cache lock	0.00 ms
Sending data	0.45 ms
Waiting for query cache lock	0.00 ms
Sending data	0.30 ms
Waiting for query cache lock	0.00 ms
Sending data	0.27 ms
Waiting for query cache lock	0.00 ms
Sending data	0.29 ms
Waiting for query cache lock	0.01 ms
Sending data	0.59 ms
Waiting for query cache lock	0.00 ms
Sending data	0.29 ms
Waiting for query cache lock	0.00 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.31 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.74 ms After last query: 22.41 ms Query memory: 0.028 MB Memory before query: 8.966 MB Rows returned: 1

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

  FROM born_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.55 ms After last query: 0.47 ms Query memory: 0.022 MB Memory before query: 8.978 MB

UPDATE `born_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.06 ms
Updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.22 ms
query end	0.70 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.40 ms After last query: 10.51 ms Query memory: 0.014 MB Memory before query: 9.568 MB Rows returned: 1

SELECT a.rules

  FROM born_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.03 ms
Waiting for query cache lock	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
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.43 ms After last query: 1.00 ms Query memory: 0.015 MB Memory before query: 9.615 MB Rows returned: 2

SELECT b.rules

  FROM born_assets AS a

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

  WHERE (a.name = 'com_k2')

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

  ORDER BY b.lft

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
9	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
8	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.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.40 ms After last query: 19.82 ms Query memory: 0.019 MB Memory before query: 11.267 MB Rows returned: 16

SELECT id 
  FROM born_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_categories	ref	category,published,access,trash	category	2	const	16	Using where; Using index

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	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
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:261
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:36
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.78 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 11.286 MB Rows returned: 1

Duplicate queries: #39

SELECT * 
  FROM born_k2_items 
  WHERE id=131 
  AND language IN ('en-GB','*') 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:36
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:42
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.14 ms After last query: 1.47 ms Query memory: 0.028 MB Memory before query: 11.410 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `born_k2_categories`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.00 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:305
13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:74
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.52 ms After last query: 1.05 ms Query memory: 0.023 MB Memory before query: 11.482 MB Rows returned: 1

SELECT * 
  FROM born_k2_categories 
  WHERE id = '23'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	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.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.32 ms After last query: 3.10 ms Query memory: 0.023 MB Memory before query: 11.606 MB Rows returned: 8

SELECT id, name,  parent	
  FROM born_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*') 
  ORDER BY parent

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_categories	ref	category,published,access,trash,language	category	2	const	16	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	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
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1239
15	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:321
14	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
13	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:78
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.61 ms After last query: 5.08 ms Query memory: 0.023 MB Memory before query: 11.799 MB Rows returned: 1

SELECT * 
  FROM born_k2_categories 
  WHERE id = '20'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	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
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:96
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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: 1.00 ms Query memory: 0.021 MB Memory before query: 11.839 MB Rows returned: 0

SELECT tag.*
		
  FROM born_k2_tags AS tag
		JOIN born_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 131 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	db672374894.xref.tagID	1	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System 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.02 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.49 ms After last query: 2.72 ms Query memory: 0.020 MB Memory before query: 11.973 MB Rows returned: 1

SELECT extraFieldsGroup 
  FROM born_k2_categories 
  WHERE id=23

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1395
13	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:184
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.49 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 11.993 MB Rows returned: 1

SELECT * 
  FROM born_k2_extra_fields 
  WHERE `
  group` = 3 
  AND published=1 
  AND (id IN (5) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1399
13	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:184
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.57 ms After last query: 1.58 ms Query memory: 0.021 MB Memory before query: 12.015 MB Rows returned: 0

SELECT * 
  FROM born_k2_attachments 
  WHERE itemID=131

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_attachments	ref	itemID	itemID	4	const	1

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1642
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:190
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.55 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 12.035 MB Rows returned: 0

SELECT * 
  FROM born_k2_rating 
  WHERE itemID = 131

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
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:990
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:1046
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:196
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.60 ms After last query: 1.02 ms Query memory: 0.020 MB Memory before query: 12.101 MB Rows returned: 1

SELECT COUNT(*) 
  FROM born_k2_comments 
  WHERE itemID=131 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_comments	ref	itemID,published,latestComments	published	4	const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1688
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:274
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.62 ms After last query: 8.09 ms Query memory: 0.023 MB Memory before query: 12.496 MB Rows returned: 1

SELECT MAX(ordering)

  FROM `born_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	extension	extension	82	const	126	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.21 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
16	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
15	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/cms/plugin/helper.php:255
14	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
13	JPluginHelper::importPlugin()	JROOT/components/com_k2/models/item.php:536
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.53 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 12.518 MB Rows returned: 1

SELECT `ordering`

  FROM `born_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content' 
  AND `element` = 'perfect_everything_in_everyway'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
16	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
15	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/cms/plugin/helper.php:255
14	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
13	JPluginHelper::importPlugin()	JROOT/components/com_k2/models/item.php:536
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.12 ms After last query: 6.90 ms Query memory: 0.030 MB Memory before query: 12.969 MB Rows returned: 36

SHOW FULL COLUMNS 
  FROM `born_k2_items`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/joomla/table/table.php:305
13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:895
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:135
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.77 ms After last query: 0.64 ms Query memory: 0.017 MB Memory before query: 13.065 MB

UPDATE born_k2_items

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

  WHERE `id` = '131'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
Updating	0.08 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.16 ms
query end	2.92 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
13	JTable->hit()	JROOT/components/com_k2/models/item.php:896
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:135
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.72 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 13.083 MB Rows returned: 0

SELECT * 
  FROM born_k2_comments 
  WHERE itemID=131 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_comments	ref	itemID,published,latestComments	latestComments	4	const	1	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1666
12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:231
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.07 ms After last query: 2.21 ms Query memory: 0.027 MB Memory before query: 13.227 MB Rows returned: 1

SELECT * 
  FROM born_k2_items 
  WHERE id != 131 
  AND catid=23 
  AND ordering > 2 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2017-08-22 12:57:26' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-08-22 12:57:26' )  
  AND access IN(1,1) 
  AND trash=0 
  AND language IN ('en-GB','*') 
  ORDER BY ordering ASC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_items	range	PRIMARY,item,catid,ordering,language	ordering	4	NULL	94	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.04 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1792
12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:307
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.45 ms After last query: 1.29 ms Query memory: 0.027 MB Memory before query: 13.260 MB Rows returned: 1

SELECT * 
  FROM born_k2_items 
  WHERE id != 131 
  AND catid=23 
  AND ordering < 2 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2017-08-22 12:57:26' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-08-22 12:57:26' )  
  AND access IN(1,1) 
  AND trash=0 
  AND language IN ('en-GB','*') 
  ORDER BY ordering DESC 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_items	range	PRIMARY,item,catid,ordering,language	ordering	4	NULL	12	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1747
12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:348
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.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.57 ms After last query: 20.11 ms Query memory: 0.028 MB Memory before query: 13.934 MB Rows returned: 34

Duplicate queries: #49

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

  FROM born_modules AS m

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

  LEFT JOIN born_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 <= '2017-08-22 12:57:26') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-08-22 12:57:26') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1370 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	141	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db672374894.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db672374894.m.id	2	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.55 ms
Sending data	0.22 ms
Waiting for query cache lock	0.00 ms
Sending data	0.50 ms
Waiting for query cache lock	0.00 ms
Sending data	0.28 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430
16	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:373
15	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:89
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:656
12	T3Template->checkSpotlight()	JROOT/templates/rhythm/tpls/blocks/top.php:12
11	include JROOT/templates/rhythm/tpls/blocks/top.php	JROOT/plugins/system/t3/includes/core/template.php:195
10	T3Template->loadBlock()	JROOT/templates/rhythm/tpls/home-1.php:35
9	include JROOT/templates/rhythm/tpls/home-1.php	JROOT/plugins/system/t3/includes/core/template.php:219
8	T3Template->loadLayout()	JROOT/templates/rhythm/index.php:44
7	require JROOT/templates/rhythm/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: 1.08 ms After last query: 5.65 ms Query memory: 0.022 MB Memory before query: 14.076 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `born_extensions`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
System lock	0.01 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
12	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
11	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:30
10	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:305
9	JTable::getInstance()	JROOT/plugins/system/pagebuilder/pagebuilder.php:60
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.61 ms After last query: 0.33 ms Query memory: 0.019 MB Memory before query: 14.137 MB Rows returned: 2

Duplicate queries: #63

SELECT *

  FROM born_extensions

  WHERE `element` = 'jsnframework' 
  AND `type` = 'plugin' 
  AND `folder` = 'system'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	2	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
9	JTable->load()	JROOT/plugins/system/pagebuilder/pagebuilder.php:67
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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: 0.53 ms Query memory: 0.023 MB Memory before query: 14.148 MB Rows returned: 1

Duplicate queries: #18

SELECT * 
  FROM born_k2_items 
  WHERE id=131 
  AND language IN ('en-GB','*') 
  LIMIT 0, 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
10	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:36
9	K2ModelItem->getData()	JROOT/plugins/system/pagebuilder/pagebuilder.php:101
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.21 ms After last query: 1.30 ms Query memory: 0.027 MB Memory before query: 14.200 MB Rows returned: 719

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.00 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	1.80 ms
Sending data	0.50 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
9	JSNConfigHelper::get()	JROOT/plugins/system/pagebuilder/pagebuilder.php:122
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.56 ms After last query: 1.36 ms Query memory: 0.015 MB Memory before query: 14.350 MB Rows returned: 2

SELECT name,value

  FROM born_jsn_pagebuilder_config

  WHERE 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
9	JSNConfigHelper::get()	JROOT/plugins/system/pagebuilder/pagebuilder.php:122
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 14.90 ms Query memory: 0.024 MB Memory before query: 15.388 MB Rows returned: 1

Duplicate queries: #43 #44 #64

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_k2' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
18	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
17	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
16	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/helpers/helper.php:107
15	JSNPbArticleListHelper::getArticleListSource()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:397
14	JSNPBShortcodeArticleList->frontend_element_items()	JROOT/administrator/components/com_pagebuilder/libraries/innotheme/shortcode/element.php:35
13	IG_Pb_Element->__construct()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:33
12	JSNPBShortcodeArticleList->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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: 203.66 ms After last query: 0.50 ms Query memory: 0.027 MB Memory before query: 15.443 MB Rows returned: 1

Duplicate queries: #42 #44 #64

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_k2' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
20	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
19	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
18	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/models/k2categories.php:15
17	include_once JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/models/k2categories.php	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/helpers/helper.php:71
16	JSNPbArticleListHelper::loadK2Libraries()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/helpers/helper.php:108
15	JSNPbArticleListHelper::getArticleListSource()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:397
14	JSNPBShortcodeArticleList->frontend_element_items()	JROOT/administrator/components/com_pagebuilder/libraries/innotheme/shortcode/element.php:35
13	IG_Pb_Element->__construct()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:33
12	JSNPBShortcodeArticleList->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.53 ms After last query: 1.99 ms Query memory: 0.027 MB Memory before query: 15.686 MB Rows returned: 1

Duplicate queries: #42 #43 #64

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_k2' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
20	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
19	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
18	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/models/k2articles.php:15
17	include_once JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/models/k2articles.php	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/helpers/helper.php:72
16	JSNPbArticleListHelper::loadK2Libraries()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/helpers/helper.php:108
15	JSNPbArticleListHelper::getArticleListSource()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:397
14	JSNPBShortcodeArticleList->frontend_element_items()	JROOT/administrator/components/com_pagebuilder/libraries/innotheme/shortcode/element.php:35
13	IG_Pb_Element->__construct()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:33
12	JSNPBShortcodeArticleList->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.59 ms After last query: 2.76 ms Query memory: 0.024 MB Memory before query: 16.121 MB Rows returned: 1

Duplicate queries: #65

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_easyblog' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
18	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
17	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
16	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/helpers/helper.php:113
15	JSNPbArticleListHelper::getArticleListSource()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:397
14	JSNPBShortcodeArticleList->frontend_element_items()	JROOT/administrator/components/com_pagebuilder/libraries/innotheme/shortcode/element.php:35
13	IG_Pb_Element->__construct()	JROOT/plugins/jsnpagebuilder/defaultelements/articlelist/articlelist.php:33
12	JSNPBShortcodeArticleList->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.73 ms After last query: 7.97 ms Query memory: 0.021 MB Memory before query: 16.866 MB Rows returned: 1

Duplicate queries: #66

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_easyslider' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
14	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
13	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/easyslider/easyslider.php:31
12	JSNPBShortcodeEasyslider->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.42 ms After last query: 5.04 ms Query memory: 0.021 MB Memory before query: 17.347 MB Rows returned: 1

Duplicate queries: #67

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_imageshow' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
14	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
13	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/imageshow/imageshow.php:31
12	JSNPBShortcodeImageShow->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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.66 ms After last query: 27.09 ms Query memory: 0.021 MB Memory before query: 19.271 MB Rows returned: 1

Duplicate queries: #68

SELECT COUNT(extension_id)

  FROM born_extensions

  WHERE element = 'com_uniform' 
  AND type = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:104
14	JComponentHelper::isInstalled()	JROOT/administrator/components/com_pagebuilder/helpers/pagebuilder.php:139
13	JSNPagebuilderHelpersPagebuilder::checkComponentEnabled()	JROOT/plugins/jsnpagebuilder/defaultelements/uniform/uniform.php:32
12	JSNPBShortcodeUniform->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
11	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
10	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:353
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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: 2.21 ms After last query: 15.45 ms Query memory: 0.020 MB Memory before query: 19.867 MB Rows returned: 34

Duplicate queries: #36

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

  FROM born_modules AS m

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

  LEFT JOIN born_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 <= '2017-08-22 12:57:26') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-08-22 12:57:26') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1370 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	141	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db672374894.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db672374894.m.id	2	Using where; Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.80 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430
10	JModuleHelper::getModuleList()	JROOT/plugins/system/pagebuilder/pagebuilder.php:360
9	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:137
8	plgSystemPagebuilder->onBeforeRender()	Same as call in the line below.
7	call_user_func_array()	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:1058
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: 2.42 ms After last query: 22.40 ms Query memory: 0.028 MB Memory before query: 19.380 MB Rows returned: 4

SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM born_k2_items as i RIGHT JOIN born_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1)  
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-08-22 12:57:26' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-08-22 12:57:26' ) 
  AND i.catid IN(21,22,23,19) 
  AND c.language IN ('en-GB', '*') 
  AND i.language IN ('en-GB', '*') 
  ORDER BY i.created DESC 
  LIMIT 0, 4

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	item,catid,language	item	2	const	109	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash,language	PRIMARY	4	db672374894.i.catid	1	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.08 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.40 ms
Sending data	0.12 ms
Waiting for query cache lock	0.00 ms
Sending data	0.15 ms
Waiting for query cache lock	0.00 ms
Sending data	0.46 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:268
11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
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.89 ms After last query: 11.40 ms Query memory: 0.021 MB Memory before query: 19.503 MB Rows returned: 0

SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname
		
  FROM born_k2_comments as c
		
  LEFT JOIN born_k2_items as i 
  ON i.id=c.itemID
		
  LEFT JOIN born_k2_categories as category 
  ON category.id=i.catid
		
  WHERE i.published=1
		
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-08-22 12:57:26' )
		
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-08-22 12:57:26' )
		
  AND i.trash=0  
  AND i.access IN(1,1)  
  AND category.published=1 
  AND category.trash=0  
  AND category.access IN(1,1)  
  AND c.published=1  
  AND i.catid IN(21,22,23,19) 
  AND category.language IN ('en-GB', '*') 
  AND i.language IN ('en-GB', '*') 
  ORDER BY c.commentDate DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	itemID,published,latestComments	latestComments	4	const	1	Using where
1	SIMPLE	i	eq_ref	PRIMARY,item,catid,language	PRIMARY	4	db672374894.c.itemID	1	Using where
1	SIMPLE	category	eq_ref	PRIMARY,category,published,access,trash,language	PRIMARY	4	db672374894.i.catid	1	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_comments/helper.php:92
11	modK2CommentsHelper::getLatestComments()	JROOT/modules/mod_k2_comments/mod_k2_comments.php:57
10	include JROOT/modules/mod_k2_comments/mod_k2_comments.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
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: 1.11 ms After last query: 7.13 ms Query memory: 0.019 MB Memory before query: 19.901 MB Rows returned: 52

SELECT i.id 
  FROM born_k2_items as i 
  LEFT JOIN born_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published=1  
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-08-22 12:57:26' )  
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-08-22 12:57:26' ) 
  AND i.trash=0  
  AND i.access IN(1,1)  
  AND c.published=1  
  AND c.trash=0  
  AND c.access IN(1,1)  
  AND c.language IN ('en-GB', '*') 
  AND i.language IN ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,category,published,access,trash,language	category	2	const	16	Using where
1	SIMPLE	i	ref	item,catid,language	catid	4	db672374894.c.id	4	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
12	JDatabaseDriver->loadColumn()	JROOT/modules/mod_k2_tools/helper.php:320
11	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:103
10	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
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: 1.02 ms After last query: 0.17 ms Query memory: 0.036 MB Memory before query: 19.927 MB Rows returned: 786

SELECT tag.name, tag.id
        
  FROM born_k2_tags as tag
        
  LEFT JOIN born_k2_tags_xref AS xref 
  ON xref.tagID = tag.id 
        
  WHERE xref.itemID IN (102,141,157,161,164,170,176,134,135,136,174,181,128,129,153,177,180,130,131,132,133,142,150,151,154,159,183,185,187,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127) 
        
  AND tag.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ALL	tagID,itemID	NO INDEX KEY COULD BE USED	NULL	NULL	2287	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	db672374894.xref.tagID	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:333
11	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:103
10	include JROOT/modules/mod_k2_tools/mod_k2_tools.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
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.79 ms After last query: 24.40 ms Query memory: 0.020 MB Memory before query: 20.103 MB Rows returned: 0

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

  FROM `born_menu` AS `c`

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

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

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

  WHERE c.id = 1370

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
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
14	JDatabaseDriver->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_languages/helper.php:62
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:18
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
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.53 ms After last query: 18.47 ms Query memory: 0.030 MB Memory before query: 21.874 MB Rows returned: 2

SELECT b.rules

  FROM born_assets AS a

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

  WHERE (a.name = 'com_virtuemart')

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

  ORDER BY b.lft

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
22	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
20	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
19	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
18	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:806
17	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:779
16	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
15	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
14	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
11	JRouter->build()	JROOT/libraries/cms/router/site.php:134
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84
7	JDocumentRendererMegamenuRender->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: 1.79 ms After last query: 1.34 ms Query memory: 0.026 MB Memory before query: 22.063 MB Rows returned: 1

Born Magazine #3 cocktail launch

Leave a comment

Recent Posts

Barcelona Shopping Night

EVENT "CAFÉ-CROISSANT"

EVENT BORN MAGAZINE #5

Gleb Sollugub

Latest Comments

Tags

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

68 Queries Logged 482.87 ms

18 duplicate found!