Let's Have Some Ice Cream!!!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701767960,
                "last": 1701767960,
                "now": 1701767960
            },
            "token": "rt3ZF5sYXgPiimN1qxVKgbU3P9LfAdwS"
        },
        "registry": {
            "proopc": {
                "lastvisited": {
                    "url": "https://www.smokepipeshop.com/blog/entry/lets-have-some-ice-cream"
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    },
    "__vm": {
        "vmcartlastVendorId": 1
    }
}

Time

Memory

108 Queries Logged 98.98 ms

1. Query Time: 0.77 ms Query memory: 0.020 MB Memory before query: 1.034 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ifbti_session`
   
     WHERE `session_id` = X'3163653164313339393439633930323337393131356230346139653935353837' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ifbti_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:47

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

   ---

2. Query Time: 2.82 ms After last query: 0.17 ms Query memory: 0.004 MB Memory before query: 1.040 MB

   INSERT INTO `ifbti_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3163653164313339393439633930323337393131356230346139653935353837', 1, 1701767960, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ifbti_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3163653164313339393439633930323337393131356230346139653935353837', 1, 1701767960, 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:47

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

   ---

3. Query Time: 1.44 ms After last query: 0.43 ms Query memory: 0.026 MB Memory before query: 1.071 MB Rows returned: 51

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ifbti_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	ifbti_extensions	NULL	ref	extension	extension	82	const	57	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:50

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

   ---

4. Query Time: 0.40 ms After last query: 0.46 ms Query memory: 0.021 MB Memory before query: 1.102 MB Rows returned: 3

   SELECT id, rules
   
     FROM `ifbti_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ifbti_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	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:50

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

   ---

5. Query Time: 0.64 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.114 MB Rows returned: 1

   SELECT b.id
   
     FROM ifbti_usergroups AS a
   
     LEFT JOIN ifbti_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:50

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

   ---

6. Query Time: 1.32 ms After last query: 0.10 ms Query memory: 0.030 MB Memory before query: 1.135 MB Rows returned: 101

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM ifbti_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	ifbti_extensions	NULL	ref	extension	extension	82	const	203	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:50

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

   ---

7. Query Time: 2.15 ms After last query: 7.91 ms Query memory: 0.175 MB Memory before query: 1.750 MB Rows returned: 129

   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 ifbti_menu AS m
   
     LEFT JOIN ifbti_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	142	10.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	smokepipeshop_spsjan23.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
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
   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:50

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

   ---

8. Query Time: 0.93 ms After last query: 8.27 ms Query memory: 0.128 MB Memory before query: 3.333 MB Rows returned: 2

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ifbti_easyblog_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.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:535
   12	EB::config()	JROOT/components/com_easyblog/router.php:547
   11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
   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:50

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

   ---

9. Query Time: 0.53 ms After last query: 0.73 ms Query memory: 0.027 MB Memory before query: 3.613 MB Rows returned: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ifbti_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	ifbti_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:234
   13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
   12	EB::post()	JROOT/components/com_easyblog/router.php:820
   11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
   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:50

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

   ---

10. Query Time: 2.73 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 3.608 MB

    UPDATE `ifbti_extensions`
    
      SET `params` = '{\"mediaversion\":\"e0930e372010d92c086cdda6e070bb2b\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.06 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	2.17 ms
    closing tables	0.07 ms
    freeing items	0.16 ms
    cleaning up	0.01 ms

    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:234
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
    12	EB::post()	JROOT/components/com_easyblog/router.php:820
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

11. Query Time: 1.23 ms After last query: 0.37 ms Query memory: 0.033 MB Memory before query: 3.642 MB Rows returned: 51

    SELECT * 
      FROM `ifbti_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	ifbti_easyblog_acl	NULL	ALL	idx_acl_published,idx_acl_published_id	NO INDEX KEY COULD BE USED	NULL	NULL	51	98.04	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.38 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.13 ms
    Sending data	0.01 ms
    Creating sort index	0.39 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.09 ms
    cleaning up	0.00 ms

    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:296
    17	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:329
    16	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36
    15	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:297
    14	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:243
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
    12	EB::post()	JROOT/components/com_easyblog/router.php:820
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

12. Query Time: 0.99 ms After last query: 0.09 ms Query memory: 0.033 MB Memory before query: 3.682 MB Rows returned: 55

    SELECT * 
      FROM `ifbti_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	ifbti_easyblog_acl_group	NULL	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	55	100.00	NULL

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.13 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.19 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.10 ms
    freeing items	0.12 ms
    cleaning up	0.01 ms

    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:296
    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:297
    14	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:243
    13	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
    12	EB::post()	JROOT/components/com_easyblog/router.php:820
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

13. Query Time: 0.54 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 3.726 MB Rows returned: 0

    SELECT `id` 
      FROM `ifbti_easyblog_post` 
      WHERE `permalink`='lets:have-some-ice-cream'

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.17 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.14 ms
    cleaning up	0.01 ms

    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:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:472
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:821
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

14. Query Time: 0.50 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 3.733 MB Rows returned: 1

    SELECT `id` 
      FROM `ifbti_easyblog_post` 
      WHERE `permalink`='lets-have-some-ice-cream'

    Explain

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

    Profile

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

    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:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:486
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:821
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

15. Query Time: 0.44 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 3.760 MB Rows returned: 1
    Duplicate queries: #33

    SELECT *
    
      FROM ifbti_easyblog_post
    
      WHERE `id` = '5'

    Explain

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

    Profile

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

    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:78
    15	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:394
    14	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:290
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:490
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:821
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

16. Query Time: 1.12 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 3.779 MB Rows returned: 1
    Duplicate queries: #34

    SELECT *
    
      FROM ifbti_easyblog_revisions
    
      WHERE `id` = '268'

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.77 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	1.02 ms
    cleaning up	0.01 ms

    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:430
    14	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:319
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:490
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:821
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

17. Query Time: 0.32 ms After last query: 0.94 ms Query memory: 0.024 MB Memory before query: 3.907 MB Rows returned: 1

    SELECT COUNT(1) 
      FROM `ifbti_easyblog_featured` 
      WHERE `content_id`='5' 
      AND `type`='post'

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.09 ms
    cleaning up	0.01 ms

    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:296
    15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:59
    14	EasyBlogModelBlog->isFeatured()	JROOT/administrator/components/com_easyblog/includes/post/post.php:355
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:490
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:821
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

18. Query Time: 0.32 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 3.921 MB Rows returned: 1
    Duplicate queries: #35

    SELECT * 
      FROM `ifbti_easyblog_meta` 
      WHERE `type`='post' 
      AND `content_id`='5'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:50
    15	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:530
    14	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:369
    13	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:490
    12	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:821
    11	EasyBlogRouterBase::parseRoute()	JROOT/components/com_easyblog/router.php:1325
    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:50

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

    ---

19. Query Time: 0.90 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 3.933 MB Rows returned: 3

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	50.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	smokepipeshop_spsjan23.s.template,const	1	4.46	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.10 ms
    Opening tables	0.15 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/yootheme/yootheme.php:120
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:31
    8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:50

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

    ---

20. Query Time: 0.68 ms After last query: 4.86 ms Query memory: 0.027 MB Memory before query: 4.915 MB Rows returned: 1

    SELECT *
    
      FROM ifbti_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	ifbti_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    25	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    24	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:66
    23	YOOtheme\Theme\Joomla->onSite()	Same as call in the line below.
    22	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    21	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    20	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:56
    19	YOOtheme\Theme\Joomla->onInit()	Same as call in the line below.
    18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:233
    15	YOOtheme\Theme\Joomla->{closure}()	Same as call in the line below.
    14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
    13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
    12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
    11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:169
    10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:122
    9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:31
    8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:50

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

    ---

21. Query Time: 1.37 ms After last query: 1.02 ms Query memory: 0.022 MB Memory before query: 5.006 MB Rows returned: 1

    SHOW TABLES LIKE "ifbti_virtuemart_configs"

    Explain

    EXPLAIN not possible on query: SHOW TABLES LIKE "ifbti_virtuemart_configs"

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    checking permissions	0.87 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.09 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:763
    13	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:578
    12	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:417
    11	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:64
    10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:113
    9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:85
    8	plgSystemVPOnePageCheckout->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:50

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

    ---

22. Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 5.013 MB Rows returned: 1

    SELECT `config` 
      FROM `ifbti_virtuemart_configs` 
      WHERE `virtuemart_config_id` = "1";

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ifbti_virtuemart_configs	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
    11	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:64
    10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:113
    9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:85
    8	plgSystemVPOnePageCheckout->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:50

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

    ---

23. Query Time: 1.33 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 5.080 MB Rows returned: 50

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ifbti_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_customfilters','com_easyblog','com_extplorer','com_fields','com_finder','com_gantry','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend_installer','com_phocafavicon','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_search','com_spambotcheck','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vm_coupons','com_weblinks','com_wrapper')

    Explain

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

    Profile

    Status	Duration
    starting	0.37 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.05 ms
    statistics	0.21 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.26 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.98 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
    13	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
    12	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:479
    11	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:64
    10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:113
    9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:85
    8	plgSystemVPOnePageCheckout->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:50

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

    ---

24. Query Time: 0.63 ms After last query: 0.83 ms Query memory: 0.024 MB Memory before query: 5.235 MB Rows returned: 11

    SELECT * 
      FROM ifbti_rokcandy 
      WHERE published=1

    Explain

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

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.09 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	1.21 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
    13	RokCandyHelper::getUserMacros()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
    9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    8	plgSystemRokCandy->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:50

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

    ---

25. Query Time: 0.54 ms After last query: 1.07 ms Query memory: 0.006 MB Memory before query: 5.269 MB

    DELETE 
      FROM `ifbti_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	ifbti_easyblog_mailq	NULL	range	easyblog_mailq_status,idx_mailq_statuscreated	easyblog_mailq_status	1	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.12 ms
    updating	0.01 ms
    end	0.02 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.14 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_easyblog/includes/utils.php:164
    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:3425
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

26. Query Time: 0.35 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 5.275 MB Rows returned: 0

    SELECT `id` 
      FROM `ifbti_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	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	1.83 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    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:3425
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

27. Query Time: 0.62 ms After last query: 4.37 ms Query memory: 0.022 MB Memory before query: 6.385 MB Rows returned: 0

    SELECT * 
      FROM `ifbti_easyblog_post` 
      WHERE `publish_up`<='2023-12-05 09:19:20' 
      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	ifbti_easyblog_post	NULL	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_latest_posts	easyblog_post_blogger_list	1	const	1	5.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.28 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

28. Query Time: 0.65 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 6.398 MB Rows returned: 0

    SELECT id, created_by 
      FROM`ifbti_easyblog_post` 
      WHERE `publish_down` > `publish_up` 
      AND `publish_down` <= '2023-12-05 09:19:20' 
      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	ifbti_easyblog_post	NULL	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_publishdown_posts,idx_latest_posts	idx_publishdown_posts	11	NULL	3	3.16	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.34 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

29. Query Time: 0.41 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 6.405 MB Rows returned: 0

    SELECT * 
      FROM `ifbti_easyblog_uploader_tmp` 
      WHERE `created` <= DATE_SUB('2023-12-05 09:19:20' , INTERVAL 120 MINUTE)

    Explain

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

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.19 ms
    cleaning up	0.11 ms

    Call Stack

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

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

    ---

30. Query Time: 0.78 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 6.411 MB Rows returned: 0

    SELECT a.`id` 
      FROM `ifbti_easyblog_post` as a	
      inner join `ifbti_easyblog_revisions` as b 
      on a.`id` = b.`post_id` 
      where a.`published` = '9' 
      and a.`created` <= DATE_SUB('2023-12-05 09:19:20', 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,idx_latest_posts	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	smokepipeshop_spsjan23.a.id	1	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.13 ms
    closing tables	0.01 ms
    freeing items	0.17 ms
    cleaning up	0.07 ms

    Call Stack

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

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

    ---

31. Query Time: 0.58 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 6.418 MB

    DELETE a, b 
      FROM `ifbti_easyblog_post` as a	
      inner join `ifbti_easyblog_revisions` as b 
      on a.`id` = b.`post_id` 
      where a.`published` = '9' 
      and a.`created` <= DATE_SUB('2023-12-05 09:19:20', 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,idx_latest_posts	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	smokepipeshop_spsjan23.a.id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    init	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    deleting from main table	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.11 ms
    deleting from reference tables	0.01 ms
    end	0.00 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.49 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_easyblog/includes/utils.php:164
    10	EasyBlogDbJoomla->query()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:216
    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:3425
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

32. Query Time: 1.00 ms After last query: 0.37 ms Query memory: 0.024 MB Memory before query: 6.462 MB Rows returned: 3

    SELECT * 
      FROM `ifbti_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	ifbti_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	143	1.11	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.55 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.67 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    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:530
    10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/router.php:1096
    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:3425
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

33. Query Time: 0.44 ms After last query: 1.82 ms Query memory: 0.026 MB Memory before query: 6.634 MB Rows returned: 1
    Duplicate queries: #15

    SELECT *
    
      FROM ifbti_easyblog_post
    
      WHERE `id` = '5'

    Explain

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

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.22 ms
    cleaning up	0.01 ms

    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:78
    14	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:394
    13	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:290
    12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:249
    11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
    10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:28
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

34. Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 6.645 MB Rows returned: 1
    Duplicate queries: #16

    SELECT *
    
      FROM ifbti_easyblog_revisions
    
      WHERE `id` = '268'

    Explain

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

    Profile

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

    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:430
    13	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:319
    12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:249
    11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
    10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:28
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

35. Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 6.657 MB Rows returned: 1
    Duplicate queries: #18

    SELECT * 
      FROM `ifbti_easyblog_meta` 
      WHERE `type`='post' 
      AND `content_id`='5'

    Explain

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

    Profile

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

    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:296
    15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:50
    14	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:530
    13	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:369
    12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:249
    11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3564
    10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:28
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

36. Query Time: 0.86 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 6.685 MB Rows returned: 0

    SELECT COUNT(1) as `voted`, `uid` 
      FROM `ifbti_easyblog_ratings` 
      WHERE `uid` = '5' 
      AND `type`='entry' 
      AND `created_by`='0' 
      AND (`sessionid` = '1ce1d139949c902379115b04a9e95587' OR `ip` = '35.175.107.142') 
      GROUP BY `uid` 
      ORDER BY NULL

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ifbti_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

    Status	Duration
    starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.04 ms
    Creating tmp table	0.04 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    removing tmp table	0.04 ms
    query end	0.00 ms
    closing tables	0.08 ms
    freeing items	0.18 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:135
    12	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:452
    11	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:357
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:39
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
      FROM `ifbti_easyblog_ratings` AS a 
      WHERE a.`uid` IN(5) 
      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

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.07 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.29 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:176
    12	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:583
    11	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:362
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:39
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

38. Query Time: 0.48 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 6.716 MB Rows returned: 0

    SELECT a.* 
      FROM `ifbti_easyblog_comment` AS a 
      LEFT JOIN `ifbti_users` AS uu 
      ON a.`created_by` = uu.`id` 
      WHERE a.`post_id` IN(5) 
      AND a.`published`='1' 
      AND (uu.`block` = 0 OR uu.`id` IS NULL)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	easyblog_comment_postid,idx_comment_post_items	easyblog_comment_postid	8	const	1	10.00	Using where
    1	SIMPLE	uu	NULL	eq_ref	PRIMARY	PRIMARY	4	smokepipeshop_spsjan23.a.created_by	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:580
    12	EasyBlogModelComment->preloadComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:615
    11	EasyBlogCache->cacheComments()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:367
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:39
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

39. Query Time: 0.55 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 6.723 MB Rows returned: 0

    SELECT a.`post_id`, COUNT(1) AS `count` 
      FROM `ifbti_easyblog_comment` AS a 
      LEFT JOIN `ifbti_users` AS uu 
      ON a.`created_by` = uu.`id` 
      WHERE a.`post_id` IN(5) 
      AND a.`published`='1' 
      AND (uu.`block` = 0 OR uu.`id` IS NULL) 
      GROUP BY a.`post_id`

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	easyblog_comment_postid,idx_comment_post_items	easyblog_comment_postid	8	const	1	10.00	Using where
    1	SIMPLE	uu	NULL	eq_ref	PRIMARY	PRIMARY	4	smokepipeshop_spsjan23.a.created_by	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:627
    12	EasyBlogModelComment->preloadCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:641
    11	EasyBlogCache->cacheCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:372
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:39
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

40. Query Time: 1.33 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 6.744 MB Rows returned: 1

    select a.*, b.`post_id`, b.`primary` 
      from `ifbti_easyblog_category` as a 
      inner join `ifbti_easyblog_post_category` as b 
      on a.`id` = b.`category_id` 
      where b.`post_id` IN (5) 
      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	smokepipeshop_spsjan23.b.category_id	1	100.00	Using index condition

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.66 ms
    Creating sort index	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.06 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.39 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:296
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1972
    12	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:728
    11	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:377
    10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:39
    9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:103
    8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:44
    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:50

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

    ---

41. Query Time: 0.53 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 6.847 MB Rows returned: 0