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

88 Queries Logged 100.22 ms

1. Query Time: 0.77 ms Query memory: 0.023 MB Memory before query: 1.050 MB Rows returned: 0

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

   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.09 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.38 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.00 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.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.32 ms After last query: 0.46 ms Query memory: 0.020 MB Memory before query: 1.064 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `huyhoa_session`
   
     WHERE `session_id` = X'6339663963363466633565326331646131343263623138663138643365626337' 
     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

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 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.01 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

3. Query Time: 1.69 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 1.069 MB

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

4. Query Time: 1.70 ms After last query: 0.58 ms Query memory: 0.025 MB Memory before query: 1.100 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

   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.55 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.38 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

5. Query Time: 0.91 ms After last query: 0.66 ms Query memory: 0.021 MB Memory before query: 1.132 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.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.48 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   logging slow query	0.07 ms
   cleaning up	0.01 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.]

   ---

6. Query Time: 1.02 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.144 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

   Status	Duration
   starting	0.05 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.41 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.08 ms
   preparing	0.03 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.04 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.]

   ---

7. Query Time: 2.17 ms After last query: 0.20 ms Query memory: 0.046 MB Memory before query: 1.165 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

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

   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: 3.14 ms After last query: 19.83 ms Query memory: 0.147 MB Memory before query: 2.032 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

   Status	Duration
   starting	0.19 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.46 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.11 ms
   preparing	0.04 ms
   executing	1.50 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.22 ms
   closing tables	0.02 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: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: 0.67 ms After last query: 10.22 ms Query memory: 0.025 MB Memory before query: 3.079 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

   Status	Duration
   starting	0.10 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.11 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
   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: 1.38 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 3.135 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	0.05 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.06 ms
    updating	0.15 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.71 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    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.07 ms After last query: 0.90 ms Query memory: 0.021 MB Memory before query: 3.162 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

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.42 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.10 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
    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: 1.26 ms After last query: 3.15 ms Query memory: 0.019 MB Memory before query: 3.267 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

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

    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: 14.95 ms After last query: 6.00 ms Query memory: 0.091 MB Memory before query: 3.544 MB Rows returned: 294

    SHOW FULL COLUMNS 
      FROM `huyhoa_joomgallery_config`

    Explain

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

    Profile

    Status	Duration
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.11 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.05 ms
    freeing items	0.10 ms
    cleaning up	0.02 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_joomgallery/tables/joomgalleryconfig.php:334
    14	TableJoomgalleryConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_joomgallery/helpers/config.php:374
    12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:437
    11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
    10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
    9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
    8	JoomGalleryController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
    7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
    6	require_once JROOT/components/com_joomgallery/joomgallery.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.89 ms After last query: 1.39 ms Query memory: 0.137 MB Memory before query: 3.869 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.56 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    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_joomgallery/helpers/config.php:375
    12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:437
    11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
    10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
    9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
    8	JoomGalleryController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
    7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
    6	require_once JROOT/components/com_joomgallery/joomgallery.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: 5.76 ms After last query: 10.11 ms Query memory: 0.069 MB Memory before query: 4.115 MB Rows returned: 72

    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 <= '2023-03-23 04:45:17') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-23 04:45:17') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 738 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	66	1.52	Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	laos_travel.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	laos_travel.m.id	10	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.52 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	1.23 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    logging slow query	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()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441
    15	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371
    14	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:87
    13	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:499
    12	JoomHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:535
    11	JoomHelper::getRenderedModules()	JROOT/components/com_joomgallery/views/gallery/view.html.php:40
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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.10 ms After last query: 0.70 ms Query memory: 0.023 MB Memory before query: 4.143 MB Rows returned: 7

    SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
    
      FROM huyhoa_joomgallery_catg AS c
    
      WHERE lft > 0 
      AND c.published = 1 
      AND c.access IN (1,1) 
      AND (c.password = '' OR c.cid IN (0))
    
      ORDER BY c.lft

    Explain

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

    Profile

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.37 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.04 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:492
    12	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/helpers/helper.php:786
    11	JoomHelper::getNumberOfImgHits()	JROOT/components/com_joomgallery/views/gallery/view.html.php:58
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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: 1.57 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 4.155 MB Rows returned: 7

    SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
    
      FROM huyhoa_joomgallery
    
      WHERE approved  = 1 
      AND published = 1 
      AND hidden    = 0 
      AND access IN (1,1)
    
      GROUP BY catid

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery	NULL	index	idx_catid	idx_catid	4	NULL	168	0.60	Using where

    Profile

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.03 ms
    Opening tables	0.30 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.40 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:508
    12	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/helpers/helper.php:786
    11	JoomHelper::getNumberOfImgHits()	JROOT/components/com_joomgallery/views/gallery/view.html.php:58
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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: 1.87 ms After last query: 0.35 ms Query memory: 0.023 MB Memory before query: 4.170 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM huyhoa_joomgallery_catg AS c
    
      WHERE c.published = 1 
      AND c.hidden    = 0 
      AND c.parent_id = 1 
      AND c.access IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	idx_parent_id	idx_parent_id	4	const	6	12.50	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_joomgallery/models/gallery.php:80
    12	JoomGalleryModelGallery->getTotal()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
    11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/gallery/view.html.php:67
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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: 0.70 ms After last query: 5.46 ms Query memory: 0.026 MB Memory before query: 4.269 MB Rows returned: 7

    SELECT c.*
    
      FROM huyhoa_joomgallery_catg AS c
    
      WHERE c.published = 1 
      AND c.hidden    = 0 
      AND c.parent_id = 1 
      AND c.access IN (1,1)
    
      ORDER BY c.lft 
      LIMIT 30

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	idx_parent_id	idx_parent_id	4	const	6	12.50	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_joomgallery/models/gallery.php:188
    13	JoomGalleryModelGallery->_loadCategories()	JROOT/components/com_joomgallery/models/gallery.php:60
    12	JoomGalleryModelGallery->getCategories()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
    11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_joomgallery/views/gallery/view.html.php:173
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.51 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 4.290 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (8)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	14	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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: 0.67 ms After last query: 0.19 ms Query memory: 0.050 MB Memory before query: 4.297 MB Rows returned: 12

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 8 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	14	0.60	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 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.04 ms
    preparing	0.01 ms
    executing	0.07 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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: 0.36 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 4.307 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 8

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery_catg	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.00 ms
    checking permissions	0.00 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.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.33 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 4.315 MB Rows returned: 1
    Duplicate queries: #81

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 8

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 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.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.39 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 4.327 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (7)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	11	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.52 ms After last query: 0.13 ms Query memory: 0.046 MB Memory before query: 4.334 MB Rows returned: 9

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 7 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	11	0.60	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 1.61 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 4.339 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 7

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery_catg	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.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.30 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 4.346 MB Rows returned: 1
    Duplicate queries: #75

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 7

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery_catg	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.01 ms
    Opening tables	0.01 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.01 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.37 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 4.359 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (6)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	35	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.00 ms
    query end	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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.80 ms After last query: 0.22 ms Query memory: 0.062 MB Memory before query: 4.365 MB Rows returned: 28

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 6 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	35	0.60	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.32 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 4.370 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 6

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery_catg	NULL	const	PRIMARY	PRIMARY	4	const	1	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.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 4.377 MB Rows returned: 1
    Duplicate queries: #71  #79

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 6

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery_catg	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.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.38 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.390 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	22	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 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.03 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.59 ms After last query: 0.13 ms Query memory: 0.055 MB Memory before query: 4.402 MB Rows returned: 17

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 5 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	22	0.60	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.32 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 4.409 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 5

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.28 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 4.416 MB Rows returned: 1
    Duplicate queries: #83  #87

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 5

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 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.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.43 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 4.429 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (4)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	5	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.04 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.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.74 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 4.435 MB Rows returned: 6

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 4 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	5	1.00	Using where

    Profile

    Status	Duration
    starting	0.06 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.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.31 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 4.440 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 4

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.37 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 4.447 MB Rows returned: 1

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 4

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.75 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 4.460 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (3)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	61	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.03 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.04 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.37 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 1.35 ms After last query: 0.13 ms Query memory: 0.098 MB Memory before query: 4.466 MB Rows returned: 54

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 3 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	61	0.60	Using where

    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.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.58 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.55 ms After last query: 0.45 ms Query memory: 0.022 MB Memory before query: 4.471 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 3

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.05 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 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.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.35 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 4.479 MB Rows returned: 1
    Duplicate queries: #73  #77  #85

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 3

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 2.75 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.491 MB Rows returned: 1

    SELECT MAX(imgdate)
    
      FROM huyhoa_joomgallery AS a
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.catid IN (2)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_catid	idx_catid	4	const	18	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.06 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.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:213
    11	JoomHelper::checkNewCatg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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.]

    ---

45. Query Time: 1.56 ms After last query: 0.35 ms Query memory: 0.058 MB Memory before query: 4.497 MB Rows returned: 22

    SELECT *, c.access
    
      FROM huyhoa_joomgallery AS p
    
      LEFT JOIN huyhoa_joomgallery_catg AS c 
      ON c.cid = p.catid
    
      WHERE p.catid = 2 
      AND p.access IN (1,1) 
      AND p.published = 1 
      AND p.approved = 1 
      AND p.hidden != 1 
      AND c.access   IN (1,1) 
      AND c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	p	NULL	ref	idx_catid	idx_catid	4	const	18	0.60	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.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.04 ms
    executing	0.27 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/models/gallery.php:161
    11	JoomGalleryModelGallery->getRandomImage()	JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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.]

    ---

46. Query Time: 1.19 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 4.502 MB Rows returned: 1

    SELECT catpath
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 2

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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.]

    ---

47. Query Time: 2.15 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 4.510 MB Rows returned: 1

    SELECT alias
    
      FROM huyhoa_joomgallery_catg
    
      WHERE cid = 2

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_joomgallery_catg	NULL	const	PRIMARY	PRIMARY	4	const	1	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.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    18	JoomGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10	JoomGalleryViewGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.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.]

    ---

48. Query Time: 1.95 ms After last query: 37.46 ms Query memory: 0.031 MB Memory before query: 5.079 MB Rows returned: 45

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `huyhoa_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_associations','com_banners','com_bookhotel','com_booktour','com_bookvisa','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_customizedtour','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomgallery','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_wrapper')

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.50 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.16 ms
    preparing	0.02 ms
    executing	0.64 ms
    end	0.01 ms
    query end	0.01 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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    25	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    24	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    23	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    22	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    21	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:49
    20	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/sourcerer.php:82
    19	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/SystemPlugin.php:225
    18	RegularLabs\Library\SystemPlugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_popupaholic/mod_popupaholic.php:32
    11	include JROOT/modules/mod_popupaholic/mod_popupaholic.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    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.]

    ---

49. Query Time: 1.51 ms After last query: 210.93 ms Query memory: 0.035 MB Memory before query: 5.225 MB Rows returned: 139

    SELECT * 
      FROM huyhoa_acym_configuration

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.34 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.31 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.06 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/administrator/components/com_acym/libraries/joomla/database.php:30
    16	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:15
    15	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:37
    14	acym_config()	JROOT/administrator/components/com_acym/helpers/global/email.php:5
    13	acym_getEmailRegex()	JROOT/administrator/components/com_acym/helpers/global/module.php:38
    12	acym_initModule()	JROOT/modules/mod_acym/mod_acym.php:11
    11	include JROOT/modules/mod_acym/mod_acym.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    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.]

    ---

50. Query Time: 1.01 ms After last query: 0.58 ms Query memory: 0.023 MB Memory before query: 5.320 MB Rows returned: 1

    SELECT * 
      FROM huyhoa_acym_list 
      WHERE `type` = 'standard'

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.51 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.05 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
    logging slow query	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:30
    13	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:506
    12	AcyMailing\Classes\ListClass->getAllWithoutManagement()	JROOT/modules/mod_acym/mod_acym.php:34
    11	include JROOT/modules/mod_acym/mod_acym.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    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.]

    ---

51. Query Time: 0.59 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 5.329 MB Rows returned: 1

    SELECT * 
      FROM huyhoa_acym_field 
      WHERE `id` IN(2) 
      ORDER BY `ordering` ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	huyhoa_acym_field	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.19 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.03 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:30
    13	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/field.php:46
    12	AcyMailing\Classes\FieldClass->getFieldsByID()	JROOT/modules/mod_acym/mod_acym.php:37
    11	include JROOT/modules/mod_acym/mod_acym.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    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.]

    ---

52. Query Time: 0.67 ms After last query: 4.09 ms Query memory: 0.022 MB Memory before query: 5.546 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.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.02 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:93
    12	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    11	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    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.]

    ---

53. Query Time: 0.98 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 5.554 MB Rows returned: 30