List properties with tag [Mt Isola ]

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1773626071,
                "last": 1773626071,
                "now": 1773626071
            },
            "token": "WulmmNU0OHLiequuvMzejivfg3AFvtqb"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "advsearchresult": null,
        "btl_captcha_image_path": "NWQ1NWNmMmFiNDBjZDU4ZTMwYzQ5ZjZlMTEyYzUyN2IxNzczNjI2MDcy.png",
        "btl_captcha": "W1I27c"
    },
    "__easycalccheckplus": {
        "redirectUrl": null,
        "eccLoaded": null
    }
}

Time

Memory

514 Queries Logged 282.62 ms

1. Query Time: 0.52 ms Query memory: 0.023 MB Memory before query: 1.350 MB Rows returned: 0

   SELECT `data`
   
     FROM `yke_session`
   
     WHERE `session_id` = X'3564353563663261623430636435386533306334396636653131326335323762'

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.30 ms After last query: 2.40 ms Query memory: 0.020 MB Memory before query: 1.427 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `yke_session`
   
     WHERE `session_id` = X'3564353563663261623430636435386533306334396636653131326335323762' 
     LIMIT 1

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

   ---

3. Query Time: 1.03 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 1.432 MB

   INSERT INTO `yke_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3564353563663261623430636435386533306334396636653131326335323762', 1, 1773626071, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `yke_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3564353563663261623430636435386533306334396636653131326335323762', 1, 1773626071, 0, '', 0)

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

   ---

4. Query Time: 0.85 ms After last query: 5.00 ms Query memory: 0.025 MB Memory before query: 1.465 MB Rows returned: 41

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `yke_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	yke_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

   ---

5. Query Time: 0.42 ms After last query: 4.99 ms Query memory: 0.021 MB Memory before query: 1.494 MB Rows returned: 5

   SELECT id, rules
   
     FROM `yke_viewlevels`

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.43 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.506 MB Rows returned: 2

   SELECT b.id
   
     FROM yke_usergroups AS a
   
     LEFT JOIN yke_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using where; Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.00 ms After last query: 1.84 ms Query memory: 0.024 MB Memory before query: 1.527 MB Rows returned: 41

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM yke_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	yke_extensions	ref	extension	extension	82	const	116	Using index condition; Using where; Using filesort

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.38 ms After last query: 1.89 ms Query memory: 0.019 MB Memory before query: 1.543 MB Rows returned: 1

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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/Language/LanguageHelper.php:67
   4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.41 ms After last query: 28.63 ms Query memory: 0.021 MB Memory before query: 2.100 MB Rows returned: 2

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.73 ms After last query: 38.02 ms Query memory: 0.067 MB Memory before query: 2.220 MB Rows returned: 502
    Duplicate queries: #18  #21

    Select * 
      from yke_osrs_configuration

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/ospropertyplg/ospropertyplg.php:47
    8	plgSystemOspropertyplg->onAfterInitialise()	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:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.97 ms After last query: 6.28 ms Query memory: 0.069 MB Memory before query: 2.301 MB Rows returned: 39

    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 yke_menu AS m
    
      LEFT JOIN yke_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	57	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	nisekore_joom817.m.component_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->onAfterInitialise()	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:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.45 ms After last query: 23.30 ms Query memory: 0.021 MB Memory before query: 2.651 MB Rows returned: 1

    SELECT `query`
    
      FROM yke_osrs_urls
    
      WHERE md5_key="2aa6bcee6ef431ddf92ab40f7419987a"

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:897
    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:1142
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.46 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 2.659 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM yke_template_styles as s
    
      LEFT JOIN yke_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	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	nisekore_joom817.s.template,const	1	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.40 ms After last query: 5.72 ms Query memory: 0.025 MB Memory before query: 2.863 MB Rows returned: 1

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

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/osolcaptcha/osolcaptcha.php:243
    9	plgSystemOSOLCaptcha->adminOptionsForm()	JROOT/plugins/system/osolcaptcha/osolcaptcha.php:342
    8	plgSystemOSOLCaptcha->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.34 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 2.856 MB

    UPDATE `yke_extensions`
    
      SET `params` = '{\"mediaversion\":\"9d7a99079619d0ad71f746331089d83a\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/osolcaptcha/osolcaptcha.php:243
    9	plgSystemOSOLCaptcha->adminOptionsForm()	JROOT/plugins/system/osolcaptcha/osolcaptcha.php:342
    8	plgSystemOSOLCaptcha->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.64 ms After last query: 172.53 ms Query memory: 0.020 MB Memory before query: 3.646 MB Rows returned: 1

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

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:28
    7	OSLibraries::checkMembership()	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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.33 ms After last query: 0.05 ms Query memory: 0.005 MB Memory before query: 3.652 MB

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

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/components/com_osproperty/helpers/libraries/libraries.php:31
    7	OSLibraries::checkMembership()	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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.66 ms After last query: 2.05 ms Query memory: 0.067 MB Memory before query: 3.660 MB Rows returned: 502
    Duplicate queries: #10  #21

    Select * 
      from yke_osrs_configuration

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:69
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.34 ms After last query: 0.40 ms Query memory: 0.020 MB Memory before query: 3.898 MB Rows returned: 1
    Duplicate queries: #22  #43

    Select * 
      from yke_osrs_currencies 
      where id = '28'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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: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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.42 ms After last query: 0.09 ms Query memory: 0.020 MB Memory before query: 3.905 MB Rows returned: 0

    SELECT lang_id, lang_code, title, `sef`
    
      FROM yke_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	yke_languages	ALL	idx_langcode	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:367
    7	OSPHelper::getLanguages()	JROOT/components/com_osproperty/osproperty.php:92
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.64 ms After last query: 4.63 ms Query memory: 0.068 MB Memory before query: 3.916 MB Rows returned: 502
    Duplicate queries: #10  #18

    Select * 
      from yke_osrs_configuration

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:50
    8	OSPHelper::loadConfig()	JROOT/components/com_osproperty/helpers/helper.php:1002
    7	OSPHelper::loadBootstrap()	JROOT/components/com_osproperty/osproperty.php:100
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.27 ms After last query: 0.38 ms Query memory: 0.021 MB Memory before query: 4.208 MB Rows returned: 1
    Duplicate queries: #19  #43

    Select * 
      from yke_osrs_currencies 
      where id = '28'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:61
    8	OSPHelper::loadConfig()	JROOT/components/com_osproperty/helpers/helper.php:1002
    7	OSPHelper::loadBootstrap()	JROOT/components/com_osproperty/osproperty.php:100
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.78 ms After last query: 0.48 ms Query memory: 0.021 MB Memory before query: 3.961 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `yke_osrs_tags`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:90
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.66 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 3.967 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `yke_osrs_emails`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:102
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.68 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 3.972 MB Rows returned: 14

    SHOW FULL COLUMNS 
      FROM `yke_osrs_categories`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:114
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.64 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 3.978 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `yke_osrs_amenities`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:126
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.64 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 3.982 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `yke_osrs_fieldgroups`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:138
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.72 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 3.987 MB Rows returned: 23

    SHOW FULL COLUMNS 
      FROM `yke_osrs_extra_fields`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:151
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.63 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 3.994 MB Rows returned: 4

    SHOW FULL COLUMNS 
      FROM `yke_osrs_extra_field_options`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:163
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.65 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.997 MB Rows returned: 7

    SHOW FULL COLUMNS 
      FROM `yke_osrs_property_field_value`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:175
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.68 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.002 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `yke_osrs_types`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:188
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 1.16 ms After last query: 0.06 ms Query memory: 0.042 MB Memory before query: 4.007 MB Rows returned: 119

    SHOW FULL COLUMNS 
      FROM `yke_osrs_properties`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:200
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.76 ms After last query: 0.20 ms Query memory: 0.030 MB Memory before query: 4.031 MB Rows returned: 29

    SHOW FULL COLUMNS 
      FROM `yke_osrs_agents`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:232
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.71 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 4.027 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `yke_osrs_companies`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:244
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.62 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 4.032 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `yke_osrs_states`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:256
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.63 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.035 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `yke_osrs_cities`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:269
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.63 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.040 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `yke_osrs_countries`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    8	JDatabaseDriverMysqli->getTableColumns()	JROOT/components/com_osproperty/helpers/helper.php:281
    7	OSPHelper::isSyncronized()	JROOT/components/com_osproperty/osproperty.php:108
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.58 ms After last query: 0.22 ms Query memory: 0.067 MB Memory before query: 3.786 MB Rows returned: 502

    SELECT * 
      FROM yke_osrs_configuration

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:131
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.27 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 3.839 MB Rows returned: 1
    Duplicate queries: #159

    Select * 
      from yke_osrs_themes 
      where published = '1'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:4877
    7	OSPHelper::loadThemeStyle()	JROOT/components/com_osproperty/osproperty.php:226
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.25 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 3.841 MB Rows returned: 1

    Select keyword as keyword 
      from yke_osrs_tags 
      where id = '151'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/listing.php:2424
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.31 ms After last query: 1.63 ms Query memory: 0.024 MB Memory before query: 3.911 MB Rows returned: 1
    Duplicate queries: #183

    Select keyword 
      from yke_osrs_tags 
      where id = '151'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:446
    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/listing.php:2435
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.43 ms After last query: 1.87 ms Query memory: 0.024 MB Memory before query: 3.985 MB Rows returned: 1
    Duplicate queries: #184

    SELECT COUNT(id)
    
      FROM yke_osrs_urls
    
      WHERE md5_key like "2aa6bcee6ef431ddf92ab40f7419987a"

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:868
    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/listing.php:2435
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.25 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 3.991 MB Rows returned: 1
    Duplicate queries: #19  #22

    Select * 
      from yke_osrs_currencies 
      where id = '28'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:3068
    11	OSPHelper::getConfig()	JROOT/components/com_osproperty/helpers/helper.php:2982
    10	OSPHelper::userOneState()	JROOT/components/com_osproperty/classes/listing.php:2861
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.31 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.019 MB Rows returned: 1

    SELECT count(id)
    
      FROM yke_osrs_states
    
      WHERE country_id = "94" 
      and published = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	yke_osrs_states	ref	country_id,published	country_id	4	const	4	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:2990
    10	OSPHelper::userOneState()	JROOT/components/com_osproperty/classes/listing.php:2861
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 1.73 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.026 MB Rows returned: 1

    Select count(distinct a.id) 
      from yke_osrs_properties as a 
      INNER JOIN yke_osrs_agents as c 
      on c.id = a.agent_id 
      LEFT JOIN yke_osrs_types as d 
      on d.id = a.pro_type 
      INNER JOIN yke_osrs_countries as e 
      on e.id = a.country 
      LEFT JOIN yke_osrs_property_categories as g 
      on g.pid = a.id 
      WHERE 1=1 
      and a.access IN (1,1,5) 
      and a.id in (Select pid 
      from yke_osrs_tag_xref 
      where tag_id = '151') 
      and a.published = '1' 
      and a.approved = '1'  
      AND ((a.publish_up is null or  a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2026-03-16 01:54:32'  or a.publish_up = '0000-00-00') 
      AND (a.publish_down is null  or a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2026-03-16 01:54:32'  or a.publish_down = '0000-00-00'))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	PRIMARY	a	ref	PRIMARY,published,approved,access	published	2	const	140	Using where
    1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1
    1	PRIMARY	e	eq_ref	PRIMARY	PRIMARY	4	nisekore_joom817.a.country	1	Using index
    1	PRIMARY	g	ref	pid	pid	5	nisekore_joom817.a.id	1	Using index
    2	MATERIALIZED	yke_osrs_tag_xref	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	519	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:2958
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 2.70 ms After last query: 1.49 ms Query memory: 0.072 MB Memory before query: 4.116 MB Rows returned: 2

    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 yke_osrs_properties as a 
      INNER JOIN yke_osrs_agents as c 
      on c.id = a.agent_id 
      LEFT JOIN yke_osrs_types as d 
      on d.id = a.pro_type 
      LEFT JOIN yke_osrs_countries as e 
      on e.id = a.country 
      LEFT JOIN yke_osrs_property_categories as g 
      on g.pid = a.id 
      WHERE 1=1 
      and a.access IN (1,1,5) 
      and a.id in (Select pid 
      from yke_osrs_tag_xref 
      where tag_id = '151') 
      and a.published = '1' 
      and a.approved = '1'  
      AND ((a.publish_up is null or  a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2026-03-16 01:54:32'  or a.publish_up = '0000-00-00') 
      AND (a.publish_down is null  or a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2026-03-16 01:54:32'  or a.publish_down = '0000-00-00')) 
      GROUP BY a.id 
      ORDER BY a.created desc 
      LIMIT 0, 30

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
    1	PRIMARY	a	ref	PRIMARY,published,approved,access	published	2	const	140	Using where
    1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1
    1	PRIMARY	d	eq_ref	PRIMARY	PRIMARY	4	nisekore_joom817.a.pro_type	1	Using where
    1	PRIMARY	e	eq_ref	PRIMARY	PRIMARY	4	nisekore_joom817.a.country	1	Using where
    1	PRIMARY	g	ref	pid	pid	5	nisekore_joom817.a.id	1	Using index
    2	MATERIALIZED	yke_osrs_tag_xref	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	519	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3130
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.41 ms After last query: 0.08 ms Query memory: 0.030 MB Memory before query: 4.144 MB Rows returned: 14

    Select * 
      from yke_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	yke_osrs_extra_fields	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	27	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/common.php:3876
    10	HelperOspropertyCommon::getExtrafieldInList()	JROOT/components/com_osproperty/classes/listing.php:3133
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.78 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 4.172 MB Rows returned: 1
    Duplicate queries: #49

    Select count(id) 
      from yke_osrs_properties 
      where pro_alias like 'rusutsu-nobori-heights' 
      and id <> '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:2016
    10	OSPHelper::generateAlias()	JROOT/components/com_osproperty/classes/listing.php:3143
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.69 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.178 MB Rows returned: 1
    Duplicate queries: #48

    Select count(id) 
      from yke_osrs_properties 
      where pro_alias like 'rusutsu-nobori-heights' 
      and id <> '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:2016
    10	OSPHelper::generateAlias()	JROOT/components/com_osproperty/classes/listing.php:3145
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.41 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.187 MB Rows returned: 1

    SELECT id, category_name as category_name
    
      FROM yke_osrs_categories
    
      WHERE  1 = 1 
      and `access` IN (1,1,5) 
      and id in (Select category_id 
      from yke_osrs_property_categories 
      where pid ="123")

    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	yke_osrs_categories	eq_ref	PRIMARY,access	PRIMARY	4	nisekore_joom817.yke_osrs_property_categories.category_id	1	Using where
    2	MATERIALIZED	yke_osrs_property_categories	ref	pid,category_id	pid	5	const	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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:3264
    10	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3151
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.32 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.194 MB Rows returned: 1

    Select fieldvalue 
      from yke_osrs_configuration 
      where fieldname like 'default_itemid'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/route.php:44
    11	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/helper.php:3270
    10	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3151
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.204 MB Rows returned: 0

    SELECT id
    
      FROM yke_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,105) 
      and (`language` LIKE 'en-GB' or `language` LIKE '*' or `language` = '') 
      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	yke_menu	range	PRIMARY,idx_language	PRIMARY	4	NULL	2	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/route.php:462
    11	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/helper.php:3270
    10	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3151
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.26 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 4.208 MB Rows returned: 1

    Select * 
      from yke_osrs_categories 
      where id = '27'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:136
    17	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/helper.php:3274
    10	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3151
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 4.221 MB Rows returned: 1

    SELECT COUNT(id)
    
      FROM yke_osrs_urls
    
      WHERE md5_key like "8b59085caf1c29f2e9210a00837379e6"

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:868
    17	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/helper.php:3274
    10	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3151
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.228 MB Rows returned: 1

    SELECT category_name
    
      FROM yke_osrs_categories
    
      WHERE  1 = 1 
      and `access` IN (1,1,5) 
      and id in (Select category_id 
      from yke_osrs_property_categories 
      where pid ="123")

    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	yke_osrs_categories	eq_ref	PRIMARY,access	PRIMARY	4	nisekore_joom817.yke_osrs_property_categories.category_id	1	Using where
    2	MATERIALIZED	yke_osrs_property_categories	ref	pid,category_id	pid	5	const	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/components/com_osproperty/helpers/helper.php:3242
    10	OSPHelper::getCategoryNamesOfProperty()	JROOT/components/com_osproperty/classes/listing.php:3154
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.27 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.234 MB Rows returned: 0

    SELECT *
    
      FROM yke_osrs_property_open
    
      WHERE pid='123' 
      and end_to > '2026-03-16 01:54:32'
    
      ORDER BY start_from

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3172
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.30 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.239 MB Rows returned: 0

    Select * 
      from yke_osrs_comments 
      where pro_id = '123' 
      and published = '1' 
      order by created_on desc

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/listing.php:3195
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.245 MB Rows returned: 1
    Duplicate queries: #61  #64  #67  #70  #73  #75  #78  #80  #83  #86  #89  #92  #95

    Select pro_type 
      from yke_osrs_properties 
      where id = '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6007
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

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

    Select count(id) 
      from yke_osrs_extra_field_types 
      where fid = '104' 
      and type_id = '7'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6010
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.68 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.272 MB Rows returned: 1

    Select * 
      from yke_osrs_property_field_value 
      where pro_id = '123' 
      and field_id = '104'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2130
    11	HelperOspropertyFieldsPrint::showField_Text()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2090
    10	HelperOspropertyFieldsPrint::showField()	JROOT/components/com_osproperty/classes/listing.php:3208
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.25 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.263 MB Rows returned: 1
    Duplicate queries: #58  #64  #67  #70  #73  #75  #78  #80  #83  #86  #89  #92  #95

    Select pro_type 
      from yke_osrs_properties 
      where id = '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6007
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.269 MB Rows returned: 1

    Select count(id) 
      from yke_osrs_extra_field_types 
      where fid = '105' 
      and type_id = '7'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6010
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.65 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.291 MB Rows returned: 1

    Select * 
      from yke_osrs_property_field_value 
      where pro_id = '123' 
      and field_id = '105'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2130
    11	HelperOspropertyFieldsPrint::showField_Text()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2090
    10	HelperOspropertyFieldsPrint::showField()	JROOT/components/com_osproperty/classes/listing.php:3208
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.281 MB Rows returned: 1
    Duplicate queries: #58  #61  #67  #70  #73  #75  #78  #80  #83  #86  #89  #92  #95

    Select pro_type 
      from yke_osrs_properties 
      where id = '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6007
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 4.297 MB Rows returned: 1

    Select count(id) 
      from yke_osrs_extra_field_types 
      where fid = '108' 
      and type_id = '7'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6010
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.67 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.323 MB Rows returned: 0

    Select * 
      from yke_osrs_property_field_value 
      where pro_id = '123' 
      and field_id = '108'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2130
    11	HelperOspropertyFieldsPrint::showField_Text()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2090
    10	HelperOspropertyFieldsPrint::showField()	JROOT/components/com_osproperty/classes/listing.php:3208
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.314 MB Rows returned: 1
    Duplicate queries: #58  #61  #64  #70  #73  #75  #78  #80  #83  #86  #89  #92  #95

    Select pro_type 
      from yke_osrs_properties 
      where id = '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6007
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.320 MB Rows returned: 1

    Select count(id) 
      from yke_osrs_extra_field_types 
      where fid = '118' 
      and type_id = '7'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6010
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 0.65 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.341 MB Rows returned: 0

    Select * 
      from yke_osrs_property_field_value 
      where pro_id = '123' 
      and field_id = '118'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2130
    11	HelperOspropertyFieldsPrint::showField_Text()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2090
    10	HelperOspropertyFieldsPrint::showField()	JROOT/components/com_osproperty/classes/listing.php:3208
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.332 MB Rows returned: 1
    Duplicate queries: #58  #61  #64  #67  #73  #75  #78  #80  #83  #86  #89  #92  #95

    Select pro_type 
      from yke_osrs_properties 
      where id = '123'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6007
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

71. Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.337 MB Rows returned: 1

    Select count(id) 
      from yke_osrs_extra_field_types 
      where fid = '109' 
      and type_id = '7'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:6010
    10	OSPHelper::checkFieldWithPropertType()	JROOT/components/com_osproperty/classes/listing.php:3206
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

72. Query Time: 0.65 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.359 MB Rows returned: 0

    Select * 
      from yke_osrs_property_field_value 
      where pro_id = '123' 
      and field_id = '109'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2130
    11	HelperOspropertyFieldsPrint::showField_Text()	JROOT/administrator/components/com_osproperty/helpers/extrafields.php:2090
    10	HelperOspropertyFieldsPrint::showField()	JROOT/components/com_osproperty/classes/listing.php:3208
    9	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:2437
    8	OspropertyListing::propertyTag()	JROOT/components/com_osproperty/classes/listing.php:117
    7	OspropertyListing::display()	JROOT/components/com_osproperty/osproperty.php:255
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

73. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 4.349 MB Rows returned: 1