{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1680332603,
                "last": 1680332603,
                "now": 1680332603
            },
            "token": "KhAbmtxU1om2BIVPsaCujo3jusHywFZu"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Time

Memory

127 Queries Logged 84.68 ms

1. Query Time: 0.54 ms Query memory: 0.023 MB Memory before query: 4.534 MB Rows returned: 0

   SELECT `data`
   
     FROM `sakthi_session`
   
     WHERE `session_id` = X'3065653564653930666338653963616661373035656463396564393833626466'

   Explain

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

   Profile

   Error
   The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

   Call Stack

   #	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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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.]

   ---

2. Query Time: 0.43 ms After last query: 0.61 ms Query memory: 0.020 MB Memory before query: 4.850 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `sakthi_session`
   
     WHERE `session_id` = X'3065653564653930666338653963616661373035656463396564393833626466' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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.]

   ---

3. Query Time: 0.52 ms After last query: 0.17 ms Query memory: 0.004 MB Memory before query: 4.855 MB

   INSERT INTO `sakthi_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3065653564653930666338653963616661373035656463396564393833626466', 1, 1680332603, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `sakthi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3065653564653930666338653963616661373035656463396564393833626466', 1, 1680332603, 0, '', 0)

   Profile

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

   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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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.]

   ---

4. Query Time: 0.88 ms After last query: 1.05 ms Query memory: 0.042 MB Memory before query: 4.891 MB Rows returned: 60

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `sakthi_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

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

   Profile

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

   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:225
   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.]

   ---

5. Query Time: 0.31 ms After last query: 1.20 ms Query memory: 0.021 MB Memory before query: 5.246 MB Rows returned: 5

   SELECT id, rules
   
     FROM `sakthi_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:318
   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:225
   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.]

   ---

6. Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 5.258 MB Rows returned: 1

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

   Explain

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

   Profile

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

   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:318
   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:225
   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.]

   ---

7. Query Time: 1.63 ms After last query: 0.29 ms Query memory: 0.035 MB Memory before query: 5.280 MB Rows returned: 143

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM sakthi_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sakthi_extensions	NULL	ref	extension	extension	82	const	196	0.40	Using index condition; Using where; Using filesort

   Profile

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

   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:351
   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:356
   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:225
   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.]

   ---

8. Query Time: 0.42 ms After last query: 0.70 ms Query memory: 0.020 MB Memory before query: 5.361 MB Rows returned: 1

   SELECT *
   
     FROM sakthi_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
   4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
   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:225
   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.]

   ---

9. Query Time: 0.75 ms After last query: 9.39 ms Query memory: 0.021 MB Memory before query: 8.406 MB Rows returned: 6

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `sakthi_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   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:225
   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.]

   ---

10. Query Time: 20.76 ms After last query: 11.72 ms Query memory: 2.331 MB Memory before query: 10.646 MB Rows returned: 2115

    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 sakthi_menu AS m
    
      LEFT JOIN sakthi_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

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

    Profile

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

    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:78
    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:142
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    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:533
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    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:225
    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.]

    ---

11. Query Time: 0.76 ms After last query: 37.95 ms Query memory: 0.093 MB Memory before query: 21.409 MB Rows returned: 1

    SELECT *
    
      FROM sakthi_easyblog_configs
    
      WHERE `name` = 'config'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:581
    12	EB::config()	JROOT/components/com_easyblog/router.php:513
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

12. Query Time: 0.72 ms After last query: 3.52 ms Query memory: 0.026 MB Memory before query: 22.919 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `sakthi_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    24	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    23	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    20	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    19	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    18	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    17	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    16	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    15	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_easyblog/includes/utils.php:55
    14	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/post/post.php:221
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    12	EB::post()	JROOT/components/com_easyblog/router.php:769
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

13. Query Time: 0.49 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 22.914 MB

    UPDATE `sakthi_extensions`
    
      SET `params` = '{\"mediaversion\":\"041d1f5d82999d5110a30c1e6af77c0d\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    19	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    18	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    17	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    16	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    15	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_easyblog/includes/utils.php:55
    14	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/post/post.php:221
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    12	EB::post()	JROOT/components/com_easyblog/router.php:769
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

14. Query Time: 0.55 ms After last query: 1.31 ms Query memory: 0.033 MB Memory before query: 22.957 MB Rows returned: 46

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    17	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:322
    16	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36
    15	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:219
    14	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:230
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    12	EB::post()	JROOT/components/com_easyblog/router.php:769
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

15. Query Time: 0.48 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 22.994 MB Rows returned: 46

    SELECT * 
      FROM `sakthi_easyblog_acl_group` 
      WHERE `content_id` IN (1) 
      AND `type`='
      group'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_easyblog_acl_group	NULL	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	46	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    17	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151
    16	EasyBlogAcl::getEasyBlogAclGroups()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:98
    15	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:219
    14	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:230
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    12	EB::post()	JROOT/components/com_easyblog/router.php:769
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

16. Query Time: 0.42 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 23.034 MB Rows returned: 0

    SELECT `id` 
      FROM `sakthi_easyblog_post` 
      WHERE `permalink`='sprouted:ragi-vegan-milk-shake-finger-millet-calcium-iron-rich-youtube'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_easyblog_post	NULL	ref	idx_post_permalink	idx_post_permalink	1002	const	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:459
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:770
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

17. Query Time: 0.24 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 23.043 MB Rows returned: 1

    SELECT `id` 
      FROM `sakthi_easyblog_post` 
      WHERE `permalink`='sprouted-ragi-vegan-milk-shake-finger-millet-calcium-iron-rich-youtube'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_easyblog_post	NULL	ref	idx_post_permalink	idx_post_permalink	1002	const	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:473
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:770
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

18. Query Time: 0.35 ms After last query: 0.40 ms Query memory: 0.026 MB Memory before query: 23.071 MB Rows returned: 1
    Duplicate queries: #32  #99

    SELECT *
    
      FROM sakthi_easyblog_post
    
      WHERE `id` = '871'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/post.php:77
    15	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:381
    14	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:277
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:477
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:770
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

19. Query Time: 0.28 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 23.093 MB Rows returned: 1
    Duplicate queries: #33

    SELECT *
    
      FROM sakthi_easyblog_revisions
    
      WHERE `id` = '1202'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:417
    14	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:306
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:477
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:770
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

20. Query Time: 0.34 ms After last query: 1.43 ms Query memory: 0.024 MB Memory before query: 23.794 MB Rows returned: 1

    SELECT COUNT(1) 
      FROM `sakthi_easyblog_featured` 
      WHERE `content_id`='871' 
      AND `type`='post'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_easyblog_featured	NULL	ref	easyblog_featured_content_type,easyblog_content	easyblog_featured_content_type	775	const,const	1	100.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:61
    14	EasyBlogModelBlog->isFeatured()	JROOT/administrator/components/com_easyblog/includes/post/post.php:342
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:477
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:770
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

21. Query Time: 0.32 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 23.807 MB Rows returned: 1
    Duplicate queries: #34

    SELECT * 
      FROM `sakthi_easyblog_meta` 
      WHERE `type`='post' 
      AND `content_id`='871'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:50
    15	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:512
    14	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:356
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:477
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:770
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1264
    10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.]

    ---

22. Query Time: 0.97 ms After last query: 0.47 ms Query memory: 0.028 MB Memory before query: 23.823 MB Rows returned: 59

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sakthi_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_autartimonial','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_easyblog','com_easyfolderlistingpro','com_fields','com_finder','com_fpss','com_installer','com_jce','com_jchoptimize','com_jdonation','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_mijosql','com_modules','com_newsfeeds','com_nicepaypaldownloads','com_nonumbermanager','com_phocadownload','com_phocagallery','com_phocaguestbook','com_plugins','com_postinstall','com_privacy','com_profiles','com_quicksell','com_redirect','com_search','com_searchreplace','com_tags','com_templates','com_users','com_virtualdomains','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	61	100.00	Using index condition

    Profile

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

    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:30
    10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
    9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
    8	RegularLabs\Library\SystemPlugin->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:1190
    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:225
    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.]

    ---

23. Query Time: 1.03 ms After last query: 4.33 ms Query memory: 0.027 MB Memory before query: 24.628 MB Rows returned: 20

    SELECT id, home, template, s.params
    
      FROM sakthi_template_styles as s
    
      LEFT JOIN sakthi_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	24	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	sakthi_new.e.element	1	91.43	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
    13	JHtmlJquery::framework()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
    9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:392
    8	plgSystemK2->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:1190
    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:225
    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.]

    ---

24. Query Time: 0.70 ms After last query: 2.88 ms Query memory: 0.006 MB Memory before query: 25.360 MB

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

    Explain

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

    Profile

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

    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:3925
    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:225
    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.]

    ---

25. Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 25.366 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:3925
    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:225
    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.]

    ---

26. Query Time: 0.59 ms After last query: 5.63 ms Query memory: 0.022 MB Memory before query: 26.473 MB Rows returned: 0

    SELECT * 
      FROM `sakthi_easyblog_post` 
      WHERE `publish_up`<='2023-04-01 07:03:23' 
      AND `published`='2' 
      AND `state`='0' 
      ORDER BY `id` 
      LIMIT 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:3925
    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:225
    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.]

    ---

27. Query Time: 0.30 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 26.487 MB Rows returned: 0

    SELECT id, created_by 
      FROM`sakthi_easyblog_post` 
      WHERE `publish_down` > `publish_up` 
      AND `publish_down` <= '2023-04-01 07:03:23' 
      AND `publish_down` != '0000-00-00 00:00:00' 
      AND `published` = '1' 
      AND `state` = '0'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_easyblog_post	NULL	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	3.30	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:3925
    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:225
    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.]

    ---

28. Query Time: 0.24 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 26.492 MB Rows returned: 0

    SELECT * 
      FROM `sakthi_easyblog_uploader_tmp` 
      WHERE `created` <= DATE_SUB('2023-04-01 07:03:23' , INTERVAL 120 MINUTE)

    Explain

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

    Profile

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

    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:3925
    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:225
    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.]

    ---

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

    SELECT a.`id` 
      FROM `sakthi_easyblog_post` as a	
      inner join `sakthi_easyblog_revisions` as b 
      on a.`id` = b.`post_id` 
      where a.`published` = '9' 
      and a.`created` <= DATE_SUB('2023-04-01 07:03:23', INTERVAL 3 DAY)

    Explain

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

    Profile

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

    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:3925
    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:225
    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.]

    ---

30. Query Time: 0.28 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 26.505 MB

    DELETE a, b 
      FROM `sakthi_easyblog_post` as a	
      inner join `sakthi_easyblog_revisions` as b 
      on a.`id` = b.`post_id` 
      where a.`published` = '9' 
      and a.`created` <= DATE_SUB('2023-04-01 07:03:23', INTERVAL 3 DAY)

    Explain

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

    Profile

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

    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:3925
    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:225
    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.]

    ---

31. Query Time: 4.21 ms After last query: 0.91 ms Query memory: 0.043 MB Memory before query: 26.553 MB Rows returned: 10

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sakthi_menu	NULL	index	idx_client_id_parent_id_alias_language	PRIMARY	4	NULL	2656	1.11	Using where

    Profile

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

    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:453
    10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/router.php:955
    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:3925
    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:225
    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.]

    ---

32. Query Time: 0.39 ms After last query: 1.80 ms Query memory: 0.025 MB Memory before query: 27.285 MB Rows returned: 1
    Duplicate queries: #18  #99

    SELECT *
    
      FROM sakthi_easyblog_post
    
      WHERE `id` = '871'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/post.php:77
    14	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:381
    13	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:277
    12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:236
    11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

33. Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 27.303 MB Rows returned: 1
    Duplicate queries: #19

    SELECT *
    
      FROM sakthi_easyblog_revisions
    
      WHERE `id` = '1202'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    14	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:417
    13	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:306
    12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:236
    11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

34. Query Time: 0.32 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 27.320 MB Rows returned: 1
    Duplicate queries: #21

    SELECT * 
      FROM `sakthi_easyblog_meta` 
      WHERE `type`='post' 
      AND `content_id`='871'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:50
    14	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:512
    13	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:356
    12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:236
    11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4066
    10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

35. Query Time: 0.44 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 27.350 MB Rows returned: 0

    SELECT COUNT(1) as `voted`, `uid` 
      FROM `sakthi_easyblog_ratings` 
      WHERE `uid` = '871' 
      AND `type`='entry' 
      AND `created_by`='0' 
      AND (`sessionid` = '0ee5de90fc8e9cafa705edc9ed983bdf' OR `ip` = '34.232.62.64') 
      GROUP BY `uid` 
      ORDER BY NULL

    Explain

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

    Profile

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

    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/ratings.php:135
    12	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:447
    11	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:352
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

36. Query Time: 0.22 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 27.358 MB Rows returned: 1

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

    Explain

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

    Profile

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

    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/ratings.php:176
    12	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:578
    11	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:357
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

37. Query Time: 0.64 ms After last query: 0.50 ms Query memory: 0.023 MB Memory before query: 27.381 MB Rows returned: 1

    select a.*, b.`post_id`, b.`primary` 
      from `sakthi_easyblog_category` as a 
      inner join `sakthi_easyblog_post_category` as b 
      on a.`id` = b.`category_id` 
      where b.`post_id` IN (871) 
      order by a.`lft` asc

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_postid	4	const	1	100.00	Using temporary; Using filesort
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.b.category_id	1	100.00	Using where

    Profile

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

    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/category.php:1753
    12	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:721
    11	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:372
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

38. Query Time: 0.27 ms After last query: 0.63 ms Query memory: 0.023 MB Memory before query: 28.076 MB Rows returned: 0

    select a.*, b.`post_id` 
      from `sakthi_easyblog_tag` as a 
      inner join `sakthi_easyblog_post_tag` as b 
      on a.`id` = b.`tag_id` 
      where b.`post_id` IN (871)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tag_post_id	8	const	1	100.00	NULL
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.b.tag_id	1	100.00	NULL

    Profile

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

    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/tags.php:924
    12	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:803
    11	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:377
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

39. Query Time: 0.19 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 28.097 MB Rows returned: 1

    select a.* 
      from `sakthi_easyblog_revisions` as a 
      where a.`id` IN ( 1202)

    Explain

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

    Profile

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

    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/revisions.php:625
    12	EasyBlogModelRevisions->preload()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:697
    11	EasyBlogCache->cacheRevisions()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:382
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

40. Query Time: 0.30 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 28.125 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 `sakthi_users` as u 
      left join `sakthi_easyblog_users` as e 
      ON u.`id` = e.`id` 
      where u.`id` = 442

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
    16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/users.php:298
    15	EasyBlogModelUsers->getUsersMeta()	JROOT/administrator/components/com_easyblog/includes/user/user.php:171
    14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
    13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
    12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
    11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

41. Query Time: 0.51 ms After last query: 0.89 ms Query memory: 0.030 MB Memory before query: 28.153 MB Rows returned: 17

    SHOW FULL COLUMNS 
      FROM `sakthi_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    15	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
    14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
    13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
    12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
    11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

42. Query Time: 0.19 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 28.186 MB Rows returned: 1

    SELECT *
    
      FROM `sakthi_users`
    
      WHERE `id` = 442

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    15	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
    14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
    13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
    12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
    11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

43. Query Time: 0.25 ms After last query: 0.87 ms Query memory: 0.025 MB Memory before query: 28.858 MB Rows returned: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `sakthi_usergroups` AS g
    
      INNER JOIN `sakthi_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 442

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    15	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
    14	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
    13	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
    12	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
    11	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:49
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.]

    ---

44. Query Time: 0.54 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 28.881 MB Rows returned: 0