Single Family

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1781236168,
                "last": 1781236168,
                "now": 1781236169
            },
            "client": {
                "forwarded": "216.73.217.5"
            },
            "token": "2P7B3lzI4I9lKfBmGfCijsX3kPsZXQUQ"
        },
        "registry": {
            "current_theme": "red",
            "current_direction": "ltr",
            "current_key_sufix": "_red_ltr"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "pid": "67",
        "recent_properties_viewed": "67"
    }
}

Time

Memory

86 Queries Logged 38.08 ms

1. Query Time: 0.60 ms Query memory: 0.023 MB Memory before query: 1.037 MB Rows returned: 1

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'3763646164636434376230313639613737363934663862393534613330333331'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:832
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:392
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.64 ms After last query: 1.22 ms Query memory: 0.024 MB Memory before query: 1.084 MB Rows returned: 35

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	37	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.05 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.03 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.14 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.01 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

3. Query Time: 0.34 ms After last query: 0.79 ms Query memory: 0.021 MB Memory before query: 1.109 MB Rows returned: 7

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Explain

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

   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.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

4. Query Time: 0.44 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.122 MB Rows returned: 2

   SELECT b.id
   
     FROM jos_usergroups AS a
   
     LEFT JOIN jos_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.05 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.02 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.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
   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
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.77 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 1.144 MB Rows returned: 57

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	231	Using where; Using filesort

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.34 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.03 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
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 1.04 ms After last query: 5.51 ms Query memory: 0.028 MB Memory before query: 1.532 MB Rows returned: 13

   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 jos_menu AS m
   
     LEFT JOIN jos_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	25	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	osprealetate.m.component_id	1	Using where

   Profile

   Status	Duration
   Starting	0.21 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.01 ms
   init	0.07 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.21 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.03 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

7. Query Time: 0.70 ms After last query: 3.11 ms Query memory: 0.021 MB Memory before query: 1.641 MB Rows returned: 1

   SELECT `query`
   
     FROM jos_osrs_urls
   
     WHERE md5_key="66140cf0d3539ae75217b4cb99bf7b3c"

   Explain

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

   Profile

   Status	Duration
   Starting	0.14 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.12 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.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   10	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:813
   9	OspropertyRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1148
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.70 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.648 MB Rows returned: 3

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	func,const	1	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.07 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.05 ms
   Optimizing	0.03 ms
   Statistics	0.12 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.09 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.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
   10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
   9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
   8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.41 ms After last query: 1.56 ms Query memory: 0.021 MB Memory before query: 1.813 MB Rows returned: 1

   Select count(id) 
     from jos_osrs_init 
     where `name` like 'import_city' 
     and `value` like '1'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_osrs_init	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	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.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.03 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/initosproperty/initosproperty.php:21
   8	plgSystemInitOSProperty->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.42 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 1.838 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    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.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 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.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 1.40 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 1.829 MB

    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"40484282be7e46b59b6f21054e56b19c\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    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.01 ms
    init for update	0.06 ms
    Updating	0.11 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.95 ms
    Query end	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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.46 ms After last query: 0.40 ms Query memory: 0.019 MB Memory before query: 1.849 MB Rows returned: 1

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

    Explain

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

    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.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	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
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.75 ms After last query: 5.59 ms Query memory: 0.020 MB Memory before query: 2.202 MB Rows returned: 1

    Select count(id) 
      from jos_osrs_configuration 
      where fieldname like 'integrate_membership'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_configuration	range	fieldname	fieldname	768	NULL	4	Using where; Using index

    Profile

    Status	Duration
    Starting	0.25 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.04 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 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
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    8	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/libraries/libraries.php:22
    7	OSLibraries::checkMembership()	JROOT/components/com_osproperty/osproperty.php:45
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.41 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 2.207 MB

    UPDATE jos_osrs_configuration 
      SET fieldvalue = '0' 
      WHERE fieldname LIKE 'integrate_membership'

    Explain

    EXPLAIN not possible on query: UPDATE jos_osrs_configuration SET fieldvalue = '0' WHERE fieldname LIKE 'integrate_membership'

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.03 ms
    Updating	0.05 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.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
    8	JDatabaseDriverMysqli->execute()	JROOT/components/com_osproperty/helpers/libraries/libraries.php:25
    7	OSLibraries::checkMembership()	JROOT/components/com_osproperty/osproperty.php:45
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.67 ms After last query: 0.61 ms Query memory: 0.051 MB Memory before query: 2.284 MB Rows returned: 431
    Duplicate queries: #18

    Select * 
      from jos_osrs_configuration

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.31 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.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    7	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/osproperty.php:57
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.37 ms After last query: 0.43 ms Query memory: 0.020 MB Memory before query: 2.534 MB Rows returned: 1
    Duplicate queries: #19  #32

    Select * 
      from jos_osrs_currencies 
      where id = '57'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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
    8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    7	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/osproperty.php:68
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 2.543 MB Rows returned: 0
    Duplicate queries: #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 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.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	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
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    7	OSPHelper::getLanguages()	JROOT/components/com_osproperty/osproperty.php:80
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.64 ms After last query: 0.14 ms Query memory: 0.052 MB Memory before query: 2.549 MB Rows returned: 431
    Duplicate queries: #15

    Select * 
      from jos_osrs_configuration

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.03 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.33 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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:27
    8	OSPHelper::loadConfig()	JROOT/components/com_osproperty/helpers/helper.php:950
    7	OSPHelper::loadBootstrap()	JROOT/components/com_osproperty/osproperty.php:88
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.31 ms After last query: 0.40 ms Query memory: 0.021 MB Memory before query: 2.807 MB Rows returned: 1
    Duplicate queries: #16  #32

    Select * 
      from jos_osrs_currencies 
      where id = '57'

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    Sending data	0.01 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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    9	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:38
    8	OSPHelper::loadConfig()	JROOT/components/com_osproperty/helpers/helper.php:950
    7	OSPHelper::loadBootstrap()	JROOT/components/com_osproperty/osproperty.php:88
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 2.71 ms After last query: 0.53 ms Query memory: 0.051 MB Memory before query: 2.366 MB Rows returned: 431

    SELECT * 
      FROM jos_osrs_configuration

    Explain

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

    Profile

    Status	Duration
    Starting	0.09 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.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.38 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
    8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    7	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/osproperty.php:119
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.37 ms After last query: 0.66 ms Query memory: 0.021 MB Memory before query: 2.415 MB Rows returned: 1
    Duplicate queries: #66

    Select * 
      from jos_osrs_themes 
      where published = '1'

    Explain

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

    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.01 ms
    init	0.03 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.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
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    8	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:4434
    7	OSPHelper::loadThemeStyle()	JROOT/components/com_osproperty/osproperty.php:214
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.36 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 2.419 MB Rows returned: 1

    Select count(id) 
      from jos_osrs_categories 
      where id = '12' 
      and published = '1'  
      and `access` IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_categories	const	PRIMARY,access,published	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.05 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.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/category.php:110
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.33 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 2.424 MB Rows returned: 1

    Select * 
      from jos_osrs_categories 
      where id = '12' 
      and published = '1'  
      and `access` IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_categories	const	PRIMARY,access,published	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 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.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    9	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/category.php:115
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.30 ms After last query: 0.89 ms Query memory: 0.024 MB Memory before query: 2.435 MB Rows returned: 1

    Select * 
      from jos_osrs_categories 
      where id = '12'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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:1662
    16	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:126
    15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/category.php:124
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.46 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 2.446 MB Rows returned: 0
    Duplicate queries: #17  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 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.09 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    17	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    16	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/router.php:127
    15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/category.php:124
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 2.455 MB Rows returned: 0
    Duplicate queries: #17  #25  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    17	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    16	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/router.php:128
    15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/category.php:124
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.37 ms After last query: 1.07 ms Query memory: 0.024 MB Memory before query: 2.528 MB Rows returned: 1

    SELECT COUNT(id)
    
      FROM jos_osrs_urls
    
      WHERE md5_key like "66140cf0d3539ae75217b4cb99bf7b3c"

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.08 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:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:784
    15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/category.php:124
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.31 ms After last query: 0.34 ms Query memory: 0.022 MB Memory before query: 2.535 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    10	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    9	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/classes/category.php:127
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.44 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 2.538 MB Rows returned: 0

    select * 
      from jos_osrs_categories 
      where published = '1' 
      and parent_id = '12'  
      and `access` IN (1,1,5) 
      order by ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_categories	ref|filter	parent_id,access,published	parent_id|published	5|2	const	1 (80%)	Using where; Using filesort; Using rowid filter

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.11 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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
    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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/category.php:136
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.31 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 2.546 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    11	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    10	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/classes/category.html.php:56
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.30 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 2.552 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    11	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    10	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/classes/category.html.php:74
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.33 ms After last query: 1.21 ms Query memory: 0.022 MB Memory before query: 2.575 MB Rows returned: 1
    Duplicate queries: #16  #19

    Select * 
      from jos_osrs_currencies 
      where id = '57'

    Explain

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

    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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:2959
    12	OSPHelper::getConfig()	JROOT/components/com_osproperty/helpers/helper.php:2873
    11	OSPHelper::userOneState()	JROOT/components/com_osproperty/classes/listing.php:2732
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.32 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 2.610 MB Rows returned: 1

    SELECT count(id)
    
      FROM jos_osrs_states
    
      WHERE country_id = "194" 
      and published = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_states	ALL	country_id,published	NO INDEX KEY COULD BE USED	NULL	NULL	51	Using where

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:2881
    11	OSPHelper::userOneState()	JROOT/components/com_osproperty/classes/listing.php:2732
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.69 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 2.617 MB Rows returned: 1

    Select count(distinct a.id) 
      from jos_osrs_properties as a 
      INNER JOIN jos_osrs_agents as c 
      on c.id = a.agent_id 
      LEFT JOIN jos_osrs_types as d 
      on d.id = a.pro_type 
      INNER JOIN jos_osrs_countries as e 
      on e.id = a.country 
      LEFT JOIN jos_osrs_property_categories as g 
      on g.pid = a.id 
      WHERE 1=1 
      and a.access IN (1,1,5) 
      AND a.country = '194' 
      AND ( g.category_id = '12') 
      and a.published = '1' 
      and a.approved = '1'  
      AND ((a.publish_up is null or a.publish_up = '0000-00-00' or a.publish_up = '' or a.publish_up <= '2026-06-12') 
      AND (a.publish_down is null or a.publish_down = '0000-00-00' or a.publish_down = '' or a.publish_down >= '2026-06-12'))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,published,approved,access	published	2	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	osprealetate.a.agent_id	1	Using index
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	osprealetate.a.country	1	Using index
    1	SIMPLE	g	ref	pid,category_id	pid	5	osprealetate.a.id	1	Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.07 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:2841
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 2.13 ms After last query: 1.31 ms Query memory: 0.063 MB Memory before query: 2.708 MB Rows returned: 1

    Select a.*,c.name as agent_name,c.photo as agent_photo, c.mobile as agent_mobile, c.phone as agent_phone,c.email as agent_email, c.optin,d.id as typeid,d.type_name as type_name,e.country_name 
      from jos_osrs_properties as a 
      INNER JOIN jos_osrs_agents as c 
      on c.id = a.agent_id 
      LEFT JOIN jos_osrs_types as d 
      on d.id = a.pro_type 
      LEFT JOIN jos_osrs_countries as e 
      on e.id = a.country 
      LEFT JOIN jos_osrs_property_categories as g 
      on g.pid = a.id 
      WHERE 1=1 
      and a.access IN (1,1,5) 
      AND a.country = '194' 
      AND ( g.category_id = '12') 
      and a.published = '1' 
      and a.approved = '1'  
      AND ((a.publish_up is null or a.publish_up = '0000-00-00' or a.publish_up = '' or a.publish_up <= '2026-06-12') 
      AND (a.publish_down is null or a.publish_down = '0000-00-00' or a.publish_down = '' or a.publish_down >= '2026-06-12')) 
      GROUP BY a.id 
      ORDER BY a.price desc 
      LIMIT 0, 20

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY,published,approved,access	published	2	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	osprealetate.a.agent_id	1
    1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	osprealetate.a.pro_type	1	Using where
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	osprealetate.a.country	1	Using where
    1	SIMPLE	g	ref	pid,category_id	pid	5	osprealetate.a.id	1	Using where

    Profile

    Status	Duration
    Starting	0.10 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.06 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Creating tmp table	0.08 ms
    Sorting for group	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	1.13 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.17 ms
    Creating sort index	0.01 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.02 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:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3025
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.40 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.726 MB Rows returned: 0

    Select * 
      from jos_osrs_extra_fields 
      where published = '1'  
      and `access` IN (1,1,5) 
      and show_on_list = '1' 
      order by ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 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.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/common.php:3782
    11	HelperOspropertyCommon::getExtrafieldInList()	JROOT/components/com_osproperty/classes/listing.php:3028
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.30 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 2.734 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.03 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.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:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    12	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    11	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/classes/listing.php:3033
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.30 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.741 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    12	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    11	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/classes/listing.php:3035
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 2.745 MB Rows returned: 1
    Duplicate queries: #40

    Select count(id) 
      from jos_osrs_properties 
      where pro_alias like '1612-crockett-st' 
      and id <> '67'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_properties	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	62	Using where

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.11 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1912
    11	OSPHelper::generateAlias()	JROOT/components/com_osproperty/classes/listing.php:3038
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.30 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 2.751 MB Rows returned: 1
    Duplicate queries: #39

    Select count(id) 
      from jos_osrs_properties 
      where pro_alias like '1612-crockett-st' 
      and id <> '67'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_properties	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	62	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 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.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1912
    11	OSPHelper::generateAlias()	JROOT/components/com_osproperty/classes/listing.php:3040
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.41 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 2.760 MB Rows returned: 1

    SELECT id, category_name as category_name
    
      FROM jos_osrs_categories
    
      WHERE  1 = 1 
      and `access` IN (1,1,5) 
      and id in (Select category_id 
      from jos_osrs_property_categories 
      where pid ="67")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<subquery2>	ALL	distinct_key	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	PRIMARY	jos_osrs_categories	eq_ref	PRIMARY,access	PRIMARY	4	osprealetate.jos_osrs_property_categories.category_id	1	Using where
    2	MATERIALIZED	jos_osrs_property_categories	ref	pid,category_id	pid	5	const	1	Using where

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:3154
    11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3046
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.767 MB Rows returned: 1

    Select fieldvalue 
      from jos_osrs_configuration 
      where fieldname like 'default_itemid'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_configuration	range	fieldname	fieldname	768	NULL	8	Using index condition

    Profile

    Status	Duration
    Starting	0.02 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.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:31
    12	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/helper.php:3160
    11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3046
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.36 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 2.778 MB Rows returned: 0

    SELECT id
    
      FROM jos_menu
    
      WHERE link LIKE "%index.php?option=com_osproperty%" 
      and (  `link` LIKE "%category_listing%" or   `link` LIKE "%lcategory%" ) 
      AND published = 1  
      and id in (101,159,127,129,133,134) 
      AND `access` IN (1,1,5)
    
      ORDER BY access

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_menu	range	PRIMARY	PRIMARY	4	NULL	6	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.04 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:405
    12	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/helper.php:3160
    11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3046
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.33 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 2.780 MB Rows returned: 1

    SELECT category_name
    
      FROM jos_osrs_categories
    
      WHERE  1 = 1 
      and `access` IN (1,1,5) 
      and id in (Select category_id 
      from jos_osrs_property_categories 
      where pid ="67")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<subquery2>	ALL	distinct_key	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	PRIMARY	jos_osrs_categories	eq_ref	PRIMARY,access	PRIMARY	4	osprealetate.jos_osrs_property_categories.category_id	1	Using where
    2	MATERIALIZED	jos_osrs_property_categories	ref	pid,category_id	pid	5	const	1	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.04 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_osproperty/helpers/helper.php:3132
    11	OSPHelper::getCategoryNamesOfProperty()	JROOT/components/com_osproperty/classes/listing.php:3049
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.31 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 2.786 MB Rows returned: 0

    SELECT *
    
      FROM jos_osrs_property_open
    
      WHERE pid='67' 
      and end_to > '2026-06-12 03:49:29'
    
      ORDER BY start_from

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 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.01 ms
    init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.03 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.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3067
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.28 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 2.792 MB Rows returned: 0

    Select * 
      from jos_osrs_comments 
      where pro_id = '67' 
      and published = '1' 
      order by created_on desc

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/listing.php:3090
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.26 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 2.798 MB Rows returned: 1

    select count(id) 
      from jos_osrs_photos 
      where pro_id = '67'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_photos	ref	pro_id	pro_id	5	const	18	Using index

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:3114
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.29 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 2.804 MB Rows returned: 1

    select image 
      from jos_osrs_photos 
      where pro_id = '67' 
      order by ordering 
      limit 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_photos	ref	pro_id	pro_id	5	const	18	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:3118
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.810 MB Rows returned: 18

    Select * 
      from jos_osrs_photos 
      where pro_id = '67'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_photos	ref	pro_id	pro_id	5	const	18

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 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.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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3138
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.26 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 2.831 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    12	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:1530
    11	OSPHelper::loadSateName()	JROOT/components/com_osproperty/classes/listing.php:3151
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.46 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 2.835 MB Rows returned: 1

    Select state_name 
      from jos_osrs_states 
      where id = '44'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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.04 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1541
    11	OSPHelper::loadSateName()	JROOT/components/com_osproperty/classes/listing.php:3151
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.27 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 2.844 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    13	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:1549
    12	OSPHelper::loadCountryName()	JROOT/components/com_osproperty/helpers/helper.php:5564
    11	OSPHelper::getCountryName()	JROOT/components/com_osproperty/classes/listing.php:3156
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.23 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.849 MB Rows returned: 1

    Select * 
      from jos_osrs_countries 
      where id = '194'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:1552
    12	OSPHelper::loadCountryName()	JROOT/components/com_osproperty/helpers/helper.php:5564
    11	OSPHelper::getCountryName()	JROOT/components/com_osproperty/classes/listing.php:3156
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.24 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 2.855 MB Rows returned: 1

    Select count(id) 
      from jos_osrs_comments 
      where pro_id = '67'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.01 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:3185
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.31 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 2.866 MB Rows returned: 26

    Select id as value,type_name as text 
      from jos_osrs_types 
      where published = '1' 
      order by ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_types	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	24	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.02 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.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3230
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.34 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 2.888 MB Rows returned: 4

    Select * 
      from jos_osrs_categories 
      where published = '1' 
      order by ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_categories	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:3021
    11	OSPHelper::checkboxesCategory()	JROOT/components/com_osproperty/classes/listing.php:3235
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 2.900 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #58  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    13	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    12	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/helpers/helper.php:3031
    11	OSPHelper::checkboxesCategory()	JROOT/components/com_osproperty/classes/listing.php:3235
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.26 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 2.907 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #59  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    13	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    12	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/helpers/helper.php:3031
    11	OSPHelper::checkboxesCategory()	JROOT/components/com_osproperty/classes/listing.php:3235
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.28 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 2.914 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #60  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    13	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    12	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/helpers/helper.php:3031
    11	OSPHelper::checkboxesCategory()	JROOT/components/com_osproperty/classes/listing.php:3235
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 2.921 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #61  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    13	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    12	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/helpers/helper.php:3031
    11	OSPHelper::checkboxesCategory()	JROOT/components/com_osproperty/classes/listing.php:3235
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 2.925 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #62  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Query end	0.02 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:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    12	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/common.php:88
    11	HelperOspropertyCommon::makeCountryList()	JROOT/components/com_osproperty/classes/listing.php:3239
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.54 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 2.931 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #64  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    12	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/common.php:172
    11	HelperOspropertyCommon::makeStateList()	JROOT/components/com_osproperty/classes/listing.php:3242
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.45 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 2.936 MB Rows returned: 51

    Select id as value,state_name as text, state_name 
      from jos_osrs_states 
      where published = 1  
      and country_id = '194' 
      order by state_name

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_states	ALL	country_id,published	NO INDEX KEY COULD BE USED	NULL	NULL	51	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.12 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/common.php:192
    11	HelperOspropertyCommon::makeStateList()	JROOT/components/com_osproperty/classes/listing.php:3242
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.27 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 2.946 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #77  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    12	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/common.php:228
    11	HelperOspropertyCommon::loadCity()	JROOT/components/com_osproperty/classes/listing.php:3249
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.41 ms After last query: 0.48 ms Query memory: 0.027 MB Memory before query: 2.997 MB Rows returned: 0

    Select a.id as value, a.name as text 
      from jos_osrs_agents as a 
      inner join jos_users as b 
      on b.id = a.user_id 
      where a.published = '1'   
      order by a.name

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	published	published	2	const	1	Using where; Using filesort
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	osprealetate.a.user_id	1	Using index

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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.05 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.03 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3294
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.27 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 3.011 MB Rows returned: 1
    Duplicate queries: #21

    Select * 
      from jos_osrs_themes 
      where published = '1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:4478
    13	OSPHelper::getThemeName()	JROOT/components/com_osproperty/classes/template.class.php:27
    12	OspropertyTemplate->OspropertyTemplate()	JROOT/components/com_osproperty/classes/listing.html.php:746
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.25 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 3.021 MB Rows returned: 1

    Select * 
      from jos_osrs_themes 
      where name like 'theme3'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 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.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/listing.html.php:834
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.38 ms After last query: 2.10 ms Query memory: 0.026 MB Memory before query: 3.070 MB Rows returned: 58

    Select id as value, currency_code as text 
      from jos_osrs_currencies 
      where id <> '' 
      order by currency_code

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_currencies	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	58	Using where; Using filesort

    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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.07 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:82
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 0.48 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.111 MB Rows returned: 1

    Select a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id 
      from jos_osrs_properties as a 
      inner join jos_osrs_agents as b 
      on b.id = a.agent_id 
      left join jos_osrs_company_agents as c 
      on c.agent_id = b.id 
      where a.id = '67'

    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	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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.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.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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/route.php:74
    14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:658
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 0.40 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 3.121 MB Rows returned: 1

    SELECT category_id
    
      FROM jos_osrs_property_categories
    
      WHERE pid="67"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_property_categories	ref	pid	pid	5	const	1

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 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:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_osproperty/helpers/helper.php:3111
    15	OSPHelper::getCategoryIdsOfProperty()	JROOT/components/com_osproperty/helpers/route.php:85
    14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:658
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

71. Query Time: 0.34 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 3.128 MB Rows returned: 0

    Select id 
      from jos_menu 
      where published = '1' 
      and ((`link` like '%view=ldetails&id=67%') or (`link` like '%view=ldetails&ampid=67%'))  
      and `access` IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.09 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:104
    14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:658
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

72. Query Time: 0.37 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 3.136 MB Rows returned: 2

    Select * 
      from jos_menu 
      where published = '1' 
      and `home` = '0' 
      and `link` like '%view=ltype%'  
      and `access` IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.11 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/route.php:110
    14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:658
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

73. Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 3.149 MB Rows returned: 1

    Select count(id) 
      from jos_menu 
      where published = '1' 
      and `home` = '0' 
      and `link` like '%view=ltype%'  
      and id = '133'

    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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:127
    14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:658
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

74. Query Time: 0.25 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 3.156 MB Rows returned: 2

    Select id 
      from jos_menu 
      where published = '1' 
      and `home` = '0' 
      and `link` like '%view=ltype%'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.05 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:132
    14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:658
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

75. Query Time: 0.26 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 3.159 MB Rows returned: 1

    Select count(id) 
      from jos_menu 
      where id = '127' 
      and published = '1' 
      and (`link` like '%view=ldetails%' 
      and `link` like '%id=67%')  
      and `access` IN (1,1,5)

    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.03 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:539
    21	OSPRoute::checkDirectPropertyLink()	JROOT/components/com_osproperty/router.php:318
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:668
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

76. Query Time: 0.38 ms After last query: 0.03 ms Query memory: 0.067 MB Memory before query: 3.169 MB Rows returned: 1

    Select * 
      from jos_osrs_properties 
      where id = '67'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 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.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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:347
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:668
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

77. Query Time: 0.32 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 3.193 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #78  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.03 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.02 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    22	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    21	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/router.php:348
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:668
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

78. Query Time: 0.26 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 3.204 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #81  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    22	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    21	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/router.php:349
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:668
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

79. Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 3.215 MB Rows returned: 1

    SELECT COUNT(id)
    
      FROM jos_osrs_urls
    
      WHERE md5_key like "cdc6bc1b8fecd11082193674596bb79a"

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 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.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.07 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:784
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:668
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

80. Query Time: 0.26 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 3.213 MB Rows returned: 0

    Select * 
      from jos_osrs_categories 
      where id = ''

    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.03 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.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 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.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:126
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:699
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

81. Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 3.225 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #82

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    22	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    21	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/router.php:127
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:699
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

82. Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 3.236 MB Rows returned: 0
    Duplicate queries: #17  #25  #26  #28  #30  #31  #37  #38  #50  #52  #57  #58  #59  #60  #61  #62  #64  #77  #78  #81

    SELECT lang_id, lang_code, title, `sef`
    
      FROM jos_languages
    
      WHERE published = 1 
      AND lang_code != "en-GB"
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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
    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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:330
    22	OSPHelper::getLanguages()	JROOT/components/com_osproperty/helpers/helper.php:371
    21	OSPHelper::getLanguageFieldValue()	JROOT/components/com_osproperty/router.php:128
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:699
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

83. Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 3.248 MB Rows returned: 1

    SELECT COUNT(id)
    
      FROM jos_osrs_urls
    
      WHERE md5_key like "d41d8cd98f00b204e9800998ecf8427e"

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.07 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    21	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:784
    20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:699
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

84. Query Time: 0.22 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 3.255 MB Rows returned: 1

    Select currency_symbol 
      from jos_osrs_currencies 
      where id = '57'

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/common.php:1533
    15	HelperOspropertyCommon::loadCurrency()	JROOT/components/com_osproperty/helpers/helper.php:2643
    14	OSPHelper::generatePrice()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:707
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

85. Query Time: 0.25 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 3.264 MB Rows returned: 1

    Select fieldvalue 
      from jos_osrs_configuration 
      where fieldname like 'general_currency_money_format'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_osrs_configuration	range	fieldname	fieldname	768	NULL	37	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 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.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.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/common.php:659
    15	HelperOspropertyCommon::showPrice()	JROOT/components/com_osproperty/helpers/helper.php:2643
    14	OSPHelper::generatePrice()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:707
    13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:123
    12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:865
    11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3304
    10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/category.html.php:181
    9	HTML_OspropertyCategories::categoryDetailsForm()	JROOT/components/com_osproperty/classes/category.php:148
    8	OspropertyCategories::categoryDetails()	JROOT/components/com_osproperty/classes/category.php:31
    7	OspropertyCategories::display()	JROOT/components/com_osproperty/osproperty.php:240
    6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

86. Query Time: 1.05 ms After last query: 7.55 ms Query memory: 0.027 MB Memory before query: 3.357 MB Rows returned: 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-06-12 03:49:29') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-12 03:49:29') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 133 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published	published	5	NULL	13	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	osprealetate.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	func,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.21 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.21 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.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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
    16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:655
    12	T3Template->countModules()	JROOT/templates/osprealestate/tpls/blocks/header.php:22
    11	include JROOT/templates/osprealestate/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/osprealestate/tpls/default.php:32
    9	include JROOT/templates/osprealestate/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/osprealestate/index.php:39
    7	require JROOT/templates/osprealestate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---