{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679548371,
                "last": 1679548371,
                "now": 1679548371
            },
            "client": {
                "forwarded": "3.236.241.39"
            },
            "token": "ehPWU9QX6yjq2nGra3ad8SnbfygmDo8h"
        },
        "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
        }
    }
}

Time

Memory

250 Queries Logged 538.44 ms

1. Query Time: 1.43 ms Query memory: 0.023 MB Memory before query: 1.375 MB Rows returned: 0

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

   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

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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: 13.14 ms After last query: 3.83 ms Query memory: 0.020 MB Memory before query: 1.453 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `huyhoa_session`
   
     WHERE `session_id` = X'3036316332313566316137623466616464333864343037376565633037643461' 
     LIMIT 1

   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	Using index

   Profile

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

   Call Stack

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

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

   ---

3. Query Time: 6.12 ms After last query: 0.28 ms Query memory: 0.004 MB Memory before query: 1.458 MB

   INSERT INTO `huyhoa_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3036316332313566316137623466616464333864343037376565633037643461', 1, 1679548371, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `huyhoa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3036316332313566316137623466616464333864343037376565633037643461', 1, 1679548371, 0, '', 0)

   Profile

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

   Call Stack

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

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

   ---

4. Query Time: 2.90 ms After last query: 8.33 ms Query memory: 0.025 MB Memory before query: 1.490 MB Rows returned: 45

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

5. Query Time: 1.00 ms After last query: 11.51 ms Query memory: 0.021 MB Memory before query: 1.522 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

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

   Call Stack

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

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

   ---

6. Query Time: 5.77 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 1.534 MB Rows returned: 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
   
     WHERE a.id = 1

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

7. Query Time: 14.55 ms After last query: 3.17 ms Query memory: 0.046 MB Memory before query: 1.556 MB Rows returned: 121

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	huyhoa_extensions	NULL	ref	extension	extension	82	const	144	0.40	Using where; Using filesort

   Profile

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

   Call Stack

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

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

   ---

8. Query Time: 4.80 ms After last query: 123.35 ms Query memory: 0.147 MB Memory before query: 2.618 MB Rows returned: 82

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM huyhoa_menu AS m
   
     LEFT JOIN huyhoa_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	2	3.33	Using index condition; Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	laos_travel.m.component_id	1	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 4.01 ms After last query: 121.11 ms Query memory: 0.025 MB Memory before query: 3.862 MB Rows returned: 1

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
   8	plgSystemJComments->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.]

   ---

10. Query Time: 13.13 ms After last query: 5.45 ms Query memory: 0.006 MB Memory before query: 3.855 MB

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    8	plgSystemJComments->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.]

    ---

11. Query Time: 1.41 ms After last query: 7.87 ms Query memory: 0.021 MB Memory before query: 3.945 MB Rows returned: 5

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

    Explain

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

    Profile

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

    Call Stack

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

    ---

12. Query Time: 5.98 ms After last query: 8.78 ms Query memory: 0.019 MB Memory before query: 4.051 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    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: 6.26 ms After last query: 91.14 ms Query memory: 0.026 MB Memory before query: 4.362 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

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/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:74
    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.]

    ---

14. Query Time: 1.62 ms After last query: 1.66 ms Query memory: 0.023 MB Memory before query: 4.383 MB Rows returned: 1

    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

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_osmap/tables/sitemap.php:210
    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.]

    ---

15. Query Time: 2.41 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 4.389 MB Rows returned: 4

    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	4	100.00	NULL

    Profile

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

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

    ---

16. Query Time: 3.81 ms After last query: 29.95 ms Query memory: 0.026 MB Memory before query: 4.496 MB Rows returned: 4

    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	4	100.00	NULL
    1	SIMPLE	mt	NULL	eq_ref	PRIMARY	PRIMARY	4	laos_travel.osm.menutype_id	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/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:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

17. Query Time: 2.37 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 4.509 MB Rows returned: 0

    SELECT *
    
      FROM huyhoa_osmap_items_settings
    
      WHERE sitemap_id = '1' 
      AND `format` IS NULL

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:675
    17	Alledia\OSMap\Sitemap\Collector->getLegacyItemsSettings()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:169
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

18. Query Time: 0.70 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 4.519 MB Rows returned: 0

    SELECT *,IF (IFNULL(settings_hash, '') = '', uid, CONCAT(uid, ':', settings_hash)) AS `key`
    
      FROM huyhoa_osmap_items_settings
    
      WHERE sitemap_id = '1' 
      AND `format` = 2

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:636
    17	Alledia\OSMap\Sitemap\Collector->getItemsSettings()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:172
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

19. Query Time: 1.07 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 4.531 MB Rows returned: 3

    SELECT m.id,m.title AS `name`,m.alias,m.path,m.level,m.type,m.home,m.params,m.parent_id,m.browserNav,m.link,1 AS `isMenuItem`,0 AS `ignore`
    
      FROM huyhoa_menu AS m
    
      INNER JOIN huyhoa_menu AS p 
      ON (p.lft = 0)
    
      WHERE m.menutype = 'top' 
      AND m.published = 1 
      AND m.access IN (1,1) 
      AND m.lft > p.lft 
      AND m.lft < p.rgt
    
      ORDER BY m.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_menutype,idx_left_right	idx_menutype	98	const	4	1.99	Using where; Using filesort
    1	SIMPLE	p	NULL	ref	idx_left_right	idx_left_right	4	const	1	33.33	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:390
    17	Alledia\OSMap\Sitemap\Collector->getMenuItems()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:179
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

20. Query Time: 1.66 ms After last query: 5.65 ms Query memory: 0.026 MB Memory before query: 4.559 MB Rows returned: 1
    Duplicate queries: #131

    SELECT link
    
      FROM huyhoa_menu
    
      WHERE id = '575'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Item.php:233
    19	Alledia\OSMap\Sitemap\Item->setLink()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Item.php:50
    18	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:258
    17	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:205
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

21. Query Time: 1.01 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 4.570 MB Rows returned: 1
    Duplicate queries: #22  #130  #137  #147  #155  #161  #162

    SELECT folder,params,element
    
      FROM huyhoa_extensions
    
      WHERE type = 'plugin' 
      AND folder IN ('osmap','xmap') 
      AND enabled = 1
    
      ORDER BY folder DESC, ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Helper/General.php:123
    20	Alledia\OSMap\Helper\General::getPluginsFromDatabase()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Helper/General.php:198
    19	Alledia\OSMap\Helper\General::getPluginsForComponent()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:477
    18	Alledia\OSMap\Sitemap\Collector->callPluginsPreparingTheItem()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:262
    17	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:205
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

22. Query Time: 4.16 ms After last query: 3.89 ms Query memory: 0.026 MB Memory before query: 4.598 MB Rows returned: 1
    Duplicate queries: #21  #130  #137  #147  #155  #161  #162

    SELECT folder,params,element
    
      FROM huyhoa_extensions
    
      WHERE type = 'plugin' 
      AND folder IN ('osmap','xmap') 
      AND enabled = 1
    
      ORDER BY folder DESC, ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Helper/General.php:123
    20	Alledia\OSMap\Helper\General::getPluginsFromDatabase()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Helper/General.php:198
    19	Alledia\OSMap\Helper\General::getPluginsForComponent()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:477
    18	Alledia\OSMap\Sitemap\Collector->callPluginsPreparingTheItem()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:262
    17	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:205
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

23. Query Time: 14.10 ms After last query: 7.97 ms Query memory: 0.230 MB Memory before query: 4.614 MB Rows returned: 1
    Duplicate queries: #141

    SELECT `created`,`modified`,`publish_up`,`metadata`,`attribs`,`introtext`,`fulltext`,`images`
    
      FROM `huyhoa_content`
    
      WHERE `id`=85

    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

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    22	JDatabaseDriver->loadObject()	JROOT/plugins/osmap/joomla/joomla.php:149
    21	PlgOSMapJoomla::prepareMenuItem()	Same as call in the line below.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Helper/General.php:377
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:501
    18	Alledia\OSMap\Sitemap\Collector->callPluginsPreparingTheItem()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:262
    17	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Collector.php:205
    16	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/alledia/osmap/Sitemap/Standard.php:143
    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(525) : 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(525) : eval()'d code:701
    11	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(525) : 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.]

    ---

24. Query Time: 2.38 ms After last query: 9.78 ms Query memory: 0.222 MB Memory before query: 4.629 MB Rows returned: 1