จูมล่าดีบัคคอนโซล

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1574208407,
                "last": 1574208407,
                "now": 1574208407
            },
            "token": "HjxabY4q97qM746fNo3R2TDnqdoOd9TH"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "th-TH"
        }
    }
}

Time

หน่วยความจำ

30 Queries Logged 140.40 ms

1. Query Time: 15.60 ms Query memory: 0.007 MB Memory before query: 2.889 MB

   DELETE 
   
     FROM `n_session`
   
     WHERE `time` < '1574199407'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	n_session	NULL	range	time	time	45	const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.15 ms
   checking permissions	0.02 ms
   Opening tables	0.07 ms
   init	0.07 ms
   System lock	0.19 ms
   updating	2.17 ms
   end	0.02 ms
   query end	1.83 ms
   closing tables	0.03 ms
   freeing items	0.08 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\application\cms.php:822
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::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.00 ms Query memory: 0.019 MB Memory before query: 2.918 MB Rows returned: 0

   SELECT `data`
   
     FROM `n_session`
   
     WHERE `session_id` = 'p5fdrkibhqt18mphfjhc6r6ln3'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1720
   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:82
   10	JSessionHandlerJoomla->start()	JROOT\libraries\joomla\session\session.php:648
   9	JSession->_start()	JROOT\libraries\joomla\session\session.php:608
   8	JSession->start()	JROOT\libraries\joomla\session\session.php:486
   7	JSession->get()	JROOT\libraries\joomla\session\session.php:443
   6	JSession->isNew()	JROOT\libraries\cms\application\cms.php:829
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

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

   ---

3. Query Time: 0.00 ms Query memory: 0.011 MB Memory before query: 3.052 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `n_session`
   
     WHERE `session_id` = 'p5fdrkibhqt18mphfjhc6r6ln3' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT\libraries\cms\application\cms.php:176
   6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:831
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

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

   ---

4. Query Time: 15.60 ms Query memory: 0.008 MB Memory before query: 3.067 MB

   INSERT INTO `n_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('p5fdrkibhqt18mphfjhc6r6ln3', 1, '1574208407', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('p5fdrkibhqt18mphfjhc6r6ln3', 1, '1574208407', 0, '', 0)

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   update	9.25 ms
   end	0.01 ms
   query end	0.57 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\application\cms.php:216
   6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:831
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

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

   ---

5. Query Time: 0.00 ms Query memory: 0.049 MB Memory before query: 3.311 MB Rows returned: 75

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `n_extensions`
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	n_extensions	NULL	ref	extension	extension	62	const	75	100.00	NULL

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\component\helper.php:447
   9	JComponentHelper::{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
   7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:455
   6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
   5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:111
   4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:593
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
   1	JApplicationCms->execute()	JROOT\index.php:51

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

   ---

6. Query Time: 0.00 ms After last query: 15.60 ms Query memory: 0.014 MB Memory before query: 3.705 MB Rows returned: 17

   SELECT id, rules
   
     FROM `n_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:309
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:603
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
   1	JApplicationCms->execute()	JROOT\index.php:51

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

   ---

7. Query Time: 0.00 ms Query memory: 0.014 MB Memory before query: 3.746 MB Rows returned: 2

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:978
   9	JAccess::getGroupsByUser()	JROOT\libraries\joomla\access\access.php:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:309
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:603
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
   1	JApplicationCms->execute()	JROOT\index.php:51

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

   ---

8. Query Time: 0.00 ms Query memory: 0.021 MB Memory before query: 3.837 MB Rows returned: 225

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	n_extensions	NULL	ref	extension	extension	62	const	323	0.60	Using index condition; Using where; Using filesort

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\plugin\helper.php:327
   9	JPluginHelper::{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
   7	JCacheControllerCallback->get()	JROOT\libraries\cms\plugin\helper.php:332
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:603
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
   1	JApplicationCms->execute()	JROOT\index.php:51

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

   ---

9. Query Time: 0.00 ms After last query: 46.80 ms Query memory: 0.011 MB Memory before query: 5.559 MB

   UPDATE n_extensions
   
     SET enabled=1
   
     WHERE `type`='plugin' 
     AND `element`='jacontenttype' 
     AND `folder`='ajax'

   Explain

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

   Profile

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.12 ms
   updating	0.41 ms
   end	0.02 ms
   query end	0.88 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\jacontenttype\jacontenttype.php:61
   8	PlgSystemJacontenttype->_check()	JROOT\plugins\system\jacontenttype\jacontenttype.php:43
   7	PlgSystemJacontenttype->__construct()	JROOT\libraries\cms\plugin\helper.php:271
   6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:181
   5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
   1	JApplicationCms->execute()	JROOT\index.php:51

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

   ---

10. Query Time: 15.60 ms After last query: 93.60 ms Query memory: 0.016 MB Memory before query: 8.918 MB Rows returned: 2

    SELECT *
    
      FROM n_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	n_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:148
    8	JLanguageHelper::getLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:98
    7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\cms\plugin\helper.php:271
    6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:181
    5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
    3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

11. Query Time: 0.00 ms Query memory: 0.014 MB Memory before query: 8.939 MB Rows returned: 4

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `n_extensions`
    
      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:207
    8	JLanguageHelper::getInstalledLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:109
    7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\cms\plugin\helper.php:271
    6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:181
    5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
    3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

12. Query Time: 31.20 ms After last query: 78.00 ms Query memory: 0.162 MB Memory before query: 13.354 MB Rows returned: 861

    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 n_menu AS m
    
      LEFT JOIN n_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	1658	3.33	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	nsm.m.component_id	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\menu\site.php:88
    22	JMenuSite->{closure}()	Same as call in the line below.
    21	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
    20	JCacheControllerCallback->get()	JROOT\libraries\cms\menu\site.php:96
    19	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
    18	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
    17	JMenuSite->__construct()	JROOT\libraries\cms\menu\menu.php:129
    16	JMenu::getInstance()	JROOT\libraries\cms\application\cms.php:444
    15	JApplicationCms->getMenu()	JROOT\libraries\cms\application\site.php:272
    14	JApplicationSite->getMenu()	JROOT\libraries\cms\router\site.php:59
    13	JRouterSite->__construct()	JROOT\libraries\cms\router\router.php:198
    12	JRouter::getInstance()	JROOT\libraries\cms\application\cms.php:549
    11	JApplicationCms::getRouter()	JROOT\libraries\cms\application\site.php:402
    10	JApplicationSite::getRouter()	JROOT\plugins\system\languagefilter\languagefilter.php:130
    9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
    3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

13. Query Time: 0.00 ms After last query: 109.20 ms Query memory: 0.018 MB Memory before query: 20.136 MB Rows returned: 43

    SELECT id, home, template, s.params
    
      FROM n_template_styles as s
    
      LEFT JOIN n_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	62	const	13	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template	idx_template	152	nsm.e.element	4	10.00	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\application\site.php:485
    11	JApplicationSite->getTemplate()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:917
    10	plgSystemEF4_JMFramework->getTemplateName()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:210
    9	plgSystemEF4_JMFramework->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1155
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:795
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

14. Query Time: 0.00 ms Query memory: 0.023 MB Memory before query: 20.199 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `n_template_styles`

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	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.02 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.08 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.09 ms
    closing tables	0.01 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:244
    14	JTable->getFields()	JROOT\libraries\joomla\table\table.php:163
    13	JTable->__construct()	JROOT\administrator\components\com_templates\tables\style.php:30
    12	TemplatesTableStyle->__construct()	JROOT\libraries\joomla\table\table.php:311
    11	JTable::getInstance()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:927
    10	plgSystemEF4_JMFramework->getTemplateName()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:210
    9	plgSystemEF4_JMFramework->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1155
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:795
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

15. Query Time: 0.00 ms After last query: 15.60 ms Query memory: 0.017 MB Memory before query: 20.259 MB Rows returned: 1
    Duplicate queries: #26

    SELECT *
    
      FROM n_template_styles
    
      WHERE `id` = '31'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1445
    12	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:729
    11	JTable->load()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:928
    10	plgSystemEF4_JMFramework->getTemplateName()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:210
    9	plgSystemEF4_JMFramework->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1155
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:795
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

16. Query Time: 0.00 ms After last query: 46.80 ms Query memory: 0.020 MB Memory before query: 21.813 MB Rows returned: 52

    SELECT * 
      FROM n_acysms_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_acysms\classes\cpanel.php:17
    13	ACYSMScpanelClass->load()	JROOT\administrator\components\com_acysms\helpers\helper.php:265
    12	ACYSMS::config()	JROOT\administrator\components\com_acysms\helpers\helper.php:774
    11	include_once JROOT\administrator\components\com_acysms\helpers\helper.php	JROOT\plugins\system\acysmsverifnumber\acysmsverifnumber.php:30
    10	plgSystemAcySMSVerifNumber->init()	JROOT\plugins\system\acysmsverifnumber\acysmsverifnumber.php:48
    9	plgSystemAcySMSVerifNumber->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1155
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:795
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

17. Query Time: 15.60 ms Query memory: 0.039 MB Memory before query: 22.340 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `n_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	n_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    35	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1642
    34	JDatabaseDriver->loadObject()	JROOT\libraries\cms\library\helper.php:166
    33	JLibraryHelper::{closure}()	Same as call in the line below.
    32	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
    31	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:174
    30	JLibraryHelper::loadLibrary()	JROOT\libraries\cms\library\helper.php:42
    29	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:89
    28	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:270
    27	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:760
    26	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
    25	JFactory::getDocument()	JROOT\libraries\cms\html\html.php:725
    24	JHtml::script()	Same as call in the line below.
    23	call_user_func_array()	JROOT\libraries\cms\html\html.php:233
    22	JHtml::call()	JROOT\libraries\cms\html\html.php:140
    21	JHtml::_()	JROOT\libraries\cms\html\jquery.php:52
    20	JHtmlJquery::framework()	Same as call in the line below.
    19	call_user_func_array()	JROOT\libraries\cms\html\html.php:233
    18	JHtml::call()	JROOT\libraries\cms\html\html.php:140
    17	JHtml::_()	JROOT\libraries\cms\html\bootstrap.php:220
    16	JHtmlBootstrap::framework()	Same as call in the line below.
    15	call_user_func_array()	JROOT\libraries\cms\html\html.php:233
    14	JHtml::call()	JROOT\libraries\cms\html\html.php:140
    13	JHtml::_()	JROOT\administrator\components\com_acysms\compat\bootstrap.php:13
    12	require JROOT\administrator\components\com_acysms\compat\bootstrap.php	JROOT\administrator\components\com_acysms\helpers\helper.php:786
    11	include_once JROOT\administrator\components\com_acysms\helpers\helper.php	JROOT\plugins\system\acysmsverifnumber\acysmsverifnumber.php:30
    10	plgSystemAcySMSVerifNumber->init()	JROOT\plugins\system\acysmsverifnumber\acysmsverifnumber.php:48
    9	plgSystemAcySMSVerifNumber->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1155
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:795
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

18. Query Time: 0.00 ms Query memory: 0.032 MB Memory before query: 22.361 MB

    UPDATE `n_extensions`
    
      SET `params` = '{\"mediaversion\":\"360ecd8f29ad7ca74f13ede01385c09f\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.08 ms
    updating	0.57 ms
    end	0.02 ms
    query end	0.99 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\library\helper.php:116
    29	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:321
    28	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:280
    27	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:760
    26	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
    25	JFactory::getDocument()	JROOT\libraries\cms\html\html.php:725
    24	JHtml::script()	Same as call in the line below.
    23	call_user_func_array()	JROOT\libraries\cms\html\html.php:233
    22	JHtml::call()	JROOT\libraries\cms\html\html.php:140
    21	JHtml::_()	JROOT\libraries\cms\html\jquery.php:52
    20	JHtmlJquery::framework()	Same as call in the line below.
    19	call_user_func_array()	JROOT\libraries\cms\html\html.php:233
    18	JHtml::call()	JROOT\libraries\cms\html\html.php:140
    17	JHtml::_()	JROOT\libraries\cms\html\bootstrap.php:220
    16	JHtmlBootstrap::framework()	Same as call in the line below.
    15	call_user_func_array()	JROOT\libraries\cms\html\html.php:233
    14	JHtml::call()	JROOT\libraries\cms\html\html.php:140
    13	JHtml::_()	JROOT\administrator\components\com_acysms\compat\bootstrap.php:13
    12	require JROOT\administrator\components\com_acysms\compat\bootstrap.php	JROOT\administrator\components\com_acysms\helpers\helper.php:786
    11	include_once JROOT\administrator\components\com_acysms\helpers\helper.php	JROOT\plugins\system\acysmsverifnumber\acysmsverifnumber.php:30
    10	plgSystemAcySMSVerifNumber->init()	JROOT\plugins\system\acysmsverifnumber\acysmsverifnumber.php:48
    9	plgSystemAcySMSVerifNumber->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1155
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:795
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

19. Query Time: 0.00 ms After last query: 31.20 ms Query memory: 0.018 MB Memory before query: 23.100 MB Rows returned: 1

    SELECT *
    
      FROM `n_jamegafilter`
    
      WHERE `id`=212
    
      ORDER BY `id`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1445
    12	JDatabaseDriver->loadAssoc()	JROOT\components\com_jamegafilter\models\default.php:32
    11	JaMegaFilterModelDefault->getItem()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
    10	JViewLegacy->get()	JROOT\components\com_jamegafilter\views\default\view.html.php:24
    9	JaMegaFilterViewDefault->display()	JROOT\libraries\legacy\controller\legacy.php:671
    8	JControllerLegacy->display()	JROOT\libraries\legacy\controller\legacy.php:709
    7	JControllerLegacy->execute()	JROOT\components\com_jamegafilter\jamegafilter.php:28
    6	require_once JROOT\components\com_jamegafilter\jamegafilter.php	JROOT\libraries\cms\component\helper.php:389
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

20. Query Time: 0.00 ms Query memory: 0.016 MB Memory before query: 23.127 MB Rows returned: 1

    select enabled 
      from n_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	n_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_jamegafilter\helper.php:34
    10	JaMegafilterHelper::getComponentStatus()	JROOT\components\com_jamegafilter\views\default\view.html.php:36
    9	JaMegaFilterViewDefault->display()	JROOT\libraries\legacy\controller\legacy.php:671
    8	JControllerLegacy->display()	JROOT\libraries\legacy\controller\legacy.php:709
    7	JControllerLegacy->execute()	JROOT\components\com_jamegafilter\jamegafilter.php:28
    6	require_once JROOT\components\com_jamegafilter\jamegafilter.php	JROOT\libraries\cms\component\helper.php:389
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

21. Query Time: 15.60 ms After last query: 62.40 ms Query memory: 0.037 MB Memory before query: 23.559 MB Rows returned: 4

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:304
    25	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
    24	JCategories->get()	JROOT\components\com_content\router.php:72
    23	ContentRouter->getCategorySegment()	Same as call in the line below.
    22	call_user_func_array()	JROOT\libraries\cms\component\router\view.php:117
    21	JComponentRouterView->getPath()	JROOT\libraries\cms\component\router\rules\menu.php:82
    20	JComponentRouterRulesMenu->preprocess()	JROOT\libraries\cms\component\router\view.php:219
    19	JComponentRouterView->preprocess()	JROOT\libraries\cms\router\site.php:660
    18	JRouterSite->processBuildRules()	JROOT\libraries\cms\router\router.php:267
    17	JRouter->build()	JROOT\libraries\cms\router\site.php:149
    16	JRouterSite->build()	JROOT\libraries\joomla\application\route.php:62
    15	JRoute::_()	JROOT\plugins\jamegafilter\content\tmpl\default.php:31
    14	include JROOT\plugins\jamegafilter\content\tmpl\default.php	JROOT\plugins\jamegafilter\content\content.php:45
    13	plgJamegafilterContent->onBeforeDisplayContentItems()	Same as call in the line below.
    12	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT\components\com_jamegafilter\views\default\view.html.php:67
    9	JaMegaFilterViewDefault->display()	JROOT\libraries\legacy\controller\legacy.php:671
    8	JControllerLegacy->display()	JROOT\libraries\legacy\controller\legacy.php:709
    7	JControllerLegacy->execute()	JROOT\components\com_jamegafilter\jamegafilter.php:28
    6	require_once JROOT\components\com_jamegafilter\jamegafilter.php	JROOT\libraries\cms\component\helper.php:389
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

22. Query Time: 15.60 ms Query memory: 0.025 MB Memory before query: 23.734 MB Rows returned: 7
    Duplicate queries: #24

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM n_modules AS m
    
      LEFT JOIN n_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN n_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 <= '2019-11-20 00:06:47') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-20 00:06:47') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 3281 OR mm.menuid <= 0) 
      AND m.language IN ('th-TH','*')
    
      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	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	176	0.42	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	nsm.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	nsm.m.id	22	40.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
    17	JCacheControllerCallback->get()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:442
    16	JModuleHelper::getModuleList()	JROOT\administrator\components\com_jamegafilter\helper.php:51
    15	JaMegafilterHelper::hasMegafilterModule()	JROOT\plugins\jamegafilter\content\tmpl\default.php:38
    14	include JROOT\plugins\jamegafilter\content\tmpl\default.php	JROOT\plugins\jamegafilter\content\content.php:45
    13	plgJamegafilterContent->onBeforeDisplayContentItems()	Same as call in the line below.
    12	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT\components\com_jamegafilter\views\default\view.html.php:67
    9	JaMegaFilterViewDefault->display()	JROOT\libraries\legacy\controller\legacy.php:671
    8	JControllerLegacy->display()	JROOT\libraries\legacy\controller\legacy.php:709
    7	JControllerLegacy->execute()	JROOT\components\com_jamegafilter\jamegafilter.php:28
    6	require_once JROOT\components\com_jamegafilter\jamegafilter.php	JROOT\libraries\cms\component\helper.php:389
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

23. Query Time: 15.60 ms Query memory: 0.014 MB Memory before query: 23.701 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\multilang.php:106
    9	JLanguageMultilang::getSiteHomePages()	JROOT\plugins\system\languagefilter\languagefilter.php:718
    8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

24. Query Time: 0.00 ms After last query: 15.60 ms Query memory: 0.024 MB Memory before query: 24.055 MB Rows returned: 7
    Duplicate queries: #22

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM n_modules AS m
    
      LEFT JOIN n_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN n_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 <= '2019-11-20 00:06:47') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-20 00:06:47') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 3281 OR mm.menuid <= 0) 
      AND m.language IN ('th-TH','*')
    
      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	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	176	0.42	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	nsm.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	nsm.m.id	22	40.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    17	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    16	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
    15	JCacheControllerCallback->get()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:442
    14	JModuleHelper::getModuleList()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:378
    13	JModuleHelper::load()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:84
    12	JModuleHelper::getModules()	JROOT\libraries\joomla\document\html.php:576
    11	JDocumentHtml->countModules()	JROOT\plugins\system\t3\includes\core\template.php:624
    10	T3Template->countModules()	JROOT\templates\ja_events_ii\tpls\default.php:17
    9	include JROOT\templates\ja_events_ii\tpls\default.php	JROOT\plugins\system\t3\includes\core\template.php:221
    8	T3Template->loadLayout()	JROOT\templates\ja_events_ii\index.php:33
    7	require JROOT\templates\ja_events_ii\index.php	JROOT\libraries\joomla\document\html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:530
    4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1102
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

25. Query Time: 0.00 ms After last query: 15.60 ms Query memory: 0.025 MB Memory before query: 24.183 MB Rows returned: 71

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `n_assets`
    
      WHERE `name` IN ('root.1','com_acymailing','com_acysms','com_admin','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativeimageslider','com_csvi','com_customfilters','com_dpcalendar','com_dropeditor','com_dropfiles','com_droppics','com_droptables','com_easytimetable','com_eventbooking','com_extplorer','com_fields','com_fieldsandfilters','com_finder','com_fwgallerylight','com_installer','com_j2xml','com_jabuilder','com_jaextmanager','com_jamegafilter','com_jce','com_jedchecker','com_jevents','com_jmap','com_joomlaupdate','com_jotcache','com_kunena','com_languages','com_linkchecker','com_login','com_lps','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_nextend2','com_offlajn_installer','com_phocacommander','com_phocagallery','com_plugins','com_postinstall','com_profiles','com_redirect','com_search','com_smartslider3','com_tags','com_tcpdf','com_teamchart','com_templates','com_users','com_vquiz','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	n_assets	NULL	range	idx_asset_name	idx_asset_name	152	NULL	72	100.00	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\access\access.php:427
    16	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:211
    15	JAccess::preload()	JROOT\libraries\joomla\access\access.php:529
    14	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:181
    13	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
    12	JUser->authorise()	JROOT\plugins\system\jabuilder\helper.php:39
    11	JUBHelper->isRootUser()	JROOT\plugins\system\jabuilder\helper.php:43
    10	JUBHelper->isEditable()	JROOT\plugins\system\jabuilder\helper.php:47
    9	JUBHelper->inEditMode()	JROOT\plugins\system\jabuilder\jabuilder.php:123
    8	plgSystemJabuilder->onBeforeRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1106
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

26. Query Time: 0.00 ms After last query: 15.60 ms Query memory: 0.016 MB Memory before query: 24.353 MB Rows returned: 1
    Duplicate queries: #15

    SELECT *
    
      FROM n_template_styles
    
      WHERE `id` = '31'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1445
    11	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:729
    10	JTable->load()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:928
    9	plgSystemEF4_JMFramework->getTemplateName()	JROOT\plugins\system\ef4_jmframework\ef4_jmframework.php:479
    8	plgSystemEF4_JMFramework->onBeforeRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1106
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

27. Query Time: 0.00 ms After last query: 46.80 ms Query memory: 0.021 MB Memory before query: 24.838 MB Rows returned: 1

    SELECT * 
      FROM n_menu 
      WHERE id='3281'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1642
    12	JDatabaseDriver->loadObject()	JROOT\modules\mod_sclogin\helper.php:306
    11	modSCLoginHelper->getLoginRedirect()	JROOT\modules\mod_sclogin\mod_sclogin.php:25
    10	include JROOT\modules\mod_sclogin\mod_sclogin.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:199
    9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
    6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
    4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

28. Query Time: 0.00 ms After last query: 31.20 ms Query memory: 0.019 MB Memory before query: 25.731 MB Rows returned: 0

    SELECT alow_captcha
    
      FROM n_baforms_forms
    
      WHERE alow_captcha <> '0' 
      AND published = 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT\components\com_baforms\helpers\baforms.php:27
    14	baformsHelper::addStyle()	JROOT\plugins\system\baforms\baforms.php:39
    13	plgSystemBaforms->onBeforeCompileHead()	Same as call in the line below.
    12	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    9	JApplicationBase->triggerEvent()	JROOT\libraries\joomla\document\renderer\html\head.php:63
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT\libraries\joomla\document\renderer\html\head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT\libraries\joomla\document\html.php:486
    6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
    4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

29. Query Time: 0.00 ms Query memory: 0.020 MB Memory before query: 25.751 MB Rows returned: 0

    SELECT *
     
      FROM n_jmap_metainfo
     
      WHERE `linkurl` = 'http://nsm.or.th/about-science-square-museum/exhibition-science-square-museum/นิทรรศการที่เคยจัดแสดง.html'
     
      AND `published` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	n_jmap_metainfo	NULL	ref	published	published	1	const	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT\plugins\system\jmap\jmap.php:350
    13	plgSystemJMap->onBeforeCompileHead()	Same as call in the line below.
    12	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    9	JApplicationBase->triggerEvent()	JROOT\libraries\joomla\document\renderer\html\head.php:63
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT\libraries\joomla\document\renderer\html\head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT\libraries\joomla\document\html.php:486
    6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
    4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

30. Query Time: 0.00 ms After last query: 31.20 ms Query memory: 0.020 MB Memory before query: 26.909 MB Rows returned: 130

    SELECT * 
      FROM n_acymailing_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_acymailing\classes\cpanel.php:17
    12	cpanelClass->load()	JROOT\administrator\components\com_acymailing\helpers\helper.php:392
    11	acymailing_config()	JROOT\administrator\components\com_acymailing\helpers\helper.php:1369
    10	include_once JROOT\administrator\components\com_acymailing\helpers\helper.php	JROOT\plugins\system\regacymailing\regacymailing.php:21
    9	plgSystemRegacymailing->initAcy()	JROOT\plugins\system\regacymailing\regacymailing.php:145
    8	plgSystemRegacymailing->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1122
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
    1	JApplicationCms->execute()	JROOT\index.php:51

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

    ---

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
     FROM n_modules AS m
    
     LEFT JOIN n_modules_menu AS mm 
     ON mm.moduleid = m.id
    
     LEFT JOIN n_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
     FROM `n_extensions`

3. 2 × SELECT *
    
     FROM n_template_styles

4. 1 × SELECT language,id
    
     FROM `n_menu`

5. 1 × SELECT `session_id`
    
     FROM `n_session`

6. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
     FROM n_categories as c
    
     LEFT JOIN n_categories AS s 
     ON (s.lft < c.lft 
     AND s.rgt > c.rgt 
     AND c.language in ('th-TH','*')) OR (s.lft >= c.lft 
     AND s.rgt <= c.rgt)

7. 1 × SELECT `id`,`name`,`rules`,`parent_id`
    
     FROM `n_assets`

8. 1 × SELECT * 
     FROM n_menu

9. 1 × SELECT * 
     FROM n_acymailing_confi

10. 1 × SELECT *  
      FROM n_jmap_metainfo

11. 1 × SELECT alow_captcha
     
      FROM n_baforms_forms

12. 1 × select enabled 
      from n_extensions

13. 1 × SELECT *
     
      FROM `n_jamegafilter`

14. 1 × SELECT *
     
      FROM n_languages

15. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
     
      FROM n_extensions

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

17. 1 × SELECT `element`,`name`,`client_id`,`extension_id`
     
      FROM `n_extensions`

18. 1 × 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 n_menu AS m
     
      LEFT JOIN n_extensions AS e 
      ON m.component_id = e.extension_id

19. 1 × SELECT * 
      FROM n_acysms_confi

20. 1 × SELECT `data`
     
      FROM `n_session`

21. 1 × SELECT id, home, template, s.params
     
      FROM n_template_styles as s
     
      LEFT JOIN n_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

22. 1 × SELECT id, rules
     
      FROM `n_viewlevels