Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1739833801,
                "last": 1739833801,
                "now": 1739833801
            },
            "client": {
                "forwarded": "18.218.251.99"
            },
            "token": "LMCqhFIlkeJaeSskxMHYKPskZz1jJPXQ"
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "formtime": 1739833802
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Time

Memory

15 Queries Logged 21.03 ms

1. Query Time: 0.86 ms Query memory: 0.008 MB Memory before query: 2.876 MB

   DELETE 
   
     FROM `test_session`
   
     WHERE `time` < '1730833801'

   Explain

   EXPLAIN not possible on query: DELETE FROM `test_session` WHERE `time` < '1730833801'

   Profile

   Status	Duration
   Starting	0.20 ms
   checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.15 ms
   Updating	0.06 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:772
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
   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.62 ms After last query: 0.24 ms Query memory: 0.012 MB Memory before query: 2.889 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `test_session`
   
     WHERE `session_id` = 'dd501ac9c95dfa44fdc20f843475396f' 
     LIMIT 0, 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	test_session	const	PRIMARY	PRIMARY	575	const	1	Using index

   Profile

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.02 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:781
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
   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.57 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 2.902 MB

   INSERT INTO `test_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('dd501ac9c95dfa44fdc20f843475396f', 0, '1739833801')

   Explain

   EXPLAIN not possible on query: INSERT INTO `test_session` (`session_id`, `client_id`, `time`) VALUES ('dd501ac9c95dfa44fdc20f843475396f', 0, '1739833801')

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init for update	0.03 ms
   Update	0.10 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.12 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:209
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:781
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
   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: 1.08 ms After last query: 9.39 ms Query memory: 0.014 MB Memory before query: 3.426 MB Rows returned: 2

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.20 ms
   checking permissions	0.05 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.03 ms
   table lock	0.02 ms
   init	0.06 ms
   Optimizing	0.04 ms
   Statistics	0.14 ms
   Preparing	0.02 ms
   Unlocking tables	0.02 ms
   Preparing	0.06 ms
   Executing	0.02 ms
   Sending data	0.06 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
   9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
   8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   1	JApplicationCms->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.60 ms After last query: 1.14 ms Query memory: 0.013 MB Memory before query: 3.482 MB Rows returned: 5

   SELECT id, rules
   
     FROM `test_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   Sending data	0.05 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
   8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   1	JApplicationCms->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.05 ms After last query: 5.67 ms Query memory: 0.013 MB Memory before query: 3.839 MB Rows returned: 24

   SELECT element
   
     FROM test_extensions
   
     WHERE type = 'language' 
     AND client_id = 0 
     AND enabled = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	test_extensions	ref	extension	extension	62	const	48	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.18 ms
   checking permissions	0.05 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.06 ms
   Optimizing	0.05 ms
   Statistics	0.09 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.14 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
   7	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:72
   6	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   5	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 8.48 ms After last query: 27.12 ms Query memory: 0.141 MB Memory before query: 5.282 MB Rows returned: 706

   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 test_menu AS m
   
     LEFT JOIN test_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	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	841	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	betlux5_php16.m.component_id	1	Using where

   Profile

   Status	Duration
   Starting	0.23 ms
   checking permissions	0.05 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.07 ms
   Optimizing	0.05 ms
   Statistics	0.12 ms
   Preparing	0.07 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.04 ms
   Creating sort index	7.18 ms
   End of update loop	0.10 ms
   Query end	0.05 ms
   Commit	0.03 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   closing tables	0.03 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   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:133
   16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:442
   15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:538
   11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
   9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   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:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.98 ms After last query: 80.87 ms Query memory: 0.032 MB Memory before query: 13.206 MB Rows returned: 1

   SELECT `params` 
     FROM test_extensions 
     WHERE `element`='com_sh404sef' 
     AND `type`='component';

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	test_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.05 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.10 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.16 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.03 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   16	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
   15	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
   14	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
   13	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:132
   12	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:612
   11	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
   10	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:83
   9	plgSystemSh404sef->onAfterInitialise()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   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:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   1	JApplicationCms->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.71 ms After last query: 20.71 ms Query memory: 0.020 MB Memory before query: 14.278 MB Rows returned: 0

   SELECT `id`,`alias`,`newurl`,`hits` 
     FROM `test_sh404sef_aliases` 
     WHERE `alias` = 'led-en/component/com_mailto/link,4be5d7e747e549a7865f4b3714cd8db8b2429fcd/template,ja_rent/tmpl,component' 
     order by `alias` desc

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

   Status	Duration
   Starting	0.18 ms
   checking permissions	0.05 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
   13	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
   12	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:592
   11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:249
   10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
   8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
   7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:219
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.56 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 14.296 MB Rows returned: 0

    SELECT * 
      FROM test_sh404sef_pageids 
      WHERE `pageid`='led-en/component/com_mailto/link,4be5d7e747e549a7865f4b3714cd8db8b2429fcd/template,ja_rent/tmpl,component';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_sh404sef_pageids	ref	alias	alias	767	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.14 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
    14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
    13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:1863
    11	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:250
    10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
    8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
    7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:219
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.96 ms After last query: 21.78 ms Query memory: 0.012 MB Memory before query: 15.433 MB

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.15 ms
    Updating	0.12 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.12 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    1	JApplicationCms->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.60 ms After last query: 17.32 ms Query memory: 0.015 MB Memory before query: 16.554 MB Rows returned: 23

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	882	Using where

    Profile

    Status	Duration
    Starting	0.18 ms
    checking permissions	0.06 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.72 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:610
    8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.88 ms After last query: 4.35 ms Query memory: 0.018 MB Memory before query: 16.767 MB Rows returned: 0

    SELECT `pageid` 
      FROM test_sh404sef_pageids 
      WHERE `newurl`='index.php?option=com_mailto&lang=led-en&link=4be5d7e747e549a7865f4b3714cd8db8b2429fcd&template=ja_rent&tmpl=component';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_sh404sef_pageids	ref	newurl	newurl	767	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.20 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
    12	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
    11	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
    10	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
    9	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:214
    8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    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:264
    1	JApplicationCms->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.47 ms After last query: 7.91 ms Query memory: 0.030 MB Memory before query: 17.384 MB Rows returned: 36

    SHOW FULL COLUMNS 
      FROM `test_sh404sef_metas`

    Explain

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

    Profile

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.05 ms
    closing tables	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.29 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	0.19 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Removing tmp table	0.10 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    16	JTable->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
    15	Sh404sefTableMetas->__construct()	JROOT/libraries/joomla/table/table.php:305
    14	JTable::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:33
    13	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89
    12	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:114
    11	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:159
    10	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:213
    9	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.61 ms After last query: 1.80 ms Query memory: 0.032 MB Memory before query: 17.503 MB Rows returned: 0

    SELECT * 
      FROM test_sh404sef_metas 
      WHERE `newurl`='index.php?option=com_mailto&lang=led-en&link=4be5d7e747e549a7865f4b3714cd8db8b2429fcd&template=ja_rent&tmpl=component';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
    16	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
    15	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    14	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:34
    13	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89
    12	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:114
    11	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:159
    10	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:213
    9	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    8	plgSystemSh404sef->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 1 × SELECT * 
     FROM test_sh404sef_pageids

2. 1 × SELECT language,id 
     FROM `test_menu`

3. 1 × SELECT `pageid` 
     FROM test_sh404sef_pageids

4. 1 × SELECT * 
     FROM test_sh404sef_metas

5. 1 × SELECT `id`,`alias`,`newurl`,`hits` 
     FROM `test_sh404sef_aliases`

6. 1 × SELECT `params` 
     FROM test_extensions

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

8. 1 × SELECT id, rules 
     FROM `test_viewlevels

9. 1 × SELECT element 
     FROM test_extensions

10. 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 test_menu AS m 
      LEFT JOIN test_extensions AS e 
      ON m.component_id = e.extension_id

11. 1 × SELECT `session_id` 
      FROM `test_session`

OTHER Tables:

1. 1 × SHOW FULL COLUMNS 
     FROM `test_sh404sef_metas

2. 1 × UPDATE `test_extensions` 
     SET `params` = '{\"mediaversion\":\"f2c6d11c4c78d11042ecf1322b429ff6\"}'

3. 1 × INSERT INTO `test_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('dd501ac9c95dfa44fdc20f843475396f', 0, '1739833801'

4. 1 × DELETE  
     FROM `test_session`