{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1741914293,
                "last": 1741914293,
                "now": 1741914293
            },
            "client": {
                "forwarded": "18.223.162.245"
            }
        },
        "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
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Time

Memory

32 Queries Logged 203.52 ms

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

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.08 ms
   table lock	0.02 ms
   init for update	0.11 ms
   Updating	0.06 ms
   End of update loop	0.01 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.04 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 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.48 ms After last query: 0.27 ms Query memory: 0.012 MB Memory before query: 2.888 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `test_session`
   
     WHERE `session_id` = 'f3edd419291ea83d296d5f7a53b282cb' 
     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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.02 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.01 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 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.66 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 2.901 MB

   INSERT INTO `test_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('f3edd419291ea83d296d5f7a53b282cb', 0, '1741914293')

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.01 ms
   init for update	0.02 ms
   Update	0.18 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.13 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 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: 0.76 ms After last query: 90.00 ms Query memory: 0.014 MB Memory before query: 3.425 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.13 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.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.02 ms
   Unlocking tables	0.02 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 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.01 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
   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.58 ms After last query: 0.84 ms Query memory: 0.013 MB Memory before query: 3.481 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.06 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 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.01 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: 0.86 ms After last query: 5.21 ms Query memory: 0.013 MB Memory before query: 3.838 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.11 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   After opening tables	0.01 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.17 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.03 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
   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: 88.33 ms After last query: 199.01 ms Query memory: 0.141 MB Memory before query: 5.281 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.14 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.05 ms
   Statistics	0.07 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.05 ms
   Sending data	0.03 ms
   Creating sort index	87.34 ms
   End of update loop	0.07 ms
   Query end	0.03 ms
   Commit	0.01 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
   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.93 ms After last query: 407.65 ms Query memory: 0.032 MB Memory before query: 13.205 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.08 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.04 ms
   Statistics	0.08 ms
   Preparing	0.04 ms
   Executing	0.02 ms
   Sending data	0.21 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.04 ms
   Query end	0.02 ms
   Starting cleanup	0.02 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
   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.66 ms After last query: 101.81 ms Query memory: 0.020 MB Memory before query: 14.276 MB Rows returned: 0

   SELECT `id`,`alias`,`newurl`,`hits` 
     FROM `test_sh404sef_aliases` 
     WHERE `alias` = 'led-en/exhibit/2017-4-expoelectronics-moscow/print' 
     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.12 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.06 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.03 ms
   End of update loop	0.01 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.01 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.62 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 14.294 MB Rows returned: 0

    SELECT * 
      FROM test_sh404sef_pageids 
      WHERE `pageid`='led-en/exhibit/2017-4-expoelectronics-moscow/print';

    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.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.13 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.03 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.03 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: 88.12 ms Query memory: 0.026 MB Memory before query: 14.530 MB Rows returned: 1

    SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
      FROM test_sh404sef_urls 
      WHERE `oldurl`='led-en/exhibit/2017-4-expoelectronics-moscow/print' 
      ORDER BY `rank`;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_sh404sef_urls	ref	oldurl	oldurl	767	const	1	Using index condition; Using where; Using filesort

    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.03 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.02 ms
    Creating sort index	0.27 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:690
    18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:471
    17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
    16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
    15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1549
    14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1237
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2125
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
    11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
    9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
    8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:567
    7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:223
    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.]

    ---

12. Query Time: 0.80 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 14.557 MB

    UPDATE `test_sh404sef_urls` 
      SET `cpt`=252 
      WHERE `id`='11938' 
      AND `rank`=0;

    Explain

    EXPLAIN not possible on query: UPDATE `test_sh404sef_urls` SET `cpt`=252 WHERE `id`='11938' AND `rank`=0;

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.01 ms
    Waiting for table level lock	0.21 ms
    table lock	0.03 ms
    init for update	0.10 ms
    Updating	0.08 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.04 ms
    closing tables	0.03 ms
    Query end	0.01 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
    20	JDatabaseDriverMysqli->execute()	Same as call in the line below.
    19	call_user_func_array()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
    18	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:501
    17	ShlDbClass->execute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:501
    16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:489
    15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
    14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1252
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2125
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
    11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/cms/router/router.php:593
    9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:548
    8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:567
    7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:223
    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.]

    ---

13. Query Time: 0.90 ms After last query: 108.86 ms Query memory: 0.012 MB Memory before query: 15.662 MB

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init for update	0.09 ms
    Updating	0.10 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.21 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.04 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.01 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.]

    ---

14. Query Time: 0.71 ms After last query: 94.38 ms Query memory: 0.020 MB Memory before query: 16.547 MB Rows returned: 1

    SELECT a.rules
    
      FROM test_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.09 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 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.04 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.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:423
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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: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: 1.62 ms After last query: 0.76 ms Query memory: 0.021 MB Memory before query: 16.599 MB Rows returned: 2

    SELECT b.rules
    
      FROM test_assets AS a
    
      LEFT JOIN test_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
    1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	17	Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Creating tmp table	0.10 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.34 ms
    Creating sort index	0.21 ms
    Removing tmp table	0.25 ms
    Creating sort index	0.03 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.01 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:423
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 1.27 ms After last query: 2.02 ms Query memory: 0.025 MB Memory before query: 16.686 MB Rows returned: 30

    SHOW FULL COLUMNS 
      FROM `test_content`

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    closing tables	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.23 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	0.15 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.12 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.01 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:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:425
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.72 ms After last query: 89.03 ms Query memory: 0.023 MB Memory before query: 17.060 MB Rows returned: 1

    SELECT *
    
      FROM test_content
    
      WHERE `id` = '853'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_content	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.08 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.03 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.01 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.04 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
    10	JTable->load()	JROOT/components/com_content/models/article.php:426
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.73 ms After last query: 0.38 ms Query memory: 0.014 MB Memory before query: 17.075 MB

    UPDATE test_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '853'

    Explain

    EXPLAIN not possible on query: UPDATE test_content SET `hits` = (`hits` + 1) WHERE `id` = '853'

    Profile

    Status	Duration
    Starting	0.07 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 for update	0.06 ms
    Updating	0.11 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.14 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.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
    10	JTable->hit()	JROOT/components/com_content/models/article.php:427
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 1.75 ms After last query: 7.52 ms Query memory: 0.029 MB Memory before query: 17.330 MB Rows returned: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM test_content AS a
    
      LEFT JOIN test_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN test_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN test_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN test_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM test_categories AS cat JOIN test_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.language in ('en-GB','*') 
      AND a.id = 853 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-14 01:04:54') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-14 01:04:54') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	2
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	28	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.25 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.14 ms
    Optimizing	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Statistics	0.14 ms
    Preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    Creating sort index	0.16 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    13	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 2.51 ms After last query: 90.20 ms Query memory: 0.028 MB Memory before query: 17.593 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM test_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM test_categories AS cat JOIN test_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN test_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('en-GB','*')) 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 badcats.id is null 
      AND s.id=24
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	betlux5_php16.c.id	5	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	28	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.25 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.13 ms
    Optimizing	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Statistics	0.13 ms
    Preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.08 ms
    Creating tmp table	0.16 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Executing	0.01 ms
    Sending data	0.15 ms
    Creating sort index	0.16 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.34 ms
    Creating sort index	0.09 ms
    Removing tmp table	0.17 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.05 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    12	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 2.02 ms After last query: 4.70 ms Query memory: 0.041 MB Memory before query: 17.695 MB Rows returned: 317

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

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

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    29	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    28	JDatabaseDriverMysqli->getTableList()	Same as call in the line below.
    27	call_user_func_array()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
    26	ShlSystem_Abstractdecorator->__call()	JROOT/administrator/components/com_sh404sef/helpers/language.php:323
    25	ShlDbClass->getTableList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:323
    24	Sh404sefHelperLanguage::getInstalledLanguagesList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:208
    23	Sh404sefHelperLanguage::validateSefLanguageCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1149
    22	Sh404sefClassRouterInternal->_fixUriLanguageVar()	JROOT/administrator/components/com_sh404sef/classes/router.php:1027
    21	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2130
    20	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:970
    19	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/cms/router/router.php:635
    17	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:609
    16	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:611
    15	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:269
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:134
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.98 ms After last query: 85.91 ms Query memory: 0.039 MB Memory before query: 17.790 MB Rows returned: 22

    SELECT * 
      FROM test_languages

    Explain

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

    Profile

    Status	Duration
    Starting	0.13 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.34 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.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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:690
    25	ShlDbClass->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:330
    24	Sh404sefHelperLanguage::getInstalledLanguagesList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:208
    23	Sh404sefHelperLanguage::validateSefLanguageCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1149
    22	Sh404sefClassRouterInternal->_fixUriLanguageVar()	JROOT/administrator/components/com_sh404sef/classes/router.php:1027
    21	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2130
    20	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:970
    19	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/cms/router/router.php:635
    17	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:609
    16	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:611
    15	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:269
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:134
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.69 ms After last query: 11.94 ms Query memory: 0.025 MB Memory before query: 18.409 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `test_contentitem_tag_map` AS m 
    
      INNER JOIN `test_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 853 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
    12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:96
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:686
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 1.02 ms After last query: 195.57 ms Query memory: 0.015 MB Memory before query: 19.413 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.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.46 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 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
    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.]

    ---

25. Query Time: 86.65 ms After last query: 3.24 ms Query memory: 0.016 MB Memory before query: 19.507 MB Rows returned: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `test_content` AS `c`
    
      INNER JOIN `test_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_content.item'
    
      INNER JOIN `test_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `test_content` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `test_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_content'
    
      WHERE c.id = 853

    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.14 ms
    checking permissions	0.02 ms
    Opening tables	0.09 ms
    After opening tables	0.02 ms
    System lock	0.04 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:46
    10	ContentHelperAssociation::getAssociations()	Same as call in the line below.
    9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:641
    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.]

    ---

26. Query Time: 0.75 ms After last query: 2.21 ms Query memory: 0.018 MB Memory before query: 19.541 MB Rows returned: 0

    SELECT `pageid` 
      FROM test_sh404sef_pageids 
      WHERE `newurl`='index.php?option=com_content&Itemid=730&catid=24&id=853&lang=led-en&layout=default&page=&print=1&tmpl=component&view=article';

    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.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.19 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---

27. Query Time: 0.60 ms After last query: 8.14 ms Query memory: 0.023 MB Memory before query: 19.928 MB Rows returned: 1

    SELECT `id`, `title`, `alias`, `catid`, `language` 
      FROM test_content 
      WHERE `id`=853;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_content	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 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.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
    15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
    14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
    12	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:661
    11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
    10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
    9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
    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.]

    ---

28. Query Time: 0.65 ms After last query: 2.26 ms Query memory: 0.028 MB Memory before query: 19.955 MB Rows returned: 0
    Duplicate queries: #29

    SELECT * 
      FROM test_categories 
      WHERE parent_id > 0 
      and extension = 'com_content' 
      and path = 'uncategorised' 
      and level = 1;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_categories	ref	cat_idx,idx_path	idx_path	302	const	4	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
    15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
    14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
    12	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:675
    11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
    10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
    9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
    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.]

    ---

29. Query Time: 0.82 ms After last query: 85.45 ms Query memory: 0.029 MB Memory before query: 19.976 MB Rows returned: 0
    Duplicate queries: #28

    SELECT * 
      FROM test_categories 
      WHERE parent_id > 0 
      and extension = 'com_content' 
      and path = 'uncategorised' 
      and level = 1;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	test_categories	ref	cat_idx,idx_path	idx_path	302	const	4	Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 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
    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/helpers/categories.php:40
    13	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/administrator/components/com_sh404sef/models/slugs.php:280
    12	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:682
    11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
    10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
    9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
    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.]

    ---

30. Query Time: 1.16 ms After last query: 0.42 ms Query memory: 0.029 MB Memory before query: 20.007 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM test_categories as c
    
      LEFT JOIN test_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND s.id=24
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

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

    Profile

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.11 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.30 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 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.03 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    15	JCategories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:161
    14	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:199
    13	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:290
    12	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:682
    11	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:144
    10	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:319
    9	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
    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.]

    ---

31. Query Time: 1.16 ms After last query: 3.20 ms Query memory: 0.030 MB Memory before query: 20.195 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.10 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.23 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    checking permissions	0.16 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.10 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 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.]

    ---

32. Query Time: 0.48 ms After last query: 1.61 ms Query memory: 0.032 MB Memory before query: 20.291 MB Rows returned: 0

    SELECT * 
      FROM test_sh404sef_metas 
      WHERE `newurl`='index.php?option=com_content&Itemid=730&catid=24&id=853&lang=led-en&layout=default&page=&print=1&tmpl=component&view=article';

    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.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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.]

    ---