entrepreneurs - Benetrends Financial Blog

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1715347951,
                "last": 1715347951,
                "now": 1715347951
            },
            "token": "3IOT0IPditopzrXWK1EiGxl0EfZ9Y1AW"
        },
        "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
        }
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Profile Information

Time

Memory

Time: 25.47 ms / 25.47 ms Memory: 0.538 MB / 0.87 MB Application: afterLoad

Time: 160.10 ms / 185.57 ms Memory: 3.410 MB / 4.28 MB Application: afterInitialise

Time: 34.12 ms / 219.68 ms Memory: 0.421 MB / 4.70 MB Application: Before Access::preloadComponents (all components)

Time: 0.96 ms / 220.65 ms Memory: 0.066 MB / 4.77 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 220.67 ms Memory: 0.000 MB / 4.76 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.75 ms / 221.42 ms Memory: 0.009 MB / 4.77 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 61.25 ms / 282.67 ms Memory: 1.503 MB / 6.28 MB Application: afterRoute

Time: 0.17 ms / 282.84 ms Memory: 0.001 MB / 6.28 MB Application: beforeRenderComponent com_easyblog

Time: 2.49 ms / 285.32 ms Memory: 0.611 MB / 6.89 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 285.36 ms Memory: 0.009 MB / 6.90 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 212.09 ms / 497.45 ms Memory: 4.931 MB / 11.83 MB Application: afterRenderComponent com_easyblog

Time: 6.99 ms / 504.44 ms Memory: 0.081 MB / 11.91 MB Application: afterDispatch

Time: 3.43 ms / 507.87 ms Memory: 0.065 MB / 11.97 MB Application: beforeRenderModule mod_easyblogsubscribe (Subscribe to Our Blog)

Time: 2.95 ms / 510.82 ms Memory: 0.017 MB / 11.99 MB Application: afterRenderModule mod_easyblogsubscribe (Subscribe to Our Blog)

Time: 5.98 ms / 516.81 ms Memory: 0.055 MB / 12.05 MB Application: beforeRenderModule mod_widgetkit (Accreditation Slideset)

Time: 6.50 ms / 523.30 ms Memory: 0.128 MB / 12.17 MB Application: afterRenderModule mod_widgetkit (Accreditation Slideset)

Time: 4.96 ms / 528.26 ms Memory: 0.042 MB / 12.22 MB Application: beforeRenderModule mod_zooitem (Company Blog Posts)

Time: 4.53 ms / 532.79 ms Memory: 0.136 MB / 12.35 MB Application: afterRenderModule mod_zooitem (Company Blog Posts)

Time: 0.07 ms / 532.86 ms Memory: 0.000 MB / 12.35 MB Application: beforeRenderModule mod_search (Search)

Time: 1.33 ms / 534.19 ms Memory: 0.016 MB / 12.36 MB Application: afterRenderModule mod_search (Search)

Time: 0.05 ms / 534.24 ms Memory: 0.000 MB / 12.36 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 5.05 ms / 539.28 ms Memory: 0.302 MB / 12.66 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.05 ms / 539.34 ms Memory: 0.000 MB / 12.54 MB Application: beforeRenderModule mod_menu ()

Time: 1.51 ms / 540.85 ms Memory: 0.124 MB / 12.66 MB Application: afterRenderModule mod_menu ()

Time: 26.96 ms / 567.81 ms Memory: 0.244 MB / 12.91 MB Application: afterRender

Database queries total: 38.67 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_session	const	PRIMARY	PRIMARY	194	const	1

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `ay8y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6562353233333237633566616363336239653363613230316131623062633134', 1, 1715347951, 0, '', 0)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.31 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.59 ms After last query: 4.66 ms Query memory: 0.025 MB Memory before query: 1.404 MB Rows returned: 47

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

  FROM `ay8y_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_extensions	ref	extension	extension	82	const	47	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 3.89 ms Query memory: 0.021 MB Memory before query: 1.442 MB Rows returned: 5

SELECT id, rules

  FROM `ay8y_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.454 MB Rows returned: 2

SELECT b.id

  FROM ay8y_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 1.43 ms Query memory: 0.051 MB Memory before query: 1.476 MB Rows returned: 133

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

  FROM ay8y_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.46 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.49 ms After last query: 51.89 ms Query memory: 0.284 MB Memory before query: 2.540 MB Rows returned: 217

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	289	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	joomlastudio_lastbenetrends.m.component_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/shlib/shlib_runtime.php:70
8	plgSystemShlib->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 29.09 ms Query memory: 0.023 MB Memory before query: 3.738 MB Rows returned: 29

SELECT *

  FROM ay8y_rsform_config

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 15.16 ms Query memory: 0.025 MB Memory before query: 4.005 MB Rows returned: 1

SELECT id,template 
  FROM ay8y_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 52.00 ms Query memory: 0.027 MB Memory before query: 4.708 MB Rows returned: 47

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

  FROM `ay8y_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_arrausermigrate','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_installer','com_jce','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmeta','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_rsform','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zoo','com_zoolanders')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_assets	range	idx_asset_name	idx_asset_name	202	NULL	48	Using index condition

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.27 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:78
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.97 ms Query memory: 0.060 MB Memory before query: 4.775 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM ay8y_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomlastudio_lastbenetrends.s.template,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 34.78 ms Query memory: 0.029 MB Memory before query: 5.674 MB Rows returned: 1

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

  FROM `ay8y_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
30	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
29	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
28	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
27	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
26	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
25	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
24	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
23	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
22	Joomla\CMS\Factory::getDocument()	Same as call in the line below.
21	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:26
20	YOOtheme\Module->__get()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:28
19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:177
15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:153
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.14 ms Query memory: 0.011 MB Memory before query: 5.671 MB

UPDATE `ay8y_extensions`

  SET `params` = '{\"mediaversion\":\"0d30e26400df97aa6c8a505c841307cd\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.04 ms
Updating	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.27 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
26	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
25	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
24	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
23	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
22	Joomla\CMS\Factory::getDocument()	Same as call in the line below.
21	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:26
20	YOOtheme\Module->__get()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:28
19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:177
15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:153
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 9.53 ms Query memory: 0.027 MB Memory before query: 5.818 MB Rows returned: 1

SELECT *

  FROM ay8y_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
25	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
24	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:58
23	YOOtheme\Theme\Joomla->onSite()	Same as call in the line below.
22	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
21	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
20	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:47
19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:177
15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:153
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 20.31 ms Query memory: 0.084 MB Memory before query: 7.030 MB Rows returned: 1

SELECT *

  FROM ay8y_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.05 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:581
9	EB::config()	JROOT/administrator/components/com_easyblog/includes/utils.php:51
8	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2681
7	EB::ajax()	JROOT/components/com_easyblog/easyblog.php:23
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 8.15 ms Query memory: 0.007 MB Memory before query: 7.168 MB

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

Explain

EXPLAIN not possible on query: DELETE FROM `ay8y_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_easyblog/includes/utils.php:198
11	EasyBlogDbJoomla->query()	JROOT/administrator/components/com_easyblog/models/mailer.php:39
10	EasyBlogModelMailer->cleanup()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:29
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:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 7.175 MB Rows returned: 0

SELECT `id` 
  FROM `ay8y_easyblog_mailq` 
  WHERE `status`='0' 
  ORDER BY `id` ASC 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_mailq	ref	easyblog_mailq_status,idx_mailq_statuscreated	easyblog_mailq_status	1	const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:67
10	EasyBlogModelMailer->getPendingEmails()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:32
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:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 8.08 ms Query memory: 0.023 MB Memory before query: 8.340 MB Rows returned: 0

SELECT * 
  FROM `ay8y_easyblog_post` 
  WHERE `publish_up`<='2024-05-10 13:32:31' 
  AND `published`='2' 
  AND `state`='0' 
  ORDER BY `id` 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_post	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_blogger_list	1	const	1	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.16 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:386
10	EasyBlogModelBlogs->getScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:51
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:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 8.354 MB Rows returned: 0

SELECT id, created_by 
  FROM`ay8y_easyblog_post` 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2024-05-10 13:32:31' 
  AND `publish_down` != '0000-00-00 00:00:00' 
  AND `published` = '1' 
  AND `state` = '0'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_post	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_publishdown_posts	idx_publishdown_posts	11	NULL	2	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:542
10	EasyBlogModelBlogs->getUnpublishScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:26
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:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 8.359 MB Rows returned: 0

SELECT * 
  FROM `ay8y_easyblog_uploader_tmp` 
  WHERE `created` <= DATE_SUB('2024-05-10 13:32:31' , INTERVAL 120 MINUTE)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_uploader_tmp	range	idx_uploader_created	idx_uploader_created	5	NULL	1	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:165
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:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

SELECT a.`id` 
  FROM `ay8y_easyblog_post` as a	
  inner join `ay8y_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2024-05-10 13:32:31', INTERVAL 3 DAY)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_published	1	const	1	Using where
1	SIMPLE	b	ref	idx_postid,idx_ordering,idx_revision_state	idx_postid	8	joomlastudio_lastbenetrends.a.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:207
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:31
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 8.372 MB

DELETE a, b 
  FROM `ay8y_easyblog_post` as a	
  inner join `ay8y_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2024-05-10 13:32:31', INTERVAL 3 DAY)

Explain

EXPLAIN not possible on query: DELETE a, b FROM `ay8y_easyblog_post` as a inner join `ay8y_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2024-05-10 13:32:31', INTERVAL 3 DAY)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
init	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Deleting from main table	0.01 ms
Optimizing	0.01 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Deleting from reference tables	0.00 ms
End of update loop	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_easyblog/includes/utils.php:198
10	EasyBlogDbJoomla->query()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:220
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:31
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 4.10 ms Query memory: 0.023 MB Memory before query: 8.410 MB Rows returned: 0

select a.`id`, a.`user_id`, b.`name`, b.`email` 
  from `ay8y_easyblog_oauth` as a		
  inner join `ay8y_users` as b 
  on a.`user_id` = b.`id` 
  where a.`type` = 'facebook' 
  and a.`notify` = '0' 
  and a.`system` = '1' 
  and a.`expires` <= DATE_ADD('2024-05-10 13:32:31', INTERVAL 7 DAY)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	easyblog_oauth_user_type,idx_expiry_notify	idx_expiry_notify	806	const,const,const	1	Using where
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	joomlastudio_lastbenetrends.a.user_id	1

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/oauth.php:361
11	EasyBlogModelOauth->getSoonTobeExpired()	JROOT/administrator/components/com_easyblog/includes/oauth/adapters/facebook/client.php:572
10	EasyBlogClientFacebook->notifyAdminTokenExpiry()	JROOT/administrator/components/com_easyblog/includes/oauth/oauth.php:111
9	EasyBlogOauth->notifyAdminTokenExpiry()	JROOT/components/com_easyblog/services/maintenance.php:34
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 1.12 ms Query memory: 0.023 MB Memory before query: 8.437 MB Rows returned: 1

SELECT * 
  FROM `ay8y_menu` 
  WHERE `published`='1' 
  AND `link` LIKE 'index.php?option=com_easyblog%' 
  AND `client_id` = '0' 
  ORDER BY `id`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_menu	index	idx_client_id_parent_id_alias_language	PRIMARY	4	NULL	289	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.46 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:64
12	EasyBlogModelMenu->getAssociatedMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:97
11	EBR::getMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:448
10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/router.php:919
9	EBR::getRoutedURL()	JROOT/components/com_easyblog/services/weblog.php:26
8	require_once JROOT/components/com_easyblog/services/weblog.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3920
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 1.48 ms Query memory: 0.031 MB Memory before query: 8.521 MB Rows returned: 46

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_acl	index	idx_acl_published,idx_acl_published_id	PRIMARY	8	NULL	46	Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:322
11	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36
10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:219
9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
8	EasyBlogController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:302
7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.09 ms Query memory: 0.031 MB Memory before query: 8.556 MB Rows returned: 92

SELECT * 
  FROM `ay8y_easyblog_acl_group` 
  WHERE `content_id` IN (1, 9) 
  AND `type`='
  group'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_acl_group	ALL	easyblog_post_acl_content_type	NO INDEX KEY COULD BE USED	NULL	NULL	460	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151
11	EasyBlogAcl::getEasyBlogAclGroups()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:98
10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:219
9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
8	EasyBlogController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:302
7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.47 ms After last query: 6.49 ms Query memory: 0.025 MB Memory before query: 8.729 MB Rows returned: 0

SELECT `id` 
  FROM `ay8y_menu` 
  WHERE ( `link`='index.php?option=com_easyblog&view=tags&layout=tag&id=29' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=29&
  limit%' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=29' OR `link` LIKE 'index.php?option=com_easyblog&view=tags&layout=tag&id=29&
  limit%' ) 
  AND `published`='1'  
  AND (`language`='en-GB' OR `language`='' OR `language`='*') 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_menu	range	idx_language	idx_language	28	NULL	289	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	1.17 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
17	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:406
16	EasyBlogModelMenu->getMenusByTagId()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4321
15	EB::getMenuParams()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:159
14	EasyBlogThemes->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3827
13	EB::template()	JROOT/components/com_easyblog/views/views.php:48
12	EasyBlogView->__construct()	JROOT/components/com_easyblog/views/tags/view.html.php:32
11	EasyBlogViewTags->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:598
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:841
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_easyblog/controllers/controller.php:69
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM ay8y_easyblog_tag

  WHERE `id` = '29'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_tag	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/tag.php:47
10	EasyBlogTableTag->load()	JROOT/components/com_easyblog/views/tags/view.html.php:118
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.00 ms After last query: 30.47 ms Query memory: 0.073 MB Memory before query: 9.108 MB Rows returned: 5

SELECT DISTINCT b.*, ifnull(f.`id`, 0) as `featured` 
  FROM `ay8y_easyblog_post_tag` AS a  
  INNER JOIN `ay8y_easyblog_post` AS b  	
  ON a.post_id=b.id  
  LEFT JOIN `ay8y_easyblog_featured` AS f 	
  ON b.`id` = f.`content_id` 
  AND f.`type` = 'post' 
  INNER JOIN `ay8y_users` AS uu 
  ON b.`created_by` = uu.`id` 
  and uu.`block` = 0 
  WHERE a.`tag_id` IN ('29') 
  AND b.`published` = '1' 
  AND b.`state`='0' 
  AND ((b.`source_type` = 'easyblog.sitewide')  OR ( b.`source_type` = 'easyblog.team' 
  and 1 <= (select count(1) 
  from `ay8y_easyblog_team` as srcteam 
  where srcteam.`id` = b.`source_id` 
  and srcteam.`published` = 1 
  and ( (srcteam.`access` = 3)       OR (srcteam.`access` = 2 
  and (select count(1) 
  from `ay8y_easyblog_team_groups` as srcteamgrp 
  where srcteamgrp.`team_id` = srcteam.`id` 
  and srcteamgrp.`group_id` IN (9) ) > 0))))) 
  AND b.`access` = '0' 
  AND (1 <= (select count(1) 
  from `ay8y_easyblog_post_category` AS acp 
  INNER JOIN `ay8y_easyblog_category` as cat 
  on acp.`category_id` = cat.`id` 
  where acp.`post_id` = b.`id` 
  and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
  and (0 > 0) ) OR 	( (cat.`private` = 2) 
  and ( (select count(1) 
  from `ay8y_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (9)) > 0 ) ) ) 
  and not exists (	select acp2.post_id 
  from `ay8y_easyblog_post_category` as acp2		
  inner join  `ay8y_easyblog_category` as cat2 
  on acp2.`category_id` = cat2.`id`	
  where acp2.`post_id` = acp.`post_id`	
  and ( 		( cat2.`private` = 1 
  and (0 = 0) ) OR 		( cat2.`private` = 2 
  and (select count(1) 
  from `ay8y_easyblog_category_acl` as cacl2 
  where cacl2.`category_id` = cat2.`id` 
  and cacl2.`acl_id` = 1 
  and cacl2.`content_id` IN (9)) = 0 )	) ) )) 
  ORDER BY b.`created` desc 
  LIMIT 0,5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tagpost_id	8	const	34	Using index; Using temporary; Using filesort
1	PRIMARY	b	eq_ref	PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	PRIMARY	8	joomlastudio_lastbenetrends.a.post_id	1	Using where
1	PRIMARY	f	ALL	easyblog_featured_content_type,easyblog_content	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	uu	eq_ref	PRIMARY,idx_block	PRIMARY	4	joomlastudio_lastbenetrends.b.created_by	1	Using where; Distinct
4	DEPENDENT SUBQUERY	acp	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	joomlastudio_lastbenetrends.b.id	1	Using where; Using index
4	DEPENDENT SUBQUERY	cat	range	PRIMARY,easyblog_cat_private	easyblog_cat_private	4	NULL	2	Using where; Using index; Using join buffer (flat, BNL join)
6	DEPENDENT SUBQUERY	acp2	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	func	1	Using index
6	DEPENDENT SUBQUERY	cat2	range	PRIMARY,easyblog_cat_published,easyblog_cat_parentid,easyblog_cat_private,easyblog_cat_lft,idx_category_access,idx_category_alias_id,idx_cat_lftrgt,idx_author,idx_re_autopost	easyblog_cat_private	4	NULL	2	Using where; Using index; Using join buffer (flat, BNL join)
7	DEPENDENT SUBQUERY	cacl2	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	Using where
5	DEPENDENT SUBQUERY	cacl	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	Using where
2	DEPENDENT SUBQUERY	srcteam	range	PRIMARY,idx_viewable_team,idx_published,idx_access	idx_viewable_team	3	NULL	1	Using where; Using index
3	DEPENDENT SUBQUERY	srcteamgrp	ref	team_id,group_id,idx_team_group	idx_team_group	8	joomlastudio_lastbenetrends.srcteam.id,const	1	Using index

Profile

Status	Duration
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	2.13 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.20 ms
Removing tmp table	0.14 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:1688
10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:160
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.81 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 9.184 MB Rows returned: 1

SELECT COUNT(1) 
  FROM (SELECT DISTINCT b.*, ifnull(f.`id`, 0) as `featured` 
  FROM `ay8y_easyblog_post_tag` AS a  
  INNER JOIN `ay8y_easyblog_post` AS b  	
  ON a.post_id=b.id  
  LEFT JOIN `ay8y_easyblog_featured` AS f 	
  ON b.`id` = f.`content_id` 
  AND f.`type` = 'post' 
  INNER JOIN `ay8y_users` AS uu 
  ON b.`created_by` = uu.`id` 
  and uu.`block` = 0 
  WHERE a.`tag_id` IN ('29') 
  AND b.`published` = '1' 
  AND b.`state`='0' 
  AND ((b.`source_type` = 'easyblog.sitewide')  OR ( b.`source_type` = 'easyblog.team' 
  and 1 <= (select count(1) 
  from `ay8y_easyblog_team` as srcteam 
  where srcteam.`id` = b.`source_id` 
  and srcteam.`published` = 1 
  and ( (srcteam.`access` = 3)       OR (srcteam.`access` = 2 
  and (select count(1) 
  from `ay8y_easyblog_team_groups` as srcteamgrp 
  where srcteamgrp.`team_id` = srcteam.`id` 
  and srcteamgrp.`group_id` IN (9) ) > 0))))) 
  AND b.`access` = '0' 
  AND (1 <= (select count(1) 
  from `ay8y_easyblog_post_category` AS acp 
  INNER JOIN `ay8y_easyblog_category` as cat 
  on acp.`category_id` = cat.`id` 
  where acp.`post_id` = b.`id` 
  and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
  and (0 > 0) ) OR 	( (cat.`private` = 2) 
  and ( (select count(1) 
  from `ay8y_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (9)) > 0 ) ) ) 
  and not exists (	select acp2.post_id 
  from `ay8y_easyblog_post_category` as acp2		
  inner join  `ay8y_easyblog_category` as cat2 
  on acp2.`category_id` = cat2.`id`	
  where acp2.`post_id` = acp.`post_id`	
  and ( 		( cat2.`private` = 1 
  and (0 = 0) ) OR 		( cat2.`private` = 2 
  and (select count(1) 
  from `ay8y_easyblog_category_acl` as cacl2 
  where cacl2.`category_id` = cat2.`id` 
  and cacl2.`acl_id` = 1 
  and cacl2.`content_id` IN (9)) = 0 )	) ) )) 
  ORDER BY b.`created` desc) as x

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	34
2	DERIVED	a	ref	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tagpost_id	8	const	34	Using index; Using temporary; Using filesort
2	DERIVED	b	eq_ref	PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	PRIMARY	8	joomlastudio_lastbenetrends.a.post_id	1	Using where
2	DERIVED	f	ALL	easyblog_featured_content_type,easyblog_content	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
2	DERIVED	uu	eq_ref	PRIMARY,idx_block	PRIMARY	4	joomlastudio_lastbenetrends.b.created_by	1	Using where; Distinct
5	DEPENDENT SUBQUERY	acp	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	joomlastudio_lastbenetrends.b.id	1	Using where; Using index
5	DEPENDENT SUBQUERY	cat	range	PRIMARY,easyblog_cat_private	easyblog_cat_private	4	NULL	2	Using where; Using index; Using join buffer (flat, BNL join)
7	DEPENDENT SUBQUERY	acp2	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	func	1	Using index
7	DEPENDENT SUBQUERY	cat2	range	PRIMARY,easyblog_cat_published,easyblog_cat_parentid,easyblog_cat_private,easyblog_cat_lft,idx_category_access,idx_category_alias_id,idx_cat_lftrgt,idx_author,idx_re_autopost	easyblog_cat_private	4	NULL	2	Using where; Using index; Using join buffer (flat, BNL join)
8	DEPENDENT SUBQUERY	cacl2	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	Using where
6	DEPENDENT SUBQUERY	cacl	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	Using where
3	DEPENDENT SUBQUERY	srcteam	range	PRIMARY,idx_viewable_team,idx_published,idx_access	idx_viewable_team	3	NULL	1	Using where; Using index
4	DEPENDENT SUBQUERY	srcteamgrp	ref	team_id,group_id,idx_team_group	idx_team_group	8	joomlastudio_lastbenetrends.srcteam.id,const	1	Using index

Profile

Status	Duration
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.02 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	2.04 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Executing	0.00 ms
Sending data	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.72 ms
Removing tmp table	0.14 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.38 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:1691
10	EasyBlogModelBlog->getTaggedBlogs()	JROOT/components/com_easyblog/views/tags/view.html.php:160
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 2.82 ms Query memory: 0.022 MB Memory before query: 9.193 MB Rows returned: 1

SELECT *

  FROM ay8y_easyblog_meta

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_meta	ref	idx_meta_content_type	idx_meta_content_type	86	const,const	1	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1953
10	EB::setMeta()	JROOT/components/com_easyblog/views/tags/view.html.php:166
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 9.206 MB Rows returned: 1

select count(1) 
  from `ay8y_easyblog_post` as a  
  inner join `ay8y_easyblog_post_tag` as b    
  on a.`id` = b.`post_id`    
  and b.`tag_id` = '29'  
  where a.`access` = '1'  
  and a.`published` = '1' 
  AND (1 <= (select count(1) 
  from `ay8y_easyblog_post_category` AS acp 
  INNER JOIN `ay8y_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 `ay8y_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (9)) > 0 ) ) ) 
  and not exists (	select acp2.post_id 
  from `ay8y_easyblog_post_category` as acp2		
  inner join  `ay8y_easyblog_category` as cat2 
  on acp2.`category_id` = cat2.`id`	
  where acp2.`post_id` = acp.`post_id`	
  and ( 		( cat2.`private` = 1 
  and (0 = 0) ) OR 		( cat2.`private` = 2 
  and (select count(1) 
  from `ay8y_easyblog_category_acl` as cacl2 
  where cacl2.`category_id` = cat2.`id` 
  and cacl2.`acl_id` = 1 
  and cacl2.`content_id` IN (9)) = 0 )	) ) ))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_post_searchnew,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_searchnew	5	const,const	1	Using where
1	PRIMARY	b	ref	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tagpost_id	16	const,joomlastudio_lastbenetrends.a.id	1	Using index
2	DEPENDENT SUBQUERY	acp	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	joomlastudio_lastbenetrends.a.id	1	Using where; Using index
2	DEPENDENT SUBQUERY	cat	range	PRIMARY,easyblog_cat_private	easyblog_cat_private	4	NULL	2	Using where; Using index; Using join buffer (flat, BNL join)
4	DEPENDENT SUBQUERY	acp2	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	func	1	Using index
4	DEPENDENT SUBQUERY	cat2	range	PRIMARY,easyblog_cat_published,easyblog_cat_parentid,easyblog_cat_private,easyblog_cat_lft,idx_category_access,idx_category_alias_id,idx_cat_lftrgt,idx_author,idx_re_autopost	easyblog_cat_private	4	NULL	2	Using where; Using index; Using join buffer (flat, BNL join)
5	DEPENDENT SUBQUERY	cacl2	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	Using where
3	DEPENDENT SUBQUERY	cacl	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/tags.php:836
10	EasyBlogModelTags->getTagPrivateBlogCount()	JROOT/components/com_easyblog/views/tags/view.html.php:179
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 2.48 ms Query memory: 0.024 MB Memory before query: 9.328 MB Rows returned: 0

SELECT COUNT(1) as `voted`, `uid` 
  FROM `ay8y_easyblog_ratings` 
  WHERE `uid` IN (544,538,232,9,47) 
  AND `type`='entry' 
  AND `created_by`='0' 
  AND (`sessionid` = 'eb523327c5facc3b9e3ca201a1b0bc14' OR `ip` = '3.23.130.108') 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_ratings	ref	post_id,created_by,idx_uid_type,idx_uid_type_user,idx_uid_type_user_session,idx_uid_type_user_ipaddr	created_by	4	const	1	Using where; Using temporary

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:135
15	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:435
14	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:340
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 9.337 MB Rows returned: 0

SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
  FROM `ay8y_easyblog_ratings` AS a 
  WHERE a.`uid` IN(544,538,232,9,47) 
  AND `type`='entry' 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	post_id,idx_uid_type,idx_uid_type_user,idx_uid_type_user_ipaddr	post_id	4	NULL	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:176
15	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:566
14	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:345
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 2.95 ms Query memory: 0.024 MB Memory before query: 9.363 MB Rows returned: 0

SELECT a.`post_id`, COUNT(1) AS `count` 
  FROM `ay8y_easyblog_comment` AS a 
  LEFT JOIN `ay8y_users` AS uu 
  ON a.`created_by` = uu.`id` 
  WHERE a.`post_id` IN(544,538,232,9,47) 
  AND a.`published`='1' 
  AND (uu.`block` = 0 OR uu.`id` IS NULL) 
  GROUP BY a.`post_id`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	easyblog_comment_postid,idx_comment_post_items	easyblog_comment_postid	8	NULL	1	Using index condition; Using where
1	SIMPLE	uu	eq_ref	PRIMARY	PRIMARY	4	joomlastudio_lastbenetrends.a.created_by	1	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:629
15	EasyBlogModelComment->preloadCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:624
14	EasyBlogCache->cacheCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:355
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 3.35 ms Query memory: 0.026 MB Memory before query: 9.386 MB Rows returned: 5

select a.*, b.`post_id`, b.`primary` 
  from `ay8y_easyblog_category` as a 
  inner join `ay8y_easyblog_post_category` as b 
  on a.`id` = b.`category_id` 
  where b.`post_id` IN (544,538,232,9,47) 
  order by a.`lft` asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	range	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_postid	4	NULL	5	Using index condition; Using temporary; Using filesort
1	SIMPLE	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1746
15	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:709
14	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:360
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 2.68 ms Query memory: 0.026 MB Memory before query: 9.500 MB Rows returned: 11

select a.*, b.`post_id` 
  from `ay8y_easyblog_tag` as a 
  inner join `ay8y_easyblog_post_tag` as b 
  on a.`id` = b.`tag_id` 
  where b.`post_id` IN (544,538,232,9,47)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	range	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tag_post_id	8	NULL	11	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	8	joomlastudio_lastbenetrends.b.tag_id	1

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/tags.php:924
15	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:791
14	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:365
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.84 ms After last query: 1.97 ms Query memory: 0.099 MB Memory before query: 9.550 MB Rows returned: 5

select a.* 
  from `ay8y_easyblog_revisions` as a 
  where a.`id` IN ( 3634,3617,3595,3223,2539)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY	PRIMARY	8	NULL	5	Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	1.56 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/revisions.php:625
15	EasyBlogModelRevisions->preload()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:685
14	EasyBlogCache->cacheRevisions()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:370
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 1.74 ms Query memory: 0.026 MB Memory before query: 9.650 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`, e.`ordering` 
  from `ay8y_users` as u 
  left join `ay8y_easyblog_users` as e 
  ON u.`id` = e.`id` 
  where u.`id` = 3453

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
19	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/users.php:298
18	EasyBlogModelUsers->getUsersMeta()	JROOT/administrator/components/com_easyblog/includes/user/user.php:171
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:772
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:375
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 1.28 ms Query memory: 0.031 MB Memory before query: 9.670 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `ay8y_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
25	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
24	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
23	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
22	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:772
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:375
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 9.701 MB Rows returned: 1

SELECT *

  FROM `ay8y_users`

  WHERE `id` = 3453

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:772
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:375
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 5.15 ms Query memory: 0.026 MB Memory before query: 9.781 MB Rows returned: 1

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

  FROM `ay8y_usergroups` AS g

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

  WHERE `m`.`user_id` = 3453

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:772
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:375
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 1.38 ms Query memory: 0.024 MB Memory before query: 9.804 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`, `f`.`ordering` as `f_ordering`,`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 `ay8y_easyblog_category_fields_groups` as a 
  inner join `ay8y_easyblog_post_category` as p 
  on `a`.`category_id` = `p`.`category_id`	
  inner join `ay8y_easyblog_fields_groups` as fg 
  on `a`.`group_id` = `fg`.`id`	
  inner join `ay8y_easyblog_fields` as f 
  on `fg`.`id` = `f`.`group_id`	
  left join `ay8y_easyblog_fields_values` as fv 
  on `fv`.`field_id` = `f`.`id` 
  and `fv`.`post_id` = `p`.`post_id` 
  LEFT JOIN `ay8y_easyblog_fields_groups_acl` AS acl 
  ON fg.`id` = acl.`group_id` 
  where p.post_id IN (544,538,232,9,47) 
  AND ( acl.`acl_id` IN(9) 
  AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	category_id,cat_id	category_id	8	NULL	1	Using index
1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	joomlastudio_lastbenetrends.a.group_id	1
1	SIMPLE	f	ALL	group_id,idx_group_ordering	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	p	range	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	NULL	5	Using where; Using index; Using join buffer (incremental, BNL join)
1	SIMPLE	fv	ALL	field_id,post_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	acl	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.08 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/fields.php:309
15	EasyBlogModelFields->preloadFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:472
14	EasyBlogCache->cacheFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:380
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.94 ms Query memory: 0.025 MB Memory before query: 9.825 MB Rows returned: 5

select * 
  from `ay8y_easyblog_meta` 
  where `content_id` in (544,538,232,9,47) 
  and `type` = 'post'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay8y_easyblog_meta	range	idx_meta_content_type	idx_meta_content_type	86	NULL	5	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/metas.php:393
15	EasyBlogModelMetas->preloadPostMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:401
14	EasyBlogCache->cacheMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:385
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:52
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3949
10	EB::formatter()	JROOT/components/com_easyblog/views/tags/view.html.php:223
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 24.50 ms Query memory: 0.050 MB Memory before query: 10.185 MB Rows returned: 40

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM ay8y_modules AS m

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

  LEFT JOIN ay8y_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5,6) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.50 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:599
19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:159
18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:357
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1796
13	EB::renderModule()	JROOT/components/com_easyblog/themes/wireframe/tags/item.php:45
12	include JROOT/components/com_easyblog/themes/wireframe/tags/item.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:187
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/tags/view.html.php:238
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 19.01 ms Query memory: 0.028 MB Memory before query: 11.413 MB Rows returned: 1

SELECT `extension_id`,`name`,`enabled`,`params`

  FROM ay8y_extensions

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:152
25	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:122
24	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51
23	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:38
22	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:73
21	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:44
20	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:56
19	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
18	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
17	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_easyblog/includes/post/post.php:5506
16	EasyBlogPost->prepareContent()	JROOT/administrator/components/com_easyblog/includes/post/post.php:4985
15	EasyBlogPost->getIntro()	JROOT/templates/yootheme/html/com_easyblog/blogs/latest/default.main.php:78
14	include JROOT/templates/yootheme/html/com_easyblog/blogs/latest/default.main.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608
13	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/tags/item.php:71
12	include JROOT/components/com_easyblog/themes/wireframe/tags/item.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:187
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/tags/view.html.php:238
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.16 ms After last query: 22.58 ms Query memory: 0.028 MB Memory before query: 11.686 MB Rows returned: 0

SELECT DISTINCT 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, g.note as group_note

  FROM ay8y_fields AS a

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

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

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

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

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

  LEFT JOIN `ay8y_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,5,6) 
  AND (a.group_id = 0 OR g.access IN (1,1,5,6)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.34 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/administrator/components/com_easyblog/includes/dispatcher/dispatcher.php:42
18	EasyBlogDispatcher->trigger()	JROOT/administrator/components/com_easyblog/includes/triggers/triggers.php:48
17	EasyBlogTriggers->trigger()	JROOT/administrator/components/com_easyblog/includes/post/post.php:5507
16	EasyBlogPost->prepareContent()	JROOT/administrator/components/com_easyblog/includes/post/post.php:4985
15	EasyBlogPost->getIntro()	JROOT/templates/yootheme/html/com_easyblog/blogs/latest/default.main.php:78
14	include JROOT/templates/yootheme/html/com_easyblog/blogs/latest/default.main.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608
13	EasyBlogThemes->output()	JROOT/components/com_easyblog/themes/wireframe/tags/item.php:71
12	include JROOT/components/com_easyblog/themes/wireframe/tags/item.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:187
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/tags/view.html.php:238
9	EasyBlogViewTags->tag()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 45.34 ms Query memory: 0.048 MB Memory before query: 12.073 MB Rows returned: 1

SELECT * 
  FROM ay8y_widgetkit 
  WHERE id = "19"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
65	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
64	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35
63	YOOtheme\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Database/Database.php:88
62	YOOtheme\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
61	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
60	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:151
59	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
58	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
57	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
56	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/theme/builder/joomla-module/index.php:25
55	YOOtheme\Module->{closure}()	Same as call in the line below.
54	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:130
53	YOOtheme\Theme\Builder->doRender()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:67
52	YOOtheme\Theme\Joomla->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
51	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/ElementRenderer.php:155
50	YOOtheme\Theme\ElementRenderer->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
49	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
48	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:110
47	YOOtheme\Theme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:123
46	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
45	array_reduce()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:127
44	YOOtheme\Theme\Builder->doRender()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:67
43	YOOtheme\Theme\Joomla->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
42	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/ElementRenderer.php:155
41	YOOtheme\Theme\ElementRenderer->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
40	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
39	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:110
38	YOOtheme\Theme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:123
37	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
36	array_reduce()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:127
35	YOOtheme\Theme\Builder->doRender()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:67
34	YOOtheme\Theme\Joomla->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
33	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/ElementRenderer.php:155
32	YOOtheme\Theme\ElementRenderer->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
31	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
30	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:110
29	YOOtheme\Theme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:123
28	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
27	array_reduce()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:127
26	YOOtheme\Theme\Builder->doRender()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:67
25	YOOtheme\Theme\Joomla->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
24	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/ElementRenderer.php:155
23	YOOtheme\Theme\ElementRenderer->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
22	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
21	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:110
20	YOOtheme\Theme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:123
19	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
18	array_reduce()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:127
17	YOOtheme\Theme\Builder->doRender()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:67
16	YOOtheme\Theme\Joomla->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
15	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/ElementRenderer.php:155
14	YOOtheme\Theme\ElementRenderer->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:144
13	YOOtheme\Theme\Builder->YOOtheme\Theme\{closure}()	Same as call in the line below.
12	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/theme/modules/builder/src/Builder.php:110
11	YOOtheme\Theme\Builder->render()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:132
7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 13.92 ms Query memory: 0.023 MB Memory before query: 12.346 MB Rows returned: 0

SELECT * 
  FROM ay8y_zoo_application 
  WHERE id = 1

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
14	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
13	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
12	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
11	AppTable->get()	JROOT/modules/mod_zooitem/mod_zooitem.php:27
10	include JROOT/modules/mod_zooitem/mod_zooitem.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 28.33 ms Query memory: 0.024 MB Memory before query: 12.924 MB Rows returned: 1

SELECT `alias`

  FROM `ay8y_content`

  WHERE id = '218'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 12.938 MB Rows returned: 2

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

  FROM `ay8y_categories` AS `s`

  INNER JOIN `ay8y_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5,6) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	17	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

51 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

1 × SELECT `data` 
  FROM `ay8y_session`

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`, e.`ordering` 
  from `ay8y_users` as u 
  left join `ay8y_easyblog_users` as e 
  ON u.`id` = e.`id`

1 × SELECT * 
  FROM ay8y_easyblog_meta

1 × select count(1) 
  from `ay8y_easyblog_post` as a  
  inner join `ay8y_easyblog_post_tag` as b    
  on a.`id` = b.`post_id`    
  and b.`tag_id` = '29'

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

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

1 × SELECT a.`post_id`, COUNT(1) AS `count` 
  FROM `ay8y_easyblog_comment` AS a 
  LEFT JOIN `ay8y_users` AS uu 
  ON a.`created_by` = uu.`id`

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

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

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

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

```
1 × SELECT * 
  FROM `ay8y_users`
```

1 × SELECT DISTINCT b.*, ifnull(f.`id`, 0) as `featured` 
  FROM `ay8y_easyblog_post_tag` AS a  
  INNER JOIN `ay8y_easyblog_post` AS b   
  ON a.post_id=b.id  
  LEFT JOIN `ay8y_easyblog_featured` AS f  
  ON b.`id` = f.`content_id` 
  AND f.`type` = 'post' 
  INNER JOIN `ay8y_users` AS uu 
  ON b.`created_by` = uu.`id` 
  and uu.`block` = 0

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`, `f`.`ordering` as `f_ordering`,`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 `ay8y_easyblog_category_fields_groups` as a 
  inner join `ay8y_easyblog_post_category` as p 
  on `a`.`category_id` = `p`.`category_id` 
  inner join `ay8y_easyblog_fields_groups` as fg 
  on `a`.`group_id` = `fg`.`id` 
  inner join `ay8y_easyblog_fields` as f 
  on `fg`.`id` = `f`.`group_id` 
  left join `ay8y_easyblog_fields_values` as fv 
  on `fv`.`field_id` = `f`.`id` 
  and `fv`.`post_id` = `p`.`post_id` 
  LEFT JOIN `ay8y_easyblog_fields_groups_acl` AS acl 
  ON fg.`id` = acl.`group_id`

1 × select * 
  from `ay8y_easyblog_meta`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM ay8y_modules AS m 
  LEFT JOIN ay8y_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN ay8y_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT `extension_id`,`name`,`enabled`,`params` 
  FROM ay8y_extensions

1 × SELECT DISTINCT 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, g.note as group_note 
  FROM ay8y_fields AS a 
  LEFT JOIN `ay8y_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ay8y_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ay8y_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ay8y_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ay8y_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ay8y_fields_categories` AS fc 
  ON fc.field_id = a.id

```
1 × SELECT * 
  FROM ay8y_widgetkit
```

1 × SELECT * 
  FROM ay8y_zoo_application

1 × SELECT `alias` 
  FROM `ay8y_content`

1 × SELECT COUNT(1) 
  FROM (SELECT DISTINCT b.*, ifnull(f.`id`, 0) as `featured` 
  FROM `ay8y_easyblog_post_tag` AS a  
  INNER JOIN `ay8y_easyblog_post` AS b   
  ON a.post_id=b.id  
  LEFT JOIN `ay8y_easyblog_featured` AS f  
  ON b.`id` = f.`content_id` 
  AND f.`type` = 'post' 
  INNER JOIN `ay8y_users` AS uu 
  ON b.`created_by` = uu.`id` 
  and uu.`block` = 0

1 × SELECT * 
  FROM ay8y_easyblog_tag

1 × SELECT `session_id` 
  FROM `ay8y_session`

```
1 × SELECT * 
  FROM ay8y_languages
```

1 × SELECT id, rules 
  FROM `ay8y_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM ay8y_extensions

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

1 × SELECT * 
  FROM ay8y_rsform_confi

1 × SELECT id,template 
  FROM ay8y_template_styles

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

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

1 × SELECT * 
  FROM ay8y_easyblog_configs

```
1 × SELECT `id` 
  FROM `ay8y_menu`
```

1 × SELECT `id` 
  FROM `ay8y_easyblog_mailq`

1 × SELECT * 
  FROM `ay8y_easyblog_post`

1 × SELECT id, created_by 
  FROM`ay8y_easyblog_post`

1 × SELECT * 
  FROM `ay8y_easyblog_uploader_tmp`

1 × SELECT a.`id` 
  FROM `ay8y_easyblog_post` as a 
  inner join `ay8y_easyblog_revisions` as b 
  on a.`id` = b.`post_id`

1 × select a.`id`, a.`user_id`, b.`name`, b.`email` 
  from `ay8y_easyblog_oauth` as a  
  inner join `ay8y_users` as b 
  on a.`user_id` = b.`id`

```
1 × SELECT * 
  FROM `ay8y_menu`
```

1 × SELECT * 
  FROM `ay8y_easyblog_acl`

1 × SELECT * 
  FROM `ay8y_easyblog_acl_group`

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

OTHER Tables:

1 × INSERT INTO `ay8y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6562353233333237633566616363336239653363613230316131623062633134', 1, 1715347951, 0, '', 0

1 × UPDATE `ay8y_extensions` 
  SET `params` = '{\"mediaversion\":\"0d30e26400df97aa6c8a505c841307cd\"}'

1 × DELETE 
  FROM `ay8y_easyblog_mailq`

1 × DELETE a, b 
  FROM `ay8y_easyblog_post` as a 
  inner join `ay8y_easyblog_revisions` as b 
  on a.`id` = b.`post_id`

1 × SHOW FULL COLUMNS 
  FROM `ay8y_users

Spotlight on Success: 22 Veterans That Are Winning the Market War

How Successful Entrepreneurs Handle Rejection

Escaping the Cube: Why, When, and How Workers Leave Corporate America to Pursue Entrepreneurial Ambitions

How Much Money Do You Need in the Bank Before Launching a Business?

The 7 Habits Of Highly Effective People - Plus One More

Our Pledge to You

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

52 Queries Logged 38.67 ms

51 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: