Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1720307165,
                "last": 1720307165,
                "now": 1720307165
            },
            "client": {
                "forwarded": "18.224.45.180"
            },
            "token": "4V09SR2Qyu6U2OmVuHhlYiC4g6yEfYkh"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "jomsocial_userip": "18.224.45.180"
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Profile Information

Memory Usage

Database Queries

68 Queries Logged 57.63 ms

Query Time: 0.68 ms Query memory: 0.020 MB Memory before query: 4.088 MB Rows returned: 0

SELECT `session_id`

  FROM `joom_session`

  WHERE `session_id` = 'ng4teehjfdfsc43j7lvh0o250e' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
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:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

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

Query Time: 5.37 ms After last query: 0.04 ms Query memory: 0.003 MB Memory before query: 4.155 MB

INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('ng4teehjfdfsc43j7lvh0o250e', 1, '1720307165', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('ng4teehjfdfsc43j7lvh0o250e', 1, '1720307165', 0, '')

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	4.59 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
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:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

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

Query Time: 1.04 ms After last query: 1.80 ms Query memory: 0.045 MB Memory before query: 4.326 MB Rows returned: 80

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

  FROM `joom_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	80	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:598
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.36 ms After last query: 1.42 ms Query memory: 0.021 MB Memory before query: 4.537 MB Rows returned: 7

SELECT id, rules

  FROM `joom_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1062
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.33 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.549 MB Rows returned: 1

SELECT b.id

  FROM joom_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:979
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1094
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.68 ms After last query: 0.37 ms Query memory: 0.046 MB Memory before query: 4.611 MB Rows returned: 142

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM joom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	277	0.40	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.99 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.74 ms After last query: 8.81 ms Query memory: 0.024 MB Memory before query: 5.519 MB Rows returned: 1

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

  FROM `joom_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
16	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
15	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
13	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:761
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 5.97 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 5.511 MB

UPDATE `joom_extensions`

  SET `params` = '{\"mediaversion\":\"2524a5569432a6252ac119cbe23667ef\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	joom_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.09 ms
updating	0.09 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	5.29 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:761
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.45 ms After last query: 12.19 ms Query memory: 0.029 MB Memory before query: 8.004 MB Rows returned: 19

SELECT *

  FROM joom_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:99
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.34 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 8.071 MB Rows returned: 1

SELECT * 
  FROM axs_domains 
  WHERE domain = 'k8s.intg.tovuti.io'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
9	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:153
8	AxsLanguage::getSubdomainDefault()	JROOT/plugins/system/languagefilter/languagefilter.php:103
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.87 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 8.079 MB Rows returned: 94

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `joom_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	98	1.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:113
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[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.94 ms Query memory: 0.022 MB Memory before query: 8.211 MB Rows returned: 1

SELECT * 
  FROM `axs_brands` 
  WHERE language = 'en-GB' 
  AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_brands	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:290
11	AxsBrands::getData()	JROOT/libraries/axslibs/brands.php:355
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.33 ms After last query: 0.04 ms Query memory: 0.030 MB Memory before query: 8.232 MB Rows returned: 19

SELECT * 
  FROM joom_languages 
  WHERE published = 1 
  ORDER BY `title`

Explain

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

Profile

Status	Duration
starting	0.02 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
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/language.php:312
12	AxsLanguage::getPublishedLanguages()	JROOT/libraries/axslibs/language.php:221
11	AxsLanguage::getCurrentLanguage()	JROOT/libraries/axslibs/brands.php:371
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.33 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 8.257 MB Rows returned: 1

SELECT * 
  FROM `axs_homepage_templates` 
  WHERE id='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:388
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.32 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 8.298 MB Rows returned: 1

SELECT * 
  FROM `axs_dashboard_templates` 
  WHERE id='2'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:406
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.31 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 8.318 MB Rows returned: 1

SELECT *

  FROM axs_email_settings

  WHERE id = '1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:632
11	AxsBrands::getEmailSettingsById()	JROOT/libraries/axslibs/brands.php:409
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.32 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 8.327 MB Rows returned: 1

SELECT *

  FROM axs_payment_gateways

  WHERE id = '1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:582
11	AxsBrands::getPaymentGatewayById()	JROOT/libraries/axslibs/brands.php:412
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 8.339 MB Rows returned: 1

SELECT *

  FROM axs_integrations

  WHERE id = '1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:659
11	AxsBrands::getIntegrationById()	JROOT/libraries/axslibs/brands.php:418
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.76 ms After last query: 9.91 ms Query memory: 0.101 MB Memory before query: 9.843 MB Rows returned: 88

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

  LEFT JOIN joom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	128	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.93 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:500
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:277
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:605
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:134
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
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:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.95 ms After last query: 8.88 ms Query memory: 0.028 MB Memory before query: 11.427 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `joom_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
15	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
13	JUser::getTable()	JROOT/libraries/joomla/user/user.php:782
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.45 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 11.471 MB Rows returned: 1

SELECT `id`,`title`

  FROM `joom_usergroups`

  WHERE `id` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:152
13	JTableUser->bind()	JROOT/libraries/joomla/user/user.php:784
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.41 ms After last query: 9.96 ms Query memory: 0.019 MB Memory before query: 12.069 MB Rows returned: 0

SELECT params

  FROM axs_user_settings

  WHERE id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
6	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/user.php:666
5	AxsUser::getGlobalUserSettings()	JROOT/libraries/axslibs/security.php:33
4	AxsSecurity::getSettings()	JROOT/libraries/cms/application/cms.php:377
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.43 ms After last query: 2.10 ms Query memory: 0.019 MB Memory before query: 12.397 MB Rows returned: 0

SELECT *

  FROM `joom_users`

  WHERE `id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
5	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_users/models/user.php:992
4	UsersModelUser->getOtpConfig()	JROOT/libraries/cms/application/cms.php:381
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.36 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 12.410 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM joom_template_styles as s

  LEFT JOIN joom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	root_db.s.template,const	1	4.07	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.52 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:490
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.48 ms After last query: 4.44 ms Query memory: 0.022 MB Memory before query: 13.122 MB Rows returned: 0

SELECT *

  FROM joom_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:415
9	EB::config()	JROOT/administrator/components/com_easyblog/includes/utils.php:51
8	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3013
7	EB::ajax()	JROOT/components/com_easyblog/easyblog.php:21
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.63 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 13.171 MB Rows returned: 1

SELECT * 
  FROM joom_extensions 
  WHERE name='com_media'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	653	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.88 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/images.php:66
11	AxsImages::setSession()	JROOT/libraries/axslibs/images.php:15
10	AxsImages::getImagesPath()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:430
9	EB::config()	JROOT/administrator/components/com_easyblog/includes/utils.php:51
8	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3013
7	EB::ajax()	JROOT/components/com_easyblog/easyblog.php:21
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.75 ms After last query: 3.58 ms Query memory: 0.006 MB Memory before query: 13.428 MB

DELETE 
  FROM `joom_easyblog_mailq` 
  WHERE `status`='1' 
  AND DATEDIFF(NOW(), `created`) >='7'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	joom_easyblog_mailq	NULL	range	easyblog_mailq_status,idx_mailq_statuscreated	easyblog_mailq_status	1	const	1	100.00	Using where

Profile

Status	Duration
starting	1.11 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.08 ms
updating	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed send ok initiated	0.06 ms
delayed send ok done	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:39
10	EasyBlogModelMailer->cleanup()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:38
9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[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.02 ms Query memory: 0.022 MB Memory before query: 13.434 MB Rows returned: 0

SELECT `id` 
  FROM `joom_easyblog_mailq` 
  WHERE `status`='0' 
  ORDER BY `created` ASC 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_mailq	NULL	ref	easyblog_mailq_status,idx_mailq_statuscreated	idx_mailq_statuscreated	1	const	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:65
10	EasyBlogModelMailer->getPendingEmails()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:41
9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.92 ms After last query: 3.71 ms Query memory: 0.023 MB Memory before query: 14.472 MB Rows returned: 0

SELECT * 
  FROM `joom_easyblog_post` 
  WHERE `publish_up`<='2024-07-06 23:06:06' 
  AND `published`='2' 
  AND `state`='0' 
  ORDER BY `id` 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_post	NULL	ref	easyblog_frontpage1,easyblog_post_blogger_list,easyblog_post_published,idx_post_sql1,idx_pre_soucetype_postcount	easyblog_frontpage1	1	const	1	50.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:273
10	EasyBlogModelBlogs->getScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:60
9	EasyBlogScheduler->publish()	JROOT/components/com_easyblog/services/maintenance.php:22
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[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.08 ms Query memory: 0.022 MB Memory before query: 14.485 MB Rows returned: 0

SELECT id, created_by 
  FROM`joom_easyblog_post` 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2024-07-06 23:06:06' 
  AND `publish_down` != '0000-00-00 00:00:00' 
  AND `published` = '1' 
  AND `state` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_post	NULL	ref	easyblog_frontpage1,easyblog_post_blogger_list,easyblog_post_published,idx_post_sql1,idx_pre_soucetype_postcount	easyblog_frontpage1	1	const	2	50.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:316
10	EasyBlogModelBlogs->getUnpublishScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:34
9	EasyBlogScheduler->unpublish()	JROOT/components/com_easyblog/services/maintenance.php:25
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 2.51 ms After last query: 0.38 ms Query memory: 0.022 MB Memory before query: 14.523 MB Rows returned: 0

SELECT * 
  FROM `joom_easyblog_uploader_tmp` 
  WHERE `created` <= DATE_SUB('2024-07-06 23:06:06' , INTERVAL 120 MINUTE)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_uploader_tmp	NULL	range	idx_uploader_created	idx_uploader_created	5	NULL	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:97
9	EasyBlogScheduler->removeTmpFiles()	JROOT/components/com_easyblog/services/maintenance.php:28
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.89 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 14.529 MB

delete a, b 
  from `joom_easyblog_post` as a	
  inner join `joom_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2024-07-06 23:06:06', INTERVAL 3 DAY)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	a	NULL	ref	PRIMARY,easyblog_frontpage1,easyblog_post_blogger_list,easyblog_post_published,idx_post_sql1,idx_pre_soucetype_postcount	easyblog_frontpage1	1	const	1	50.00	Using where
1	DELETE	b	NULL	ref	idx_ordering,idx_postid,idx_revision_state	idx_postid	8	root_db.a.id	4	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
init	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
deleting from main table	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
deleting from reference tables	0.00 ms
end	0.00 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed send ok initiated	0.23 ms
delayed send ok done	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:134
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:32
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.38 ms After last query: 0.86 ms Query memory: 0.025 MB Memory before query: 14.614 MB Rows returned: 1

SELECT * 
  FROM `joom_menu` 
  WHERE `published`='1' 
  AND `link` LIKE 'index.php?option=com_easyblog%' 
  AND `menutype`='mainmenu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_menutype	idx_menutype	98	const	18	1.11	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:52
12	EasyBlogModelMenu->getAssociatedMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:80
11	EBR::getMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:347
10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4323
9	EB::_()	JROOT/components/com_easyblog/services/weblog.php:27
8	require_once JROOT/components/com_easyblog/services/weblog.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4275
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.34 ms After last query: 0.49 ms Query memory: 0.030 MB Memory before query: 14.729 MB Rows returned: 40

SELECT * 
  FROM `joom_easyblog_acl` 
  WHERE `published`='1' 
  ORDER BY `id` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_acl	NULL	index	idx_acl_published,idx_acl_published_id	PRIMARY	8	NULL	40	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:298
11	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:38
10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:141
9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
8	EasyBlogController->__construct()	JROOT/libraries/legacy/controller/legacy.php:301
7	JControllerLegacy::getInstance()	JROOT/components/com_easyblog/easyblog.php:40
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 14.760 MB Rows returned: 40

SELECT * 
  FROM `joom_easyblog_acl_group` 
  WHERE `content_id`='1' 
  AND `type`='
  group'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_acl_group	NULL	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	40	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:112
10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:141
9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
8	EasyBlogController->__construct()	JROOT/libraries/legacy/controller/legacy.php:301
7	JControllerLegacy::getInstance()	JROOT/components/com_easyblog/easyblog.php:40
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.42 ms After last query: 2.98 ms Query memory: 0.030 MB Memory before query: 14.976 MB Rows returned: 63

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

  FROM `joom_assets`

  WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	264	54.55	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:530
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1020
14	EB::isSiteAdmin()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:94
13	EasyBlogThemes->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4231
12	EB::template()	JROOT/components/com_easyblog/views/views.php:51
11	EasyBlogView->__construct()	JROOT/libraries/legacy/controller/legacy.php:597
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:843
9	JControllerLegacy->getView()	JROOT/components/com_easyblog/controllers/controller.php:72
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 2.14 ms After last query: 3.03 ms Query memory: 0.022 MB Memory before query: 15.533 MB Rows returned: 0

SELECT a.*, 1 as `featured` 
  FROM `joom_easyblog_post` AS a 
  INNER JOIN `joom_easyblog_featured` AS c 
  ON a.`id` = c.`content_id` 
  AND c.`type`='post' 
  WHERE a.`published`='1' 
  AND a.`state`='0' 
  AND( a.`language`='en-GB' OR a.`language`='' OR a.`language`='*' ) 
  AND a.`access`='0' 
  AND (1 <= (select count(1) 
  from `joom_easyblog_post_category` AS acp 
  INNER JOIN `joom_easyblog_category` as cat 
  on acp.`category_id` = cat.`id` 
  where acp.`post_id` = a.`id` 
  and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
  and (0 > 0) ) OR 	( (cat.`private` = 2) 
  and ( (select count(1) 
  from `joom_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (1)) > 0 ) ) ) )) 
  ORDER BY a.`created` DESC 
  LIMIT 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	index	easyblog_content,easyblog_featured_content_type	easyblog_featured_content_type	775	NULL	1	100.00	Using where; Using index; Using temporary; Using filesort
1	PRIMARY	a	NULL	eq_ref	PRIMARY,easyblog_frontpage1,easyblog_post_blogger_list,easyblog_post_published,easyblog_post_search,easyblog_post_searchnew,idx_post_sql1,idx_pre_soucetype_postcount	PRIMARY	8	root_db.c.content_id	1	50.00	Using where
2	DEPENDENT SUBQUERY	cat	NULL	index	PRIMARY,easyblog_cat_private	easyblog_cat_private	4	NULL	1	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	acp	NULL	ref	eb_post_category_cat_post,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_postid	eb_post_category_cat_post	8	root_db.cat.id,root_db.a.id	1	100.00	Using where; Using index
3	DEPENDENT SUBQUERY	cacl	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_category_content_type,easyblog_content_type	easyblog_category_acl	8	root_db.cat.id	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.63 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	0.21 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:249
10	EasyBlogModelBlog->getFeaturedBlog()	JROOT/components/com_easyblog/views/latest/view.html.php:75
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.48 ms After last query: 2.23 ms Query memory: 0.023 MB Memory before query: 15.801 MB Rows returned: 2

SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` 
  FROM `joom_easyblog_post` AS a 
  LEFT JOIN `joom_easyblog_featured` AS f 	
  ON a.`id` = f.`content_id` 
  AND f.`type` = 'post' 
  WHERE a.`published`='1' 
  AND a.`state`='0' 
  AND a.`access` = '0' 
  AND a.`frontpage` = '1' 
  AND (`a`.`language`='en-GB' OR `a`.`language`='' OR `a`.`language`='*') 
  AND (1 <= (select count(1) 
  from `joom_easyblog_post_category` AS acp 
  INNER JOIN `joom_easyblog_category` as cat 
  on acp.`category_id` = cat.`id` 
  where acp.`post_id` = a.`id` 
  and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
  and (0 > 0) ) OR 	( (cat.`private` = 2) 
  and ( (select count(1) 
  from `joom_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (1)) > 0 ) ) ) )) 
  AND ( (a.`source_type` = 'easyblog.sitewide')  OR ( a.`source_type` = 'easyblog.team' 
  and 1 <= (select count(1) 
  from `joom_easyblog_team` as srcteam 
  where srcteam.`id` = a.`source_id` 
  and srcteam.`published` = 1 
  and ( (srcteam.`access` = 3)       OR (srcteam.`access` = 2 
  and (select count(1) 
  from `joom_easyblog_team_groups` as srcteamgrp 
  where srcteamgrp.`team_id` = srcteam.`id` 
  and srcteamgrp.`group_id` IN (1) ) > 0))))) 
  ORDER BY  a.`created` desc 
  LIMIT 0,10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	easyblog_frontpage1,easyblog_post_blogger_list,easyblog_post_published,easyblog_post_search,easyblog_post_searchnew,idx_post_sql1,idx_pre_soucetype_postcount	easyblog_frontpage1	2	const,const	2	50.00	Using where
1	PRIMARY	f	NULL	ref	easyblog_content,easyblog_featured_content_type	easyblog_content	8	root_db.a.id	1	100.00	Using where
4	DEPENDENT SUBQUERY	srcteam	NULL	eq_ref	PRIMARY,idx_access,idx_published,idx_viewable_team	PRIMARY	4	root_db.a.source_id	1	100.00	Using where
5	DEPENDENT SUBQUERY	srcteamgrp	NULL	ref	group_id,idx_team_group,team_id	group_id	4	const	1	100.00	Using where
2	DEPENDENT SUBQUERY	cat	NULL	index	PRIMARY,easyblog_cat_private	easyblog_cat_private	4	NULL	1	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	acp	NULL	ref	eb_post_category_cat_post,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_postid	eb_post_category_cat_post	8	root_db.cat.id,root_db.a.id	1	100.00	Using where; Using index
3	DEPENDENT SUBQUERY	cacl	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_category_content_type,easyblog_content_type	easyblog_category_acl	8	root_db.cat.id	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.09 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.06 ms
executing	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.06 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:776
10	EasyBlogModelBlog->getBlogsBy()	JROOT/components/com_easyblog/views/latest/view.html.php:103
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.19 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 15.813 MB Rows returned: 1

select FOUND_ROWS()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	No tables used

Profile

Status	Duration
starting	0.01 ms
checking query cache for query	0.77 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.05 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:782
10	EasyBlogModelBlog->getBlogsBy()	JROOT/components/com_easyblog/views/latest/view.html.php:103
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.91 ms After last query: 4.66 ms Query memory: 0.023 MB Memory before query: 16.489 MB Rows returned: 0

SELECT COUNT(1) as `voted`, `uid` 
  FROM `joom_easyblog_ratings` 
  WHERE `uid` IN (3,2) 
  AND `type`='entry' 
  AND `created_by`='0' 
  AND (`sessionid` = 'ng4teehjfdfsc43j7lvh0o250e' OR `ip` = '10.7.51.39') 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_ratings	NULL	ref	created_by,idx_uid_type,idx_uid_type_user,idx_uid_type_user_ipaddr,idx_uid_type_user_session,post_id	created_by	4	const	1	100.00	Using index condition; Using where; Using temporary

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.06 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:133
12	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:337
11	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:261
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[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.03 ms Query memory: 0.023 MB Memory before query: 16.496 MB Rows returned: 0

SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
  FROM `joom_easyblog_ratings` AS a 
  WHERE a.`uid` IN(3,2) 
  AND `type`='entry' 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index	idx_uid_type,idx_uid_type_user,idx_uid_type_user_ipaddr,post_id	post_id	4	NULL	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:174
12	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:461
11	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:264
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[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.89 ms Query memory: 0.023 MB Memory before query: 16.646 MB Rows returned: 0

SELECT a.* 
  FROM `joom_easyblog_comment` AS a 
  WHERE a.`post_id` IN(3,2) 
  AND a.`published`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:574
12	EasyBlogModelComment->preloadComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:493
11	EasyBlogCache->cacheComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:267
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.37 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 16.653 MB Rows returned: 0

SELECT a.`post_id`, COUNT(1) AS `count` 
  FROM `joom_easyblog_comment` AS a 
  WHERE a.`post_id` IN(3,2) 
  AND a.`published`='1' 
  GROUP BY a.`post_id`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index	easyblog_comment_postid,idx_comment_post_items	idx_comment_post_items	13	NULL	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.02 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
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:618
12	EasyBlogModelComment->preloadCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:519
11	EasyBlogCache->cacheCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:270
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.41 ms After last query: 1.01 ms Query memory: 0.023 MB Memory before query: 16.818 MB Rows returned: 2

select a.*, b.`post_id`, b.`primary` 
  from `joom_easyblog_category` as a 
  inner join `joom_easyblog_post_category` as b 
  on a.`id` = b.`category_id` 
  where b.`post_id` IN ( 3,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	b	NULL	ALL	eb_post_category_cat_post,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_postid	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1380
12	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:600
11	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:273
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.58 ms After last query: 1.72 ms Query memory: 0.023 MB Memory before query: 17.729 MB Rows returned: 0

select a.*, b.`post_id` 
  from `joom_easyblog_tag` as a 
  inner join `joom_easyblog_post_tag` as b 
  on a.`id` = b.`tag_id` 
  where b.`post_id` IN ( 3,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	b	NULL	ref	easyblog_post_tag_post_id,easyblog_post_tag_tag_id,easyblog_post_tagpost_id	easyblog_post_tag_tag_id	8	root_db.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/tags.php:832
12	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:667
11	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:276
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.33 ms After last query: 0.48 ms Query memory: 0.023 MB Memory before query: 17.804 MB Rows returned: 2

select a.* 
  from `joom_easyblog_revisions` as a 
  where a.`id` IN ( 14,13)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	PRIMARY	PRIMARY	8	NULL	2	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/revisions.php:558
12	EasyBlogModelRevisions->preload()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:576
11	EasyBlogCache->cacheRevisions()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:279
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.45 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 17.888 MB Rows returned: 1

select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`,  e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` 
  from `joom_users` as u 
  left join `joom_easyblog_users` as e 
  ON u.`id` = e.`id` 
  where u.`id` = 1621309

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	e	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/users.php:300
15	EasyBlogModelUsers->getUsersMeta()	JROOT/administrator/components/com_easyblog/includes/user/user.php:193
14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:895
12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:648
11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:282
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.37 ms After last query: 0.55 ms Query memory: 0.026 MB Memory before query: 17.956 MB Rows returned: 1

SELECT *

  FROM `joom_users`

  WHERE `id` = 1621309

Explain

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

Profile

Status	Duration
starting	0.02 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
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:936
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:238
14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:895
12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:648
11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:282
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.51 ms After last query: 2.01 ms Query memory: 0.025 MB Memory before query: 18.709 MB Rows returned: 2

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

  FROM `joom_usergroups` AS g

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

  WHERE `m`.`user_id` = 1621309

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	user_id	4	const	2	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:936
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:238
14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:85
13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:895
12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:648
11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:282
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.44 ms After last query: 0.47 ms Query memory: 0.023 MB Memory before query: 18.769 MB Rows returned: 0

select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` 
  from `joom_easyblog_category_fields_groups` as a 
  inner join `joom_easyblog_post_category` as p 
  on `a`.`category_id` = `p`.`category_id`	
  inner join `joom_easyblog_fields_groups` as fg 
  on `a`.`group_id` = `fg`.`id`	
  inner join `joom_easyblog_fields` as f 
  on `fg`.`id` = `f`.`group_id`	
  left join `joom_easyblog_fields_values` as fv 
  on `fv`.`field_id` = `f`.`id` 
  and `fv`.`post_id` = `p`.`post_id` 
  where p.post_id IN (3,2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index	cat_id,category_id	category_id	8	NULL	1	100.00	Using index
1	SIMPLE	fg	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.group_id	1	100.00	NULL
1	SIMPLE	f	NULL	ref	group_id	group_id	4	root_db.a.group_id	1	100.00	NULL
1	SIMPLE	p	NULL	ref	eb_post_category_cat_post,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_postid	eb_post_category_cat_post	4	root_db.a.category_id	2	100.00	Using where; Using index
1	SIMPLE	fv	NULL	ALL	field_id,post_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.04 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 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
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/fields.php:298
12	EasyBlogModelFields->preloadFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:374
11	EasyBlogCache->cacheFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:285
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.37 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 18.822 MB Rows returned: 2

select * 
  from `joom_easyblog_meta` 
  where `content_id` in (3,2) 
  and `type` = 'post'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_meta	NULL	ALL	idx_meta_content_type	NO INDEX KEY COULD BE USED	NULL	NULL	5	40.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/metas.php:386
12	EasyBlogModelMetas->preloadPostMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:303
11	EasyBlogCache->cacheMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:288
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/latest/view.html.php:111
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.43 ms After last query: 2.02 ms Query memory: 0.024 MB Memory before query: 19.165 MB Rows returned: 0

SELECT `group_id` 
  FROM `joom_easyblog_category_fields_groups` 
  WHERE `category_id`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_category_fields_groups	NULL	ref	cat_id,category_id	cat_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/categories.php:53
15	EasyBlogModelCategories->getCustomFieldGroup()	JROOT/administrator/components/com_easyblog/tables/category.php:1013
14	EasyBlogTableCategory->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/post/post.php:5247
13	EasyBlogPost->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:71
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4308
10	EB::formatter()	JROOT/components/com_easyblog/views/latest/view.html.php:123
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.63 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 19.188 MB Rows returned: 0

SELECT a.* 
  FROM `joom_easyblog_fields` AS a 
  INNER JOIN `joom_easyblog_category_fields_groups` AS b 
  ON a.`group_id`= b.`group_id` 
  WHERE b.`category_id`='1' 
  AND a.`state`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	group_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	b	NULL	ref	cat_id,category_id	cat_id	4	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/categories.php:81
15	EasyBlogModelCategories->getCustomFields()	JROOT/administrator/components/com_easyblog/tables/category.php:1014
14	EasyBlogTableCategory->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/post/post.php:5247
13	EasyBlogPost->getCustomFields()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:71
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:51
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4308
10	EB::formatter()	JROOT/components/com_easyblog/views/latest/view.html.php:123
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.38 ms After last query: 0.56 ms Query memory: 0.022 MB Memory before query: 19.230 MB Rows returned: 0

SELECT *

  FROM joom_easyblog_meta

  WHERE `type` = 'view' 
  AND `content_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_meta	NULL	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 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
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
11	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2258
10	EB::setMeta()	JROOT/components/com_easyblog/views/latest/view.html.php:138
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.48 ms After last query: 7.67 ms Query memory: 0.024 MB Memory before query: 20.186 MB Rows returned: 1

SELECT `template` 
  FROM `joom_template_styles` 
  WHERE `home`='1' 
  AND `client_id`='0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_template_styles	NULL	ref	idx_home	idx_home	28	const	2	11.11	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/themes.php:46
14	EasyBlogModelThemes->getDefaultJoomlaTemplate()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2493
13	EB::getCurrentTemplate()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:222
12	EasyBlogThemes->resolve()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:429
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:164
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/latest/view.html.php:148
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 1.92 ms After last query: 2.62 ms Query memory: 0.028 MB Memory before query: 20.320 MB Rows returned: 21

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

  FROM joom_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-06 23:06:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-06 23:06:06') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 868 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,idx_language,newsfeeds,published	published	5	NULL	58	1.56	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	root_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	root_db.m.id	3	40.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.90 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
17	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
16	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
15	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
14	JModuleHelper::getModules()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2124
13	EB::renderModule()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php:18
12	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:164
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/latest/view.html.php:148
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.57 ms After last query: 11.73 ms Query memory: 0.028 MB Memory before query: 21.220 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM joom_fields AS a

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

  LEFT JOIN joom_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN joom_viewlevels AS ag 
  ON ag.id = a.access

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

  LEFT JOIN joom_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `joom_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'easyblog.blog' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_context,idx_state	idx_context	766	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	root_db.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	root_db.a.id	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
24	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
23	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:189
22	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/administrator/components/com_easyblog/includes/triggers/triggers.php:43
17	EasyBlogTriggers->trigger()	JROOT/administrator/components/com_easyblog/includes/post/post.php:3971
16	EasyBlogPost->prepareContent()	JROOT/administrator/components/com_easyblog/includes/post/post.php:3656
15	EasyBlogPost->getIntro()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:157
14	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
13	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php:25
12	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:164
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/latest/view.html.php:148
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.53 ms After last query: 7.06 ms Query memory: 0.027 MB Memory before query: 21.503 MB Rows returned: 0

SELECT a.* 
  FROM `joom_easyblog_comment` a 
  INNER JOIN joom_users AS c 
  ON a.`created_by` = c.`id` 
  WHERE a.`post_id` = '3' 
  AND a.`published` = 1 
  ORDER BY a.`lft` asc 
  LIMIT 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	easyblog_comment_postid,idx_comment_createdby,idx_comment_post_items	easyblog_comment_postid	8	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.created_by	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
20	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:155
19	EasyBlogModelBlog->getBlogComment()	JROOT/administrator/components/com_easyblog/includes/comment/comment.php:306
18	EasyBlogComment->getPreviewBlogComment()	JROOT/administrator/components/com_easyblog/includes/post/post.php:3424
17	EasyBlogPost->getPreviewComments()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php:14
16	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
15	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:196
14	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
13	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php:25
12	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:164
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/latest/view.html.php:148
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.44 ms After last query: 2.84 ms Query memory: 0.027 MB Memory before query: 21.518 MB Rows returned: 0

SELECT a.* 
  FROM `joom_easyblog_comment` a 
  INNER JOIN joom_users AS c 
  ON a.`created_by` = c.`id` 
  WHERE a.`post_id` = '2' 
  AND a.`published` = 1 
  ORDER BY a.`lft` asc 
  LIMIT 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	easyblog_comment_postid,idx_comment_createdby,idx_comment_post_items	easyblog_comment_postid	8	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.a.created_by	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
20	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:155
19	EasyBlogModelBlog->getBlogComment()	JROOT/administrator/components/com_easyblog/includes/comment/comment.php:306
18	EasyBlogComment->getPreviewBlogComment()	JROOT/administrator/components/com_easyblog/includes/post/post.php:3424
17	EasyBlogPost->getPreviewComments()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php:14
16	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/part.comments.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
15	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php:196
14	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.main.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
13	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php:25
12	include JROOT/components/com_easyblog/themes/wireframe/blogs/latest/default.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:445
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:164
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/latest/view.html.php:148
9	EasyBlogViewLatest->display()	JROOT/components/com_easyblog/controllers/controller.php:108
8	EasyBlogController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_easyblog/easyblog.php:43
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.49 ms After last query: 10.86 ms Query memory: 0.021 MB Memory before query: 21.844 MB Rows returned: 1

SELECT language,id

  FROM `joom_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	104	1.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:729
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[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.50 ms Query memory: 0.021 MB Memory before query: 21.896 MB Rows returned: 0

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

  FROM `joom_menu` AS `c`

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

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

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

  WHERE c.id = 868

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:313
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:746
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.43 ms After last query: 3.64 ms Query memory: 0.022 MB Memory before query: 22.236 MB Rows returned: 1

SELECT *

  FROM `currency`

  WHERE `base_currency`=1 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	currency	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	136	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/currency.php:84
10	AxsCurrency->getBaseCurrency()	JROOT/libraries/axslibs/currency.php:22
9	AxsCurrency->__construct()	JROOT/templates/axs/home.php:20
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.34 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 22.243 MB Rows returned: 10

SELECT * 
  FROM axs_fonts 
  WHERE enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_fonts	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/fonts.php:34
9	AxsFonts::getFonts()	JROOT/templates/axs/home.php:93
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.57 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 22.279 MB Rows returned: 0

SELECT *

  FROM accessibility_images

  WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' 
  AND enabled= 1

Explain

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

Profile

Status	Duration
starting	0.02 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
cleaned up	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/accessibility.php:42
10	AxsAccessibility::query()	JROOT/libraries/axslibs/accessibility.php:49
9	AxsAccessibility::image()	JROOT/templates/axs/home.php:806
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.70 ms After last query: 0.83 ms Query memory: 0.027 MB Memory before query: 22.340 MB Rows returned: 0

SELECT * 
  FROM axs_notifications  
  WHERE enabled = 1  
  AND   DATE(start_date) <= NOW()  
  AND   ( DATE(end_date) > NOW() OR end_date = 0 )  
  AND (  ( access_type = 'access' 
  AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
  AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
  AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' ) )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/notifications.php:17
9	AxsNotifications::loadNotifications()	JROOT/templates/axs/home.php:1795
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.37 ms After last query: 0.43 ms Query memory: 0.023 MB Memory before query: 22.242 MB Rows returned: 1

SELECT sef 
  FROM joom_languages 
  WHERE lang_code = 'en-GB' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
13	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:255
12	AxsLanguage::getSefByLangCode()	JROOT/modules/mod_mediamodal/tmpl/default.php:8
11	require JROOT/modules/mod_mediamodal/tmpl/default.php	JROOT/modules/mod_mediamodal/mod_mediamodal.php:9
10	include JROOT/modules/mod_mediamodal/mod_mediamodal.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.42 ms After last query: 3.32 ms Query memory: 0.028 MB Memory before query: 22.617 MB Rows returned: 1

SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1306
26	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1239
25	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
24	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
23	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
22	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:716
21	JLoader::_load()	JROOT/libraries/loader.php:671
20	JLoader::_autoload()	Same as call in the line below.
19	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
18	KunenaBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_defaultmenu/helper.php:134
11	ModDefaultHelper::getList()	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
10	include JROOT/modules/mod_defaultmenu/mod_defaultmenu.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

Query Time: 0.43 ms After last query: 2.41 ms Query memory: 0.024 MB Memory before query: 22.828 MB Rows returned: 1

SELECT special_characters 
  FROM joom_languages 
  WHERE sef = 'en' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_sef	idx_sef	202	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
15	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:278
14	AxsLanguage::getSpecialCharacters()	JROOT/libraries/axslibs/language.php:26
13	AxsLanguage::translate()	JROOT/modules/mod_defaultmenu/tmpl/default_component.php:21
12	require JROOT/modules/mod_defaultmenu/tmpl/default_component.php	JROOT/modules/mod_defaultmenu/tmpl/default.php:72
11	require JROOT/modules/mod_defaultmenu/tmpl/default.php	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:25
10	include JROOT/modules/mod_defaultmenu/mod_defaultmenu.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

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

64 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `joom_extensions`

```
2 × SELECT * 
  FROM `joom_users`
```
```
2 × SELECT * 
  FROM joom_languages
```

2 × SELECT a.* 
  FROM `joom_easyblog_comment` a 
  INNER JOIN joom_users AS c 
  ON a.`created_by` = c.`id`

1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
  FROM `joom_easyblog_ratings` AS a

1 × SELECT a.* 
  FROM `joom_easyblog_comment` AS a

1 × SELECT a.`post_id`, COUNT(1) AS `count` 
  FROM `joom_easyblog_comment` AS a

1 × select a.*, b.`post_id`, b.`primary` 
  from `joom_easyblog_category` as a 
  inner join `joom_easyblog_post_category` as b 
  on a.`id` = b.`category_id`

1 × select a.*, b.`post_id` 
  from `joom_easyblog_tag` as a 
  inner join `joom_easyblog_post_tag` as b 
  on a.`id` = b.`tag_id`

1 × select a.* 
  from `joom_easyblog_revisions` as a

1 × select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`,  e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` 
  from `joom_users` as u 
  left join `joom_easyblog_users` as e 
  ON u.`id` = e.`id`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `joom_usergroups` AS g 
  INNER JOIN `joom_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` 
  from `joom_easyblog_category_fields_groups` as a 
  inner join `joom_easyblog_post_category` as p 
  on `a`.`category_id` = `p`.`category_id` 
  inner join `joom_easyblog_fields_groups` as fg 
  on `a`.`group_id` = `fg`.`id` 
  inner join `joom_easyblog_fields` as f 
  on `fg`.`id` = `f`.`group_id` 
  left join `joom_easyblog_fields_values` as fv 
  on `fv`.`field_id` = `f`.`id` 
  and `fv`.`post_id` = `p`.`post_id`

1 × select * 
  from `joom_easyblog_meta`

1 × SELECT `group_id` 
  FROM `joom_easyblog_category_fields_groups`

1 × SELECT `session_id` 
  FROM `joom_session`

1 × SELECT a.* 
  FROM `joom_easyblog_fields` AS a 
  INNER JOIN `joom_easyblog_category_fields_groups` AS b 
  ON a.`group_id`= b.`group_id`

1 × SELECT COUNT(1) as `voted`, `uid` 
  FROM `joom_easyblog_ratings`

1 × SELECT `template` 
  FROM `joom_template_styles`

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

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM joom_fields AS a 
  LEFT JOIN `joom_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN joom_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN joom_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN joom_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN joom_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `joom_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT language,id 
  FROM `joom_menu`

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

```
1 × SELECT * 
  FROM `currency`
```
```
1 × SELECT * 
  FROM axs_fonts
```

1 × SELECT * 
  FROM accessibility_images

1 × SELECT * 
  FROM axs_notifications

```
1 × SELECT sef 
  FROM joom_languages
```

1 × SELECT * 
  FROM joom_kunena_configuration

1 × SELECT * 
  FROM joom_easyblog_meta

1 × SELECT a.*, 1 as `featured` 
  FROM `joom_easyblog_post` AS a 
  INNER JOIN `joom_easyblog_featured` AS c 
  ON a.`id` = c.`content_id` 
  AND c.`type`='post'

```
1 × select FOUND_ROWS(
```

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

1 × SELECT id, rules 
  FROM `joom_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM joom_extensions

```
1 × SELECT * 
  FROM axs_domains
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `joom_extensions`

```
1 × SELECT * 
  FROM `axs_brands`
```

1 × SELECT * 
  FROM `axs_homepage_templates`

1 × SELECT * 
  FROM `axs_dashboard_templates`

1 × SELECT * 
  FROM axs_email_settings

1 × SELECT * 
  FROM axs_payment_gateways

```
1 × SELECT * 
  FROM axs_integrations
```

1 × SELECT `id`,`title` 
  FROM `joom_usergroups`

1 × SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` 
  FROM `joom_easyblog_post` AS a 
  LEFT JOIN `joom_easyblog_featured` AS f  
  ON a.`id` = f.`content_id` 
  AND f.`type` = 'post'

1 × SELECT params 
  FROM axs_user_settings

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

1 × SELECT * 
  FROM joom_easyblog_configs

```
1 × SELECT * 
  FROM joom_extensions
```

1 × SELECT `id` 
  FROM `joom_easyblog_mailq`

1 × SELECT * 
  FROM `joom_easyblog_post`

1 × SELECT id, created_by 
  FROM`joom_easyblog_post`

1 × SELECT * 
  FROM `joom_easyblog_uploader_tmp`

```
1 × SELECT * 
  FROM `joom_menu`
```

1 × SELECT * 
  FROM `joom_easyblog_acl`

1 × SELECT * 
  FROM `joom_easyblog_acl_group`

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

1 × SELECT special_characters 
  FROM joom_languages

OTHER Tables:

1 × INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('ng4teehjfdfsc43j7lvh0o250e', 1, '1720307165', 0, ''

1 × UPDATE `joom_extensions` 
  SET `params` = '{\"mediaversion\":\"2524a5569432a6252ac119cbe23667ef\"}'

1 × SHOW FULL COLUMNS 
  FROM `joom_users

1 × DELETE 
  FROM `joom_easyblog_mailq`

1 × delete a, b 
  from `joom_easyblog_post` as a 
  inner join `joom_easyblog_revisions` as b 
  on a.`id` = b.`post_id`

EasyBlog

stage test

test

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

68 Queries Logged 57.63 ms

64 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: