Myanmar Tours's Sitemap

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1781847448,
                "last": 1781847450,
                "now": 1781847451
            },
            "token": "VsQmYWYjMiW234HEFbh9yKj6xq64l1li"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "fullcurrentURL": "aHR0cHM6Ly9teWFubWFydG91cnMuY29tL3NpdGVtYXAuaHRtbA==",
        "referrer": "",
        "recent_tours": [
            "4"
        ]
    }
}

Time

Memory

25 Queries Logged 143.89 ms

1. Query Time: 0.39 ms Query memory: 0.022 MB Memory before query: 0.770 MB Rows returned: 1

   SELECT `data`
   
     FROM `huyhoa_session`
   
     WHERE `session_id` = X'6234376630663664646138383465353234623135313662646332313364383462'

   Explain

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

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	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/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.84 ms After last query: 1.30 ms Query memory: 0.020 MB Memory before query: 0.851 MB Rows returned: 5

   SELECT id, rules
   
     FROM `huyhoa_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.03 ms
   end	0.00 ms
   query end	0.01 ms
   waiting for handler commit	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
   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.]

   ---

3. Query Time: 3.90 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 0.860 MB Rows returned: 2

   SELECT b.id
   
     FROM huyhoa_usergroups AS a
   
     LEFT JOIN huyhoa_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	2	100.00	Using where; Using index

   Profile

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 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.]

   ---

4. Query Time: 2.56 ms After last query: 81.75 ms Query memory: 0.004 MB Memory before query: 2.573 MB

   UPDATE `huyhoa_extensions`
   
     SET `params` = '{\"mediaversion\":\"3477b1080b5b76ed906e94bb3c930293\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN not possible on query: UPDATE `huyhoa_extensions` SET `params` = '{\"mediaversion\":\"3477b1080b5b76ed906e94bb3c930293\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	1.11 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.08 ms
   updating	0.07 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.51 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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.]

   ---

5. Query Time: 6.17 ms After last query: 18.33 ms Query memory: 0.024 MB Memory before query: 2.811 MB Rows returned: 7

   SHOW FULL COLUMNS 
     FROM `huyhoa_osmap_sitemaps`

   Explain

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

   Profile

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.00 ms
   starting	0.94 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	2.80 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   Creating tmp table	0.06 ms
   executing	0.12 ms
   checking permissions	0.07 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.05 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
   17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
   16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
   15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_osmap/tables/sitemap.php:82
   14	OSMapTableSitemap->__construct()	JROOT/libraries/src/Table/Table.php:328
   13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Factory.php:93
   12	Alledia\OSMap\Factory::getTable()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:81
   11	Alledia\OSMap\Sitemap\Standard->__construct()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Factory.php:70
   10	Alledia\OSMap\Factory::getSitemap()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:97
   9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
   6	require_once JROOT/components/com_osmap/osmap.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.]

   ---

6. Query Time: 61.12 ms After last query: 1.24 ms Query memory: 0.022 MB Memory before query: 2.829 MB Rows returned: 1
   Duplicate queries: #9

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

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.57 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.04 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:1465
   14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
   13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_osmap/tables/sitemap.php:308
   12	OSMapTableSitemap->load()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:82
   11	Alledia\OSMap\Sitemap\Standard->__construct()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Factory.php:70
   10	Alledia\OSMap\Factory::getSitemap()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:97
   9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
   6	require_once JROOT/components/com_osmap/osmap.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.]

   ---

7. Query Time: 1.42 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 2.835 MB Rows returned: 0
   Duplicate queries: #10

   SELECT *
   
     FROM huyhoa_osmap_sitemap_menus
   
     WHERE sitemap_id = '1'
   
     ORDER BY ordering

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	huyhoa_osmap_sitemap_menus	NULL	ref	PRIMARY,fk_sitemaps_idx,ordering_idx	ordering_idx	4	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.09 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.93 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.06 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/administrator/components/com_osmap/tables/sitemap.php:320
   12	OSMapTableSitemap->load()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:82
   11	Alledia\OSMap\Sitemap\Standard->__construct()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Factory.php:70
   10	Alledia\OSMap\Factory::getSitemap()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:97
   9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
   6	require_once JROOT/components/com_osmap/osmap.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.]

   ---

8. Query Time: 1.48 ms After last query: 3.21 ms Query memory: 0.024 MB Memory before query: 2.875 MB Rows returned: 0

   SELECT mt.id,mt.title AS `name`,mt.menutype,osm.changefreq,osm.priority,osm.ordering
   
     FROM huyhoa_osmap_sitemap_menus AS osm
   
     LEFT JOIN huyhoa_menu_types AS mt 
     ON (osm.menutype_id = mt.id)
   
     WHERE osm.sitemap_id = '1'
   
     ORDER BY osm.ordering

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	osm	NULL	ref	PRIMARY,fk_sitemaps_idx,ordering_idx	ordering_idx	4	const	1	100.00	NULL
   1	SIMPLE	mt	NULL	eq_ref	PRIMARY	PRIMARY	4	myanmartours.osm.menutype_id	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.94 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.11 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:330
   17	Alledia\OSMap\Sitemap\Collector->getSitemapMenus()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:164
   16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:142
   15	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:22
   14	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
   13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:60
   12	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
   11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
   10	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:130
   9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
   6	require_once JROOT/components/com_osmap/osmap.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.42 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 2.885 MB Rows returned: 1
   Duplicate queries: #6

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

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
   18	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_osmap/tables/sitemap.php:308
   17	OSMapTableSitemap->load()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:162
   16	Alledia\OSMap\Sitemap\Standard->updateLinksCount()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:145
   15	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:22
   14	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
   13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:60
   12	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
   11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
   10	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:130
   9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
   8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
   6	require_once JROOT/components/com_osmap/osmap.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.36 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 2.894 MB Rows returned: 0
    Duplicate queries: #7

    SELECT *
    
      FROM huyhoa_osmap_sitemap_menus
    
      WHERE sitemap_id = '1'
    
      ORDER BY ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_osmap_sitemap_menus	NULL	ref	PRIMARY,fk_sitemaps_idx,ordering_idx	ordering_idx	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/tables/sitemap.php:320
    17	OSMapTableSitemap->load()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:162
    16	Alledia\OSMap\Sitemap\Standard->updateLinksCount()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:145
    15	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:22
    14	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:60
    12	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    10	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:130
    9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
    6	require_once JROOT/components/com_osmap/osmap.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: 2.04 ms After last query: 0.08 ms Query memory: 0.008 MB Memory before query: 2.904 MB

    UPDATE huyhoa_osmap_sitemaps
    
      SET is_default = 0

    Explain

    EXPLAIN not possible on query: UPDATE huyhoa_osmap_sitemaps SET is_default = 0

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    updating	0.16 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	1.35 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_osmap/tables/sitemap.php:152
    18	OSMapTableSitemap->store()	JROOT/libraries/src/Table/Table.php:933
    17	Joomla\CMS\Table\Table->save()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:165
    16	Alledia\OSMap\Sitemap\Standard->updateLinksCount()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:145
    15	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:22
    14	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:60
    12	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    10	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:130
    9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
    6	require_once JROOT/components/com_osmap/osmap.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.47 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 2.914 MB

    UPDATE `huyhoa_osmap_sitemaps` 
      SET `name`='Myanmar Tours',`created_on`='2018-01-08 10:06:09',`is_default`='1',`published`='1',`links_count`='0' 
      WHERE `id` = '1'

    Explain

    EXPLAIN not possible on query: UPDATE `huyhoa_osmap_sitemaps` SET `name`='Myanmar Tours',`created_on`='2018-01-08 10:06:09',`is_default`='1',`published`='1',`links_count`='0' WHERE `id` = '1'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.03 ms
    updating	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.76 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    20	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    19	Joomla\CMS\Table\Table->store()	JROOT/administrator/components/com_osmap/tables/sitemap.php:182
    18	OSMapTableSitemap->store()	JROOT/libraries/src/Table/Table.php:933
    17	Joomla\CMS\Table\Table->save()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:165
    16	Alledia\OSMap\Sitemap\Standard->updateLinksCount()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:145
    15	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:22
    14	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:60
    12	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    10	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:130
    9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
    6	require_once JROOT/components/com_osmap/osmap.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.57 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 2.923 MB

    DELETE 
    
      FROM huyhoa_osmap_sitemap_menus
    
      WHERE sitemap_id = '1'

    Explain

    EXPLAIN not possible on query: DELETE FROM huyhoa_osmap_sitemap_menus WHERE sitemap_id = '1'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_osmap/tables/sitemap.php:288
    19	OSMapTableSitemap->removeMenus()	JROOT/administrator/components/com_osmap/tables/sitemap.php:186
    18	OSMapTableSitemap->store()	JROOT/libraries/src/Table/Table.php:933
    17	Joomla\CMS\Table\Table->save()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:165
    16	Alledia\OSMap\Sitemap\Standard->updateLinksCount()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:145
    15	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:22
    14	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:60
    12	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    10	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/administrator/components/com_osmap/library/alledia/osmap/View/Sitemap/Html.php:130
    9	Alledia\OSMap\View\Sitemap\Html->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:17
    6	require_once JROOT/components/com_osmap/osmap.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: 2.14 ms After last query: 10.08 ms Query memory: 0.087 MB Memory before query: 3.067 MB Rows returned: 18

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM huyhoa_modules AS m
    
      LEFT JOIN huyhoa_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN huyhoa_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 <= '2026-06-19 05:37:31') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-19 05:37:31') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 285 OR mm.menuid <= 0)
    
      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	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	60	1.67	Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	myanmartours.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	myanmartours.m.id	6	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.29 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	1.12 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.03 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
    16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:655
    12	T3Template->countModules()	JROOT/templates/bienthuy/tpls/blocks/topbar.php:6
    11	include JROOT/templates/bienthuy/tpls/blocks/topbar.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/bienthuy/tpls/default-boxed.php:30
    9	include JROOT/templates/bienthuy/tpls/default-boxed.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/bienthuy/index.php:27
    7	require JROOT/templates/bienthuy/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.]

    ---

15. Query Time: 0.54 ms After last query: 16.84 ms Query memory: 0.023 MB Memory before query: 3.692 MB Rows returned: 1

    select enabled 
      from huyhoa_extensions 
      where type="component" 
      and element = "com_content"

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:93
    15	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

16. Query Time: 0.84 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.700 MB Rows returned: 110

    SELECT 
    					c.id AS CID
    				
      FROM 
    					huyhoa_categories AS c
    				
      LEFT JOIN 
    					huyhoa_content AS content 
    					
      ON 
    					c.id = content.catid 
    						
    				
      WHERE 
    					1=1 
    					 
      AND ( c.id = 8 OR c.id = 17 OR c.id = 18 OR c.id = 19 OR c.id = 20 OR c.id = 21 OR c.id = 22 OR c.id = 9) 
    					
      AND 
    					c.extension = 'com_content' 
      AND 
    					c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	PRIMARY,cat_idx	cat_idx	203	const,const	18	27.59	Using where; Using index
    1	SIMPLE	content	NULL	ref	idx_catid	idx_catid	4	myanmartours.c.id	7	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.27 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.14 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:86
    16	NSP_GK5_com_content_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:119
    15	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

17. Query Time: 0.89 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 3.719 MB Rows returned: 5

    SELECT
    			content.id AS iid				
    		
      FROM 
    			huyhoa_content AS content
    			 
    			 
    			
      LEFT JOIN huyhoa_content_frontpage as content_frontpage 
      ON id = content_id
    		
      WHERE 
    			content.state = 1
                     
      AND content.access IN (1,1,5)    
    		 		
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2026-06-18 22:37:32' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2026-06-18 22:37:32' )
    			 
      AND (  content.catid = 8 OR content.catid = 9 OR content.catid = 17 OR content.catid = 18 OR content.catid = 19 OR content.catid = 20 OR content.catid = 21 OR content.catid = 22 ) 
    			
    			 
      AND content.featured = 1 
    			
    			
    			
    		
    		
    		
      ORDER BY 
    			 content.created DESC 
    		
      LIMIT
    			0,5;

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state	1	const	82	8.00	Using where; Using filesort
    1	SIMPLE	content_frontpage	NULL	eq_ref	PRIMARY	PRIMARY	4	myanmartours.content.id	1	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	0.29 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:269
    16	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:133
    15	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

18. Query Time: 1.00 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 3.732 MB Rows returned: 5

    SELECT
    			content.id AS iid,
    			content.title AS title, 
    			content.introtext AS text,
    			content.created AS date,  
    			content.publish_up AS date_publish,
    			content.hits AS hits,
    			content.images AS images,
    			content.featured AS frontpage,
    			content.access AS access,
    			content.language AS lang,
    			categories.title AS catname, 
    			users.email AS author_email,
    			content.created_by_alias AS author_alias,
    			users.name AS author_username,
    			content_rating.rating_sum AS rating_sum,
    			content_rating.rating_count AS rating_count,
    			
      CASE WHEN CHAR_LENGTH(content.alias) 
    				THEN CONCAT_WS(":", content.id, content.alias) 
    					ELSE content.id END as id, 
    			
      CASE WHEN CHAR_LENGTH(categories.alias) 
    				THEN CONCAT_WS(":", categories.id, categories.alias) 
    					ELSE categories.id END as cid			
    		
      FROM 
    			huyhoa_content AS content 
    			
      LEFT JOIN 
    				huyhoa_categories AS categories 
    				
      ON categories.id = content.catid 
    			
      LEFT JOIN 
    				huyhoa_users AS users 
    				
      ON users.id = content.created_by 			
    			
      LEFT JOIN 
    				huyhoa_content_rating AS content_rating 
    				
      ON content_rating.content_id = content.id
    			
      LEFT JOIN 
    				huyhoa_content_frontpage AS content_frontpage 
    				
      ON content_frontpage.content_id = content.id
    		
      WHERE 
    			1=1
    			 
      AND ( content.id = 92 OR  content.id = 96 OR  content.id = 97 OR  content.id = 104 OR  content.id = 110)
    		
      ORDER BY 
    			 content.created DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	range	PRIMARY	PRIMARY	4	NULL	5	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	categories	NULL	eq_ref	PRIMARY	PRIMARY	4	myanmartours.content.catid	1	100.00	Using where
    1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	myanmartours.content.created_by	1	100.00	Using where
    1	SIMPLE	content_rating	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
    1	SIMPLE	content_frontpage	NULL	eq_ref	PRIMARY	PRIMARY	4	myanmartours.content.id	1	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    Creating tmp table	0.25 ms
    executing	0.12 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:333
    16	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:133
    15	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

19. Query Time: 0.68 ms After last query: 0.68 ms Query memory: 0.030 MB Memory before query: 3.757 MB Rows returned: 3

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	8	72.41	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.07 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    30	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    29	ContentRouter->getCategorySegment()	Same as call in the line below.
    28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    20	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    19	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    18	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    17	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

20. Query Time: 0.33 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 3.782 MB Rows returned: 1

    SELECT attribs 
      FROM huyhoa_content 
      WHERE id='92'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:86
    17	NSP_GK5_View::text()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:47
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

21. Query Time: 0.64 ms After last query: 0.17 ms Query memory: 0.030 MB Memory before query: 3.796 MB Rows returned: 2

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    30	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    29	ContentRouter->getCategorySegment()	Same as call in the line below.
    28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    20	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    19	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    18	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    17	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

22. Query Time: 52.95 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 3.811 MB Rows returned: 1

    SELECT attribs 
      FROM huyhoa_content 
      WHERE id='96'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:86
    17	NSP_GK5_View::text()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:47
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

23. Query Time: 0.44 ms After last query: 0.43 ms Query memory: 0.024 MB Memory before query: 3.820 MB Rows returned: 1

    SELECT attribs 
      FROM huyhoa_content 
      WHERE id='97'

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:86
    17	NSP_GK5_View::text()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:47
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

24. Query Time: 0.38 ms After last query: 0.27 ms Query memory: 0.063 MB Memory before query: 3.830 MB Rows returned: 1

    SELECT attribs 
      FROM huyhoa_content 
      WHERE id='104'

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:86
    17	NSP_GK5_View::text()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:47
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

25. Query Time: 0.31 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 3.839 MB Rows returned: 1

    SELECT attribs 
      FROM huyhoa_content 
      WHERE id='110'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:86
    17	NSP_GK5_View::text()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:47
    16	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:199
    15	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    14	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:627
    9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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.]

    ---

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 5 × SELECT attribs 
     FROM huyhoa_content

2. 2 × SELECT * 
     FROM huyhoa_osmap_sitemaps

3. 2 × SELECT * 
     FROM huyhoa_osmap_sitemap_menus

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

5. 1 × SELECT `data` 
     FROM `huyhoa_session`

6. 1 × SELECT id, rules 
     FROM `huyhoa_viewlevels

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

8. 1 × SELECT mt.id,mt.title AS `name`,mt.menutype,osm.changefreq,osm.priority,osm.ordering 
     FROM huyhoa_osmap_sitemap_menus AS osm 
     LEFT JOIN huyhoa_menu_types AS mt 
     ON (osm.menutype_id = mt.id)

9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM huyhoa_modules AS m 
     LEFT JOIN huyhoa_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN huyhoa_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

10. 1 × select enabled 
      from huyhoa_extensions

11. 1 × SELECT       c.id AS CID     
      FROM       huyhoa_categories AS c     
      LEFT JOIN       huyhoa_content AS content       
      ON       c.id = content.catid

12. 1 × SELECT    content.id AS iid       
      FROM     huyhoa_content AS content              
      LEFT JOIN huyhoa_content_frontpage as content_frontpage 
      ON id = content_id

13. 1 × SELECT    content.id AS iid,    content.title AS title,     content.introtext AS text,    content.created AS date,      content.publish_up AS date_publish,    content.hits AS hits,    content.images AS images,    content.featured AS frontpage,    content.access AS access,    content.language AS lang,    categories.title AS catname,     users.email AS author_email,    content.created_by_alias AS author_alias,    users.name AS author_username,    content_rating.rating_sum AS rating_sum,    content_rating.rating_count AS rating_count,    
      CASE WHEN CHAR_LENGTH(content.alias)      THEN CONCAT_WS(":", content.id, content.alias)       ELSE content.id END as id,     
      CASE WHEN CHAR_LENGTH(categories.alias)      THEN CONCAT_WS(":", categories.id, categories.alias)       ELSE categories.id END as cid      
      FROM     huyhoa_content AS content     
      LEFT JOIN      huyhoa_categories AS categories      
      ON categories.id = content.catid     
      LEFT JOIN      huyhoa_users AS users      
      ON users.id = content.created_by        
      LEFT JOIN      huyhoa_content_rating AS content_rating      
      ON content_rating.content_id = content.id    
      LEFT JOIN      huyhoa_content_frontpage AS content_frontpage      
      ON content_frontpage.content_id = content.id

OTHER Tables:

1. 1 × UPDATE `huyhoa_extensions` 
     SET `params` = '{\"mediaversion\":\"3477b1080b5b76ed906e94bb3c930293\"}'

2. 1 × SHOW FULL COLUMNS 
     FROM `huyhoa_osmap_sitemaps

3. 1 × UPDATE huyhoa_osmap_sitemaps 
     SET is_default =

4. 1 × UPDATE `huyhoa_osmap_sitemaps` 
     SET `name`='Myanmar Tours',`created_on`='2018-01-08 10:06:09',`is_default`='1',`published`='1',`links_count`='0'

5. 1 × DELETE  
     FROM huyhoa_osmap_sitemap_menus