Tourist Guide

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732184475,
                "last": 1732184475,
                "now": 1732184475
            },
            "token": "nASJ6bYvkQkvzKhlhhLLZndVKS5nNIUR"
        },
        "registry": {
            "com_easycms": {
                "touristguide_items": {
                    "list": {
                        "limit": 20,
                        "start": 0
                    }
                },
                "edit": {
                    "touristguide_item": {
                        "id": null
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Time

Memory

43 Queries Logged 43.49 ms

1. Query Time: 0.61 ms Query memory: 0.023 MB Memory before query: 4.154 MB Rows returned: 0

   SELECT `data`
   
     FROM `h1upx_session`
   
     WHERE `session_id` = X'6464336135656262396638626262336532376332333463393365366631303063'

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

2. Query Time: 0.36 ms After last query: 1.59 ms Query memory: 0.020 MB Memory before query: 4.249 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `h1upx_session`
   
     WHERE `session_id` = X'6464336135656262396638626262336532376332333463393365366631303063' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

3. Query Time: 1.26 ms After last query: 0.14 ms Query memory: 0.004 MB Memory before query: 4.255 MB

   INSERT INTO `h1upx_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6464336135656262396638626262336532376332333463393365366631303063', 1, 1732184475, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `h1upx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6464336135656262396638626262336532376332333463393365366631303063', 1, 1732184475, 0, '', 0)

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.01 ms
   init	0.04 ms
   System lock	0.01 ms
   update	0.12 ms
   end	0.01 ms
   query end	0.87 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

4. Query Time: 0.47 ms After last query: 8.93 ms Query memory: 0.021 MB Memory before query: 4.807 MB Rows returned: 5

   SELECT id, rules
   
     FROM `h1upx_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.02 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.13 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

5. Query Time: 0.49 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 4.819 MB Rows returned: 2

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

   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	3	100.00	Using where; Using index

   Profile

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

   Call Stack

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

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

   ---

6. Query Time: 0.78 ms After last query: 21.45 ms Query memory: 0.059 MB Memory before query: 6.650 MB Rows returned: 1

   SELECT params 
     FROM h1upx_extensions 
     WHERE element = 'cookiespolicynotificationbar' 
     AND folder = 'system'

   Explain

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

   Profile

   Status	Duration
   starting	0.12 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.05 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.15 ms
   preparing	0.02 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	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   8	JDatabaseDriver->loadObject()	JROOT/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:185
   7	plgSystemCookiesPolicyNotificationBar->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.67 ms After last query: 82.06 ms Query memory: 0.011 MB Memory before query: 12.647 MB

   UPDATE `h1upx_extensions`
   
     SET `params` = '{\"mediaversion\":\"4273d7548f4d6495d13a22fcf255d32e\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   starting	0.10 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.11 ms
   updating	0.09 ms
   end	0.01 ms
   query end	1.05 ms
   closing tables	0.06 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   25	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   24	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   23	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   20	Joomla\CMS\Factory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:52
   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:104
   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:178
   10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:131
   9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:38
   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:49

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

   ---

8. Query Time: 3.43 ms After last query: 51.85 ms Query memory: 0.024 MB Memory before query: 16.229 MB Rows returned: 2

   SELECT DISTINCT touristguide_items.*,`touristguide_categories`.title_el AS `touristguide_category_title_el`,`touristguide_categories`.title_en AS `touristguide_category_title_en`
   
     FROM `h1upx_easycms_touristguide_items` AS touristguide_items
   
     LEFT JOIN h1upx_easycms_touristguide_categories AS `touristguide_categories` 
     ON `touristguide_categories`.id = touristguide_items.`touristguide_category_id`
   
     WHERE touristguide_items.state = 1 
     AND touristguide_items.touristguide_category_id = 1
   
     ORDER BY touristguide_items.ordering ASC 
     LIMIT 20

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	touristguide_items	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Using temporary; Using filesort
   1	SIMPLE	touristguide_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.24 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.04 ms
   init	0.09 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.16 ms
   preparing	0.03 ms
   Creating tmp table	0.21 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.89 ms
   Creating sort index	0.31 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.06 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
   12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:31
   10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
   8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
   6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.91 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 16.246 MB Rows returned: 3

   SELECT cats.id AS cats_id,cats.title_el AS title_el,cats.title_en AS title_en,cats.alias AS alias,COUNT(items.`id`) AS count_items
   
     FROM h1upx_easycms_touristguide_categories AS cats
   
     LEFT JOIN h1upx_easycms_touristguide_items AS items 
     ON cats.id = items.touristguide_category_id
   
     WHERE cats.state = 1 
     AND items.state = 1
   
     GROUP BY cats.id
   
     ORDER BY cats.ordering ASC

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	items	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Using temporary; Using filesort
   1	SIMPLE	cats	NULL	eq_ref	PRIMARY	PRIMARY	4	ormidiao_ormidiaeasycmsdb.items.touristguide_category_id	1	33.33	Using index condition; Using where

   Profile

   Status	Duration
   starting	0.12 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.04 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.02 ms
   Creating tmp table	0.05 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.27 ms
   Creating sort index	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   removing tmp table	0.09 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   13	JDatabaseDriver->loadObjectList()	JROOT/components/com_easycms/models/touristguide_items.php:206
   12	EasycmsModelTouristguide_items->getTouristguideCategories()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:32
   10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
   8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
   6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.71 ms After last query: 2.11 ms Query memory: 0.023 MB Memory before query: 16.341 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM `h1upx_easycms_touristguide_items` AS touristguide_items
    
      LEFT JOIN h1upx_easycms_touristguide_categories AS `touristguide_categories` 
      ON `touristguide_categories`.id = touristguide_items.`touristguide_category_id`
    
      WHERE touristguide_items.state = 1 
      AND touristguide_items.touristguide_category_id = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	touristguide_items	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where
    1	SIMPLE	touristguide_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:33
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.44 ms After last query: 1.19 ms Query memory: 0.023 MB Memory before query: 16.390 MB Rows returned: 1

    SELECT title_el, title_en
    
      FROM h1upx_easycms_touristguide_categories
    
      WHERE state=1 
      AND id = 1

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 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.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_easycms/models/touristguide_items.php:227
    14	EasycmsModelTouristguide_items->getTouristguideCategoryTitle()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:39
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.05 ms After last query: 4.35 ms Query memory: 0.033 MB Memory before query: 16.572 MB Rows returned: 23

    SHOW FULL COLUMNS 
      FROM `h1upx_easycms_touristguide_items`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    25	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:24
    24	EasycmsTabletouristguide_item->__construct()	JROOT/libraries/src/Table/Table.php:328
    23	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_easycms/models/touristguide_item.php:146
    22	EasycmsModelTouristguide_item->getTable()	JROOT/components/com_easycms/models/touristguide_item.php:96
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.71 ms After last query: 2.90 ms Query memory: 0.027 MB Memory before query: 16.671 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 1.93 ms After last query: 1.81 ms Query memory: 0.032 MB Memory before query: 16.721 MB Rows returned: 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `h1upx_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_cookiespolicynotificationbar','com_cpanel','com_easycms','com_failedloginattempts','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_loginasuser','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_watchfulli','com_wrapper')

    Explain

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

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.44 ms
    init	0.14 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.24 ms
    preparing	0.02 ms
    executing	0.02 ms
    Sending data	0.55 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    28	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    27	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    26	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    25	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    24	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:69
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.76 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 16.774 MB Rows returned: 2

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `h1upx_assets`
    
      WHERE `name` LIKE 'com_easycms.%' OR `name` = 'com_easycms' OR `parent_id` = 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    28	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    27	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    26	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    25	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    24	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:69
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 1.41 ms After last query: 4.32 ms Query memory: 0.033 MB Memory before query: 16.985 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `h1upx_assets`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    29	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
    28	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
    27	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    26	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    25	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    24	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:69
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.45 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 17.014 MB Rows returned: 0
    Duplicate queries: #18

    SELECT *
    
      FROM h1upx_assets
    
      WHERE `name` = 'com_easycms.touristguide_item.1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    29	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    28	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    27	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    26	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    25	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    24	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:69
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.52 ms After last query: 2.29 ms Query memory: 0.028 MB Memory before query: 17.061 MB Rows returned: 0
    Duplicate queries: #17

    SELECT *
    
      FROM h1upx_assets
    
      WHERE `name` = 'com_easycms.touristguide_item.1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    27	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    26	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    25	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    24	Joomla\CMS\Access\Access::getAssetRules()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:75
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 2.10 ms After last query: 2.22 ms Query memory: 0.034 MB Memory before query: 17.134 MB Rows returned: 17

    SHOW FULL COLUMNS 
      FROM `h1upx_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.42 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.50 ms
    checking permissions	0.10 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.12 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.08 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    29	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    28	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
    27	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    26	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    25	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    24	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    23	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    22	Joomla\CMS\Factory::getUser()	JROOT/components/com_easycms/models/touristguide_item.php:118
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.53 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 17.170 MB Rows returned: 1

    SELECT *
    
      FROM `h1upx_users`
    
      WHERE `id` = 1002

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    27	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    26	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    25	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    24	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    23	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    22	Joomla\CMS\Factory::getUser()	JROOT/components/com_easycms/models/touristguide_item.php:118
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 1.69 ms After last query: 7.46 ms Query memory: 0.028 MB Memory before query: 17.927 MB Rows returned: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `h1upx_usergroups` AS g
    
      INNER JOIN `h1upx_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 1002

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    27	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    26	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    25	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    24	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    23	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    22	Joomla\CMS\Factory::getUser()	JROOT/components/com_easycms/models/touristguide_item.php:118
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 2.34 ms After last query: 2.78 ms Query memory: 0.023 MB Memory before query: 18.010 MB Rows returned: 1

    SELECT media.*
    
      FROM `h1upx_easycms_media` AS media
    
      WHERE media.controller = "touristguide_items" 
      AND media.media_type = "mainphoto" 
      AND media.item_id = 1
    
      ORDER BY media.item_order ASC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easycms/helpers/easycms.php:282
    14	EasycmsHelper::getMedia()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:123
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.60 ms After last query: 22.03 ms Query memory: 0.027 MB Memory before query: 18.026 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 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.05 ms
    preparing	0.02 ms
    executing	0.03 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.41 ms After last query: 0.44 ms Query memory: 0.029 MB Memory before query: 18.049 MB Rows returned: 0
    Duplicate queries: #25

    SELECT *
    
      FROM h1upx_assets
    
      WHERE `name` = 'com_easycms.touristguide_item.2'

    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.07 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    29	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    28	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    27	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    26	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    25	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    24	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:69
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.47 ms After last query: 0.60 ms Query memory: 0.028 MB Memory before query: 18.062 MB Rows returned: 0
    Duplicate queries: #24

    SELECT *
    
      FROM h1upx_assets
    
      WHERE `name` = 'com_easycms.touristguide_item.2'

    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.06 ms
    checking permissions	0.05 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    27	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    26	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    25	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    24	Joomla\CMS\Access\Access::getAssetRules()	JROOT/administrator/components/com_easycms/tables/touristguide_item.php:75
    23	EasycmsTabletouristguide_item->bind()	JROOT/libraries/src/Table/Table.php:757
    22	Joomla\CMS\Table\Table->load()	JROOT/components/com_easycms/models/touristguide_item.php:99
    21	EasycmsModelTouristguide_item->getData()	JROOT/components/com_easycms/router.php:72
    20	EasycmsRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:75
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.56 ms After last query: 0.73 ms Query memory: 0.023 MB Memory before query: 18.064 MB Rows returned: 1

    SELECT media.*
    
      FROM `h1upx_easycms_media` AS media
    
      WHERE media.controller = "touristguide_items" 
      AND media.media_type = "mainphoto" 
      AND media.item_id = 2
    
      ORDER BY media.item_order ASC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easycms/helpers/easycms.php:282
    14	EasycmsHelper::getMedia()	JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php:123
    13	include JROOT/components/com_easycms/views/touristguide_items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_easycms/views/touristguide_items/view.html.php:55
    10	EasycmsViewTouristguide_items->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_easycms/controller.php:43
    8	EasycmsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easycms/easycms.php:36
    6	require_once JROOT/components/com_easycms/easycms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.50 ms After last query: 20.21 ms Query memory: 0.019 MB Memory before query: 18.258 MB Rows returned: 1
    Duplicate queries: #28

    SELECT extension_id 
      FROM h1upx_extensions 
      WHERE type='plugin' 
      AND element = 'cookiespolicynotificationbar' 
      AND folder='system'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	h1upx_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	10.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:709
    7	plgSystemCookiesPolicyNotificationBar->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.28 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 18.262 MB Rows returned: 1
    Duplicate queries: #27

    SELECT extension_id 
      FROM h1upx_extensions 
      WHERE type='plugin' 
      AND element = 'cookiespolicynotificationbar' 
      AND folder='system'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	h1upx_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	10.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    8	JDatabaseDriver->loadResult()	JROOT/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:710
    7	plgSystemCookiesPolicyNotificationBar->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 1.04 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 18.270 MB Rows returned: 3

    SELECT language,id
    
      FROM `h1upx_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 2.20 ms After last query: 5.34 ms Query memory: 0.079 MB Memory before query: 18.508 MB Rows returned: 17

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM h1upx_modules AS m
    
      LEFT JOIN h1upx_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN h1upx_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 10:21:16') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 10:21:16') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 50035 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    29	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    28	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    27	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    26	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    25	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    24	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    23	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/Modules.php:158
    22	YOOtheme\Theme\Modules->countModules()	Same as call in the line below.
    21	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74
    20	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:53
    19	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252
    18	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
    17	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    16	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:130
    15	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla/UrlListener.php:32
    13	YOOtheme\Theme\Joomla\UrlListener->__invoke()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
    12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
    11	YOOtheme\View->render()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:81
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.66 ms After last query: 11.98 ms Query memory: 0.027 MB Memory before query: 18.912 MB Rows returned: 1
    Duplicate queries: #37

    SELECT id
    
      FROM h1upx_easycms_pages
    
      WHERE `alias` = 'istoria' 
      AND `state` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	h1upx_easycms_pages	NULL	const	alias	alias	402	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    23	JDatabaseDriver->loadResult()	JROOT/modules/mod_easycms/helper.php:431
    22	ModEasycmsHelper->getPageIDbyAlias()	JROOT/modules/mod_easycms/mod_easycms.php:87
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 1.35 ms After last query: 4.28 ms Query memory: 0.028 MB Memory before query: 18.985 MB Rows returned: 3
    Duplicate queries: #38

    SELECT news.*
    
      FROM `h1upx_easycms_news` AS `news`
    
      WHERE `news`.`state` = 1
    
      ORDER BY `news`.`datetime` DESC 
      LIMIT 3

    Explain

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

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    init	0.03 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.56 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:250
    22	ModEasycmsHelper::getNewsList()	JROOT/modules/mod_easycms/mod_easycms.php:127
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 1.77 ms After last query: 0.45 ms Query memory: 0.045 MB Memory before query: 19.014 MB Rows returned: 3
    Duplicate queries: #39

    SELECT events.*,`event_categories`.title_el AS `event_category_title_el`, `event_categories`.title_en AS `event_category_title_en`
    
      FROM `h1upx_easycms_events` AS `events`
    
      LEFT JOIN h1upx_easycms_event_categories AS `event_categories` 
      ON `event_categories`.id = `events`.`event_category_id`
    
      WHERE `events`.`state` = 1
    
      ORDER BY `events`.`start_date` DESC 
      LIMIT 3

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	event_categories	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	events	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	38	10.00	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:283
    22	ModEasycmsHelper::getEventsList()	JROOT/modules/mod_easycms/mod_easycms.php:130
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 1.67 ms After last query: 0.40 ms Query memory: 0.028 MB Memory before query: 19.043 MB Rows returned: 4
    Duplicate queries: #40

    SELECT banners.*,`banner_categories`.title_el AS `banner_category_title`
    
      FROM `h1upx_easycms_banners` AS `banners`
    
      LEFT JOIN h1upx_easycms_banner_categories AS `banner_categories` 
      ON `banner_categories`.id = banners.`banner_category_id`
    
      WHERE `banners`.`state` = 1 
      AND IF(banners.start_date != "0000-00-00", CURDATE() >= banners.start_date, 1=1) 
      AND IF(banners.end_date != "0000-00-00", CURDATE() <= banners.end_date, 1=1)
    
      ORDER BY `banners`.`ordering` ASC 
      LIMIT 6

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	banners	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Using filesort
    1	SIMPLE	banner_categories	NULL	eq_ref	PRIMARY	PRIMARY	4	ormidiao_ormidiaeasycmsdb.banners.banner_category_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.77 ms
    init	0.11 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    Sorting result	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:327
    22	ModEasycmsHelper::getBannersList()	JROOT/modules/mod_easycms/mod_easycms.php:133
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 1.12 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 19.061 MB Rows returned: 0
    Duplicate queries: #41

    SELECT efimerides.*
    
      FROM `h1upx_easycms_efimerides` AS `efimerides`
    
      WHERE `efimerides`.`state` = 1
    
      ORDER BY `efimerides`.`date` DESC 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.56 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:356
    22	ModEasycmsHelper::getEfimeridesList()	JROOT/modules/mod_easycms/mod_easycms.php:136
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 1.46 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 19.072 MB Rows returned: 4
    Duplicate queries: #42

    SELECT media.*
    
      FROM `h1upx_easycms_media` AS `media`
    
      WHERE `media`.`media_type` = "video"
    
      ORDER BY `media`.`id` DESC 
      LIMIT 6

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	media	NULL	index	NULL	PRIMARY	4	NULL	6	10.00	Using where

    Profile

    Status	Duration
    starting	0.10 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.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	1.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:395
    22	ModEasycmsHelper::getVideosList()	JROOT/modules/mod_easycms/mod_easycms.php:139
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.54 ms After last query: 6.52 ms Query memory: 0.027 MB Memory before query: 19.077 MB Rows returned: 1
    Duplicate queries: #31

    SELECT id
    
      FROM h1upx_easycms_pages
    
      WHERE `alias` = 'istoria' 
      AND `state` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	h1upx_easycms_pages	NULL	const	alias	alias	402	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 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.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    23	JDatabaseDriver->loadResult()	JROOT/modules/mod_easycms/helper.php:431
    22	ModEasycmsHelper->getPageIDbyAlias()	JROOT/modules/mod_easycms/mod_easycms.php:87
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.71 ms After last query: 1.37 ms Query memory: 0.028 MB Memory before query: 19.095 MB Rows returned: 3
    Duplicate queries: #32

    SELECT news.*
    
      FROM `h1upx_easycms_news` AS `news`
    
      WHERE `news`.`state` = 1
    
      ORDER BY `news`.`datetime` DESC 
      LIMIT 3

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:250
    22	ModEasycmsHelper::getNewsList()	JROOT/modules/mod_easycms/mod_easycms.php:127
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.68 ms After last query: 0.24 ms Query memory: 0.044 MB Memory before query: 19.117 MB Rows returned: 3
    Duplicate queries: #33

    SELECT events.*,`event_categories`.title_el AS `event_category_title_el`, `event_categories`.title_en AS `event_category_title_en`
    
      FROM `h1upx_easycms_events` AS `events`
    
      LEFT JOIN h1upx_easycms_event_categories AS `event_categories` 
      ON `event_categories`.id = `events`.`event_category_id`
    
      WHERE `events`.`state` = 1
    
      ORDER BY `events`.`start_date` DESC 
      LIMIT 3

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	event_categories	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	events	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	38	10.00	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:283
    22	ModEasycmsHelper::getEventsList()	JROOT/modules/mod_easycms/mod_easycms.php:130
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.48 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 19.145 MB Rows returned: 4
    Duplicate queries: #34

    SELECT banners.*,`banner_categories`.title_el AS `banner_category_title`
    
      FROM `h1upx_easycms_banners` AS `banners`
    
      LEFT JOIN h1upx_easycms_banner_categories AS `banner_categories` 
      ON `banner_categories`.id = banners.`banner_category_id`
    
      WHERE `banners`.`state` = 1 
      AND IF(banners.start_date != "0000-00-00", CURDATE() >= banners.start_date, 1=1) 
      AND IF(banners.end_date != "0000-00-00", CURDATE() <= banners.end_date, 1=1)
    
      ORDER BY `banners`.`ordering` ASC 
      LIMIT 6

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	banners	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Using filesort
    1	SIMPLE	banner_categories	NULL	eq_ref	PRIMARY	PRIMARY	4	ormidiao_ormidiaeasycmsdb.banners.banner_category_id	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:327
    22	ModEasycmsHelper::getBannersList()	JROOT/modules/mod_easycms/mod_easycms.php:133
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.20 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 19.162 MB Rows returned: 0
    Duplicate queries: #35

    SELECT efimerides.*
    
      FROM `h1upx_easycms_efimerides` AS `efimerides`
    
      WHERE `efimerides`.`state` = 1
    
      ORDER BY `efimerides`.`date` DESC 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking 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.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:356
    22	ModEasycmsHelper::getEfimeridesList()	JROOT/modules/mod_easycms/mod_easycms.php:136
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.96 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 19.174 MB Rows returned: 4
    Duplicate queries: #36

    SELECT media.*
    
      FROM `h1upx_easycms_media` AS `media`
    
      WHERE `media`.`media_type` = "video"
    
      ORDER BY `media`.`id` DESC 
      LIMIT 6

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	media	NULL	index	NULL	PRIMARY	4	NULL	6	10.00	Using where

    Profile

    Status	Duration
    starting	0.05 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
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.77 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_easycms/helper.php:395
    22	ModEasycmsHelper::getVideosList()	JROOT/modules/mod_easycms/mod_easycms.php:139
    21	include JROOT/modules/mod_easycms/mod_easycms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/joomla_module/element.php:23
    19	YOOtheme\Builder\ConfigManager->{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:275
    18	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    17	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    16	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    15	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:260
    14	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:96
    13	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:113
    12	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/index.php:131
    11	YOOtheme\Module->{closure}()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:138
    7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 1.24 ms After last query: 18.24 ms Query memory: 0.023 MB Memory before query: 19.604 MB Rows returned: 2

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `h1upx_menu` AS `c`
    
      INNER JOIN `h1upx_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `h1upx_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `h1upx_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 50035

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	a	NULL	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
    1	SIMPLE	a2	NULL	ref	idx_key	idx_key	128	const	2	100.00	Using index
    1	SIMPLE	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	ormidiao_ormidiaeasycmsdb.a2.id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:27
    7	YOOtheme\Theme\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---