Inspire other peoples dreams by starting your dream.

E.V.E

A group of people collaborating on projects related to their own passion for fashion, with different points of view, wishing to share it with our readers.

The concept, the main idea, is to produce a publication with its own voice and originality. Exchanging feelings, seeing design and creativity as way of living. We extend our most heartfelt thanks to all these experts.

Hi to all!

from Barcelona, Spain

Xabier Jiménez Photographer

Hi to all!

from Barcelona, Spain

Roman Yñan Photographer

Hi to all!

from Barcelona, Spain

María Jose Cayuela Blogger

Hi to all!

from Barcelona, Spain

Fabienne Yot Gallery owner

Hi to all!

from Barcelona, Spain

Helena Casanovas Blogger

Hi to all!

from Barcelona, Spain

Vivianne Oz Blogger

Hi to all!

from Barcelona, Spain

Emmanuel Razavi Reporter

Hi to all!

from Barcelona, Spain

Christina Kapongo Stylist

Hi to all!

from Barcelona, Spain

Sophie DLR Illustrator

Hi to all!

from Barcelona, Spain

Meritxell Moreno Journalist

Hi to all!

from Barcelona, Spain

Txell Hernández Blogger

Hi to all!

from Barcelona, Spain

Paul Hyde Photographer

Hi to all!

from Barcelona, Spain

Luciano Insua Photographer

Hi to all!

from Barcelona, Spain

Bernard Tartinville Photographer

Hi to all!

from Barcelona, Spain

Juliette Poney Illustrator

Hi to all!

from Barcelona, Spain

Laia Ferrer Journalist

Joomla! Debug Console

Session

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

Profile Information

Memory Usage

Database Queries

118 Queries Logged 67.46 ms

32 duplicate found!

16 duplicates: #29 #34 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86 #90

2 duplicates: #91 #103

2 duplicates: #93 #113

4 duplicates: #96 #97 #98 #114

2 duplicates: #99 #115

2 duplicates: #100 #116

2 duplicates: #101 #117

2 duplicates: #102 #118

Query Time: 0.62 ms Query memory: 0.018 MB Memory before query: 2.692 MB Rows returned: 0

SELECT `data`

  FROM `born_session`

  WHERE `session_id` = '54cde2d191bc8023957d47721cd1f04b'

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.64 ms After last query: 2.33 ms Query memory: 0.012 MB Memory before query: 2.895 MB Rows returned: 0

SELECT `session_id`

  FROM `born_session`

  WHERE `session_id` = '54cde2d191bc8023957d47721cd1f04b' 
  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

No SHOW PROFILE (maybe because there are more than 100 queries)

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: 0.96 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 2.907 MB

INSERT INTO `born_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('54cde2d191bc8023957d47721cd1f04b', 0, '1550316756')

Explain

EXPLAIN not possible on query: INSERT INTO `born_session` (`session_id`, `client_id`, `time`) VALUES ('54cde2d191bc8023957d47721cd1f04b', 0, '1550316756')

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

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: 0.88 ms After last query: 3.95 ms Query memory: 0.024 MB Memory before query: 3.279 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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: 0.22 ms After last query: 1.60 ms Query memory: 0.014 MB Memory before query: 3.451 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.23 ms After last query: 0.62 ms Query memory: 0.013 MB Memory before query: 3.507 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.29 ms After last query: 0.21 ms Query memory: 0.014 MB Memory before query: 3.526 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.26 ms After last query: 2.44 ms Query memory: 0.016 MB Memory before query: 3.792 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.73 ms After last query: 0.46 ms Query memory: 0.013 MB Memory before query: 3.830 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.65 ms After last query: 18.76 ms Query memory: 0.013 MB Memory before query: 5.637 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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: 3.28 ms After last query: 7.44 ms Query memory: 0.048 MB Memory before query: 6.326 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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: 3.52 ms After last query: 16.64 ms Query memory: 0.029 MB Memory before query: 8.265 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.47 ms After last query: 11.32 ms Query memory: 0.024 MB Memory before query: 8.694 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

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
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.53 ms After last query: 0.29 ms Query memory: 0.018 MB Memory before query: 8.702 MB

UPDATE `born_extensions`

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

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
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.25 ms After last query: 13.90 ms Query memory: 0.024 MB Memory before query: 10.067 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

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.27 ms After last query: 0.73 ms Query memory: 0.025 MB Memory before query: 10.124 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_sppagebuilder')

  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	387

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.73 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 10.155 MB Rows returned: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM born_sppagebuilder as a

  LEFT JOIN `born_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN born_users AS ua 
  ON ua.id = a.created_user_id

  WHERE a.id = 83 
  AND a.published = 1 
  AND a.language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	1
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 5.46 ms Query memory: 0.027 MB Memory before query: 10.582 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM born_modules AS m

  WHERE m.published = 1 
  AND m.id = 328 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-16 11:32:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-16 11:32:36') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
20	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/addons/module/site.php:59
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.20 ms After last query: 6.04 ms Query memory: 0.043 MB Memory before query: 11.071 MB Rows returned: 16

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 <= '2019-02-16 11:32:36' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-16 11:32:36' ) 
  AND i.catid IN(27) 
  AND c.language IN ('en-GB', '*') 
  AND i.language IN ('en-GB', '*') 
  ORDER BY i.created DESC 
  LIMIT 0, 30

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:268
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.31 ms After last query: 7.70 ms Query memory: 0.034 MB Memory before query: 12.100 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.01 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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
26	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1239
25	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:321
24	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:41
23	K2HelperRoute::getItemRoute()	JROOT/modules/mod_k2_content/helper.php:351
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.68 ms Query memory: 0.031 MB Memory before query: 12.129 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 = 112 
  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.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
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.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.13 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.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
23	K2ModelItem->getItemTags()	JROOT/modules/mod_k2_content/helper.php:356
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.36 ms After last query: 0.80 ms Query memory: 0.031 MB Memory before query: 12.161 MB Rows returned: 1

SELECT COUNT(*) 
  FROM born_k2_comments 
  WHERE itemID=112 
  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	itemID	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
Sending data	0.01 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.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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
24	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1688
23	K2ModelItem->countItemComments()	JROOT/modules/mod_k2_content/helper.php:376
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.50 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 12.191 MB Rows returned: 0

SELECT * 
  FROM born_k2_attachments 
  WHERE itemID=112

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.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 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.00 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.02 ms
logging slow query	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1642
23	K2ModelItem->getItemAttachments()	JROOT/modules/mod_k2_content/helper.php:380
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.59 ms After last query: 5.34 ms Query memory: 0.034 MB Memory before query: 12.629 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.02 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.23 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.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
26	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
25	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/cms/plugin/helper.php:255
24	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
23	JPluginHelper::importPlugin()	JROOT/modules/mod_k2_content/helper.php:386
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.17 ms Query memory: 0.033 MB Memory before query: 12.662 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.01 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.05 ms
init	0.02 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.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
26	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
25	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/cms/plugin/helper.php:255
24	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
23	JPluginHelper::importPlugin()	JROOT/modules/mod_k2_content/helper.php:386
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.06 ms After last query: 4.60 ms Query memory: 0.045 MB Memory before query: 13.135 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `born_users`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.45 ms
System lock	0.00 ms
init	0.00 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.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.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.08 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
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
31	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
30	JTable->__construct()	JROOT/libraries/joomla/table/user.php:38
29	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:305
28	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:582
27	JUser::getTable()	JROOT/libraries/joomla/user/user.php:866
26	JUser->load()	JROOT/libraries/joomla/user/user.php:242
25	JUser->__construct()	JROOT/libraries/joomla/user/user.php:295
24	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
23	JFactory::getUser()	JROOT/modules/mod_k2_content/helper.php:534
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.84 ms Query memory: 0.039 MB Memory before query: 13.236 MB Rows returned: 1

SELECT *

  FROM `born_users`

  WHERE `id` = 977

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_users	const	PRIMARY	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.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.00 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.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.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:84
27	JTableUser->load()	JROOT/libraries/joomla/user/user.php:869
26	JUser->load()	JROOT/libraries/joomla/user/user.php:242
25	JUser->__construct()	JROOT/libraries/joomla/user/user.php:295
24	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
23	JFactory::getUser()	JROOT/modules/mod_k2_content/helper.php:534
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.54 ms After last query: 4.68 ms Query memory: 0.036 MB Memory before query: 14.184 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `born_usergroups` AS g

  INNER JOIN `born_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 977

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db672374894.m.group_id	1

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 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.09 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
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:109
27	JTableUser->load()	JROOT/libraries/joomla/user/user.php:869
26	JUser->load()	JROOT/libraries/joomla/user/user.php:242
25	JUser->__construct()	JROOT/libraries/joomla/user/user.php:295
24	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
23	JFactory::getUser()	JROOT/modules/mod_k2_content/helper.php:534
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.26 ms Query memory: 0.030 MB Memory before query: 14.212 MB Rows returned: 1

Duplicate queries: #34 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86 #90

SELECT `description`, `gender` 
  FROM born_k2_users 
  WHERE userID=977 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_users	ref	userID	userID	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.00 ms
Opening tables	0.07 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 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.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.02 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
23	JDatabaseDriver->loadObject()	JROOT/modules/mod_k2_content/helper.php:539
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.47 ms After last query: 0.30 ms Query memory: 0.033 MB Memory before query: 14.244 MB Rows returned: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM born_k2_users 
  WHERE userID=977

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_users	ref	userID	userID	4	const	1

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.00 ms
statistics	0.01 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.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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
25	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1811
24	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:65
23	K2HelperUtilities::getAvatar()	JROOT/modules/mod_k2_content/helper.php:553
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 2.99 ms Query memory: 0.031 MB Memory before query: 14.421 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 = 113 
  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.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.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.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.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
23	K2ModelItem->getItemTags()	JROOT/modules/mod_k2_content/helper.php:356
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.19 ms Query memory: 0.031 MB Memory before query: 14.451 MB Rows returned: 1

SELECT COUNT(*) 
  FROM born_k2_comments 
  WHERE itemID=113 
  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	itemID	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.04 ms
checking permissions	0.01 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.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 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.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
24	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1688
23	K2ModelItem->countItemComments()	JROOT/modules/mod_k2_content/helper.php:376
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.35 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 14.482 MB Rows returned: 0

SELECT * 
  FROM born_k2_attachments 
  WHERE itemID=113

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.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 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.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.02 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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1642
23	K2ModelItem->getItemAttachments()	JROOT/modules/mod_k2_content/helper.php:380
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.24 ms After last query: 0.56 ms Query memory: 0.030 MB Memory before query: 14.515 MB Rows returned: 1

Duplicate queries: #29 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86 #90

SELECT `description`, `gender` 
  FROM born_k2_users 
  WHERE userID=977 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	born_k2_users	ref	userID	userID	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.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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
23	JDatabaseDriver->loadObject()	JROOT/modules/mod_k2_content/helper.php:539
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.45 ms After last query: 1.26 ms Query memory: 0.031 MB Memory before query: 14.549 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 = 114 
  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.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.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.05 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.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.02 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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
23	K2ModelItem->getItemTags()	JROOT/modules/mod_k2_content/helper.php:356
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.20 ms Query memory: 0.031 MB Memory before query: 14.579 MB Rows returned: 1

SELECT COUNT(*) 
  FROM born_k2_comments 
  WHERE itemID=114 
  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	itemID	4	const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.02 ms
checking permissions	0.01 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.01 ms
Sending data	0.01 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.01 ms
Waiting for query cache lock	0.01 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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
24	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1688
23	K2ModelItem->countItemComments()	JROOT/modules/mod_k2_content/helper.php:376
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.39 ms After last query: 0.14 ms Query memory: 0.032 MB Memory before query: 14.609 MB Rows returned: 0

SELECT * 
  FROM born_k2_attachments 
  WHERE itemID=114

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1642
23	K2ModelItem->getItemAttachments()	JROOT/modules/mod_k2_content/helper.php:380
22	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
21	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:85
19	sp_module_addon()	Same as call in the line below.
18	call_user_func()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:85
17	AddonParser::doAddonTag()	Same as call in the line below.
16	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:385
14	AddonParser::viewAddons()	JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php:50
13	include JROOT/templates/rhythm/html/com_sppagebuilder/page/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:60
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.24 ms After last query: 0.51 ms Query memory: 0.030 MB Memory before query: 14.642 MB Rows returned: 1