House

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/d66044fe-2214-4625-bb12-31ccb6f43754/doonproperty.co.in/administrator/components/com_bt_property/tables/category.php on line 104

**Home** House

House

For Sale

Beautiful House 455 Sq Yards Patel Nagar Dehradun

**View detail**

INR 10,000,000.00

For Sale

HOT PROPERTY

Beautiful House For Sale At Gochar Himachal Pradesh

**View detail**

INR 2,500,000.00

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1751772432,
                "last": 1751772432,
                "now": 1751772432
            },
            "token": "dkakrHYBDttqrXGXaiu5lmLBibB0eQtu"
        },
        "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
        }
    }
}

Profile Information

Time

Memory

**Time**: 31.62 ms / 31.62 ms **Memory**: 2.014 MB / 2.39 MB Application: afterLoad

**Time**: 107.42 ms / 139.04 ms **Memory**: 5.244 MB / 7.63 MB Application: afterInitialise

**Time**: 17.37 ms / 156.40 ms **Memory**: 0.984 MB / 8.62 MB Application: afterRoute

**Time**: 0.54 ms / 156.95 ms **Memory**: 0.026 MB / 8.64 MB Application: beforeRenderComponent com_bt_property

**Time**: 33.52 ms / 190.47 ms **Memory**: 1.275 MB / 9.92 MB Application: afterRenderComponent com_bt_property

**Time**: 1.78 ms / 192.25 ms **Memory**: 0.100 MB / 10.02 MB Application: afterDispatch

**Time**: 12.70 ms / 204.95 ms **Memory**: 0.693 MB / 10.71 MB Application: beforeRenderModule mod_bt_contentshowcase (Blog)

**Time**: 3.89 ms / 208.84 ms **Memory**: 0.415 MB / 11.13 MB Application: Before Access::preloadComponents (all components)

**Time**: 3.17 ms / 212.01 ms **Memory**: 0.060 MB / 11.19 MB Application: After Access::preloadComponents (all components)

**Time**: 0.04 ms / 212.05 ms **Memory**: -0.004 MB / 11.18 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Time**: 0.57 ms / 212.61 ms **Memory**: 0.026 MB / 11.21 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Time**: 83.08 ms / 295.70 ms **Memory**: 0.338 MB / 11.55 MB Application: afterRenderModule mod_bt_contentshowcase (Blog)

**Time**: 0.09 ms / 295.79 ms **Memory**: -0.076 MB / 11.47 MB Application: beforeRenderModule mod_custom (Contact info)

**Time**: 0.71 ms / 296.49 ms **Memory**: 0.006 MB / 11.48 MB Application: afterRenderModule mod_custom (Contact info)

**Time**: 0.07 ms / 296.56 ms **Memory**: -0.002 MB / 11.48 MB Application: beforeRenderModule mod_custom (DISCLAIMER)

**Time**: 0.27 ms / 296.83 ms **Memory**: 0.004 MB / 11.48 MB Application: afterRenderModule mod_custom (DISCLAIMER)

**Time**: 0.06 ms / 296.90 ms **Memory**: -0.001 MB / 11.48 MB Application: beforeRenderModule mod_custom (Footer 1)

**Time**: 16.81 ms / 313.71 ms **Memory**: 0.602 MB / 12.08 MB Application: afterRenderModule mod_custom (Footer 1)

**Time**: 0.09 ms / 313.79 ms **Memory**: -0.001 MB / 12.08 MB Application: beforeRenderModule mod_custom (Footer menu)

**Time**: 0.50 ms / 314.30 ms **Memory**: 0.004 MB / 12.08 MB Application: afterRenderModule mod_custom (Footer menu)

**Time**: 0.05 ms / 314.35 ms **Memory**: 0.001 MB / 12.08 MB Application: beforeRenderModule mod_custom (Social Share)

**Time**: 0.39 ms / 314.74 ms **Memory**: 0.003 MB / 12.09 MB Application: afterRenderModule mod_custom (Social Share)

**Time**: 0.15 ms / 314.89 ms **Memory**: -0.001 MB / 12.09 MB Application: beforeRenderModule mod_custom (copyright)

**Time**: 0.38 ms / 315.27 ms **Memory**: 0.003 MB / 12.09 MB Application: afterRenderModule mod_custom (copyright)

**Time**: 0.10 ms / 315.36 ms **Memory**: -0.001 MB / 12.09 MB Application: beforeRenderModule mod_breadcrumbs (Pathway)

**Time**: 5.67 ms / 321.03 ms **Memory**: 0.055 MB / 12.15 MB Application: afterRenderModule mod_breadcrumbs (Pathway)

**Time**: 0.13 ms / 321.16 ms **Memory**: -0.003 MB / 12.14 MB Application: beforeRenderModule mod_menu (Main Menu)

**Time**: 5.60 ms / 326.76 ms **Memory**: 0.095 MB / 12.24 MB Application: afterRenderModule mod_menu (Main Menu)

**Time**: 0.13 ms / 326.89 ms **Memory**: -0.002 MB / 12.24 MB Application: beforeRenderModule mod_btsocialconnect_login (BT Social Connect - Login)

**Time**: 15.39 ms / 342.28 ms **Memory**: 0.190 MB / 12.43 MB Application: afterRenderModule mod_btsocialconnect_login (BT Social Connect - Login)

**Time**: 0.06 ms / 342.34 ms **Memory**: -0.018 MB / 12.41 MB Application: beforeRenderModule mod_custom (Contact top)

**Time**: 0.39 ms / 342.74 ms **Memory**: 0.003 MB / 12.41 MB Application: afterRenderModule mod_custom (Contact top)

**Time**: 13.54 ms / 356.27 ms **Memory**: 0.872 MB / 13.28 MB Application: afterRender

**Database queries total: 134.07 ms**

Memory Usage

Database Queries

44 Queries Logged 134.07 ms

9 duplicate found!

**4 duplicates**: #14 #16 #37 #39

**2 duplicates**: #15 #38

**3 duplicates**: #20 #27 #29

**Query Time: 1.96 ms** **Query memory: 0.023 MB Memory before query: 4.163 MB** **Rows returned: 0**

SELECT `data`

  FROM `w0iw3_session`

  WHERE `session_id` = X'6639386137663633383334613162376634343632306636393532386433653936'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
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:47

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

**Query Time: 0.75 ms** **After last query: 2.18 ms** **Query memory: 0.020 MB Memory before query: 4.260 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `w0iw3_session`

  WHERE `session_id` = X'6639386137663633383334613162376634343632306636393532386433653936' 
  LIMIT 1

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:47

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

**Query Time: 1.17 ms** **After last query: 0.16 ms** **Query memory: 0.004 MB Memory before query: 4.265 MB**

INSERT INTO `w0iw3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6639386137663633383334613162376634343632306636393532386433653936', 1, 1751772432, 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `w0iw3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6639386137663633383334613162376634343632306636393532386433653936', 1, 1751772432, 0, '', 0)**

**Profile**

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

**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:47

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

**Query Time: 2.92 ms** **After last query: 4.03 ms** **Query memory: 0.040 MB Memory before query: 4.455 MB** **Rows returned: 42**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `w0iw3_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	w0iw3_extensions	ref	extension	extension	82	const	42	Using index condition; Using where

**Profile**

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

**Call Stack**

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

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

**Query Time: 1.24 ms** **After last query: 3.86 ms** **Query memory: 0.021 MB Memory before query: 4.664 MB** **Rows returned: 5**

SELECT id, rules

  FROM `w0iw3_viewlevels`

**Explain**

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

**Profile**

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

**Call Stack**

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

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

**Query Time: 1.70 ms** **After last query: 0.15 ms** **Query memory: 0.021 MB Memory before query: 4.676 MB** **Rows returned: 2**

SELECT b.id

  FROM w0iw3_usergroups AS a

  LEFT JOIN w0iw3_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
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:50

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

**Query Time: 2.17 ms** **After last query: 1.13 ms** **Query memory: 0.030 MB Memory before query: 4.807 MB** **Rows returned: 96**

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM w0iw3_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	w0iw3_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	245	Using where; Using filesort

**Profile**

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

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:50

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

**Query Time: 2.71 ms** **After last query: 28.27 ms** **Query memory: 0.054 MB Memory before query: 6.676 MB** **Rows returned: 23**

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 w0iw3_menu AS m

  LEFT JOIN w0iw3_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	108	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.m.component_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
30	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*Same as call in the line below.*
29	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
28	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
27	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
26	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
25	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
24	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
23	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
22	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
21	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
20	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
19	Joomla\CMS\HTML\HTMLHelper::script()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
15	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:298
13	JHtmlBehavior::tooltip()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_bt_socialconnect/helpers/helper.php:15
9	require_once JROOT/components/com_bt_socialconnect/helpers/helper.php	JROOT/components/com_bt_socialconnect/helpers/html/social.php:22
8	require_once JROOT/components/com_bt_socialconnect/helpers/html/social.php	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:19
7	require_once JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:50

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

**Query Time: 2.19 ms** **After last query: 0.76 ms** **Query memory: 0.027 MB Memory before query: 6.769 MB** **Rows returned: 3**

SELECT id, home, template, s.params

  FROM w0iw3_template_styles as s

  LEFT JOIN w0iw3_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
21	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
20	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
19	Joomla\CMS\HTML\HTMLHelper::script()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
15	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:298
13	JHtmlBehavior::tooltip()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_bt_socialconnect/helpers/helper.php:15
9	require_once JROOT/components/com_bt_socialconnect/helpers/helper.php	JROOT/components/com_bt_socialconnect/helpers/html/social.php:22
8	require_once JROOT/components/com_bt_socialconnect/helpers/html/social.php	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:19
7	require_once JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:50

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

**Query Time: 0.97 ms** **After last query: 0.93 ms** **Query memory: 0.029 MB Memory before query: 6.817 MB** **Rows returned: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `w0iw3_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
28	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*Same as call in the line below.*
27	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
26	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
25	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
24	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
23	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
20	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
19	Joomla\CMS\HTML\HTMLHelper::script()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
15	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:298
13	JHtmlBehavior::tooltip()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_bt_socialconnect/helpers/helper.php:15
9	require_once JROOT/components/com_bt_socialconnect/helpers/helper.php	JROOT/components/com_bt_socialconnect/helpers/html/social.php:22
8	require_once JROOT/components/com_bt_socialconnect/helpers/html/social.php	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:19
7	require_once JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:50

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

**Query Time: 0.95 ms** **After last query: 0.22 ms** **Query memory: 0.012 MB Memory before query: 6.814 MB**

UPDATE `w0iw3_extensions`

  SET `params` = '{\"mediaversion\":\"a89c4642aa8faa8230e99afac35ebd87\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
24	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
23	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
22	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
21	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
20	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
19	Joomla\CMS\HTML\HTMLHelper::script()	*Same as call in the line below.*
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
15	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:298
13	JHtmlBehavior::tooltip()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_bt_socialconnect/helpers/helper.php:15
9	require_once JROOT/components/com_bt_socialconnect/helpers/helper.php	JROOT/components/com_bt_socialconnect/helpers/html/social.php:22
8	require_once JROOT/components/com_bt_socialconnect/helpers/html/social.php	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:19
7	require_once JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:50

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

**Query Time: 1.45 ms** **After last query: 32.57 ms** **Query memory: 0.022 MB Memory before query: 8.606 MB** **Rows returned: 1**

SELECT *

  FROM w0iw3_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:216
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:405
8	plgSystemK2->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:50

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

**Query Time: 2.02 ms** **After last query: 10.50 ms** **Query memory: 0.028 MB Memory before query: 9.419 MB** **Rows returned: 16**

SHOW FULL COLUMNS 
  FROM `w0iw3_bt_property_categories`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `w0iw3_bt_property_categories`**

**Profile**

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

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_bt_property/tables/category.php:75
16	Bt_propertyTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_bt_property/models/properties.php:33
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 1.22 ms** **After last query: 0.66 ms** **Query memory: 0.025 MB Memory before query: 9.461 MB** **Rows returned: 7**

**Duplicate queries**: #16 #37 #39

SELECT id 
  FROM w0iw3_bt_property_extrafields 
  WHERE published = 1 
  AND `all` = 1 
  order by ordering

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_bt_property/tables/category.php:252
17	Bt_propertyTableCategory->getExtrafieldsAll()	JROOT/administrator/components/com_bt_property/tables/category.php:77
16	Bt_propertyTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_bt_property/models/properties.php:33
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.87 ms** **After last query: 0.16 ms** **Query memory: 0.025 MB Memory before query: 9.473 MB** **Rows returned: 1**

**Duplicate queries**: #38

SELECT *

  FROM w0iw3_bt_property_categories

  WHERE `id` = '5'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_bt_property/tables/category.php:135
15	Bt_propertyTableCategory->load()	JROOT/components/com_bt_property/models/properties.php:36
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.69 ms** **After last query: 0.22 ms** **Query memory: 0.024 MB Memory before query: 9.479 MB** **Rows returned: 7**

**Duplicate queries**: #14 #37 #39

SELECT id 
  FROM w0iw3_bt_property_extrafields 
  WHERE published = 1 
  AND `all` = 1 
  order by ordering

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_bt_property/tables/category.php:252
16	Bt_propertyTableCategory->getExtrafieldsAll()	JROOT/administrator/components/com_bt_property/tables/category.php:136
15	Bt_propertyTableCategory->load()	JROOT/components/com_bt_property/models/properties.php:36
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.63 ms** **After last query: 0.09 ms** **Query memory: 0.024 MB Memory before query: 9.490 MB** **Rows returned: 1**

select parent_id 
  from w0iw3_bt_property_categories 
  where id= 5

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_bt_property/models/properties.php:48
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.81 ms** **After last query: 0.09 ms** **Query memory: 0.026 MB Memory before query: 9.501 MB** **Rows returned: 9**

SELECT *

  FROM w0iw3_bt_property_categories

  WHERE published = 1 
  AND parent_id = 0 
  AND access IN (1,1,5) 
  AND language in ('en-GB','*')

  ORDER BY ordering DESC

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_bt_property/models/properties.php:58
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.67 ms** **After last query: 0.12 ms** **Query memory: 0.023 MB Memory before query: 9.519 MB** **Rows returned: 0**

SELECT *

  FROM w0iw3_bt_property_categories

  WHERE published = 1 
  AND parent_id = 5 
  AND access IN (1,1,5) 
  AND language in ('en-GB','*')

  ORDER BY ordering DESC

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_bt_property/models/properties.php:72
14	Bt_propertyModelProperties->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.59 ms** **After last query: 0.24 ms** **Query memory: 0.024 MB Memory before query: 9.529 MB** **Rows returned: 0**

**Duplicate queries**: #27 #29

SELECT id 
  FROM w0iw3_bt_property_categories 
  WHERE parent_id = 5

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_bt_property/models/properties.php:457
15	Bt_propertyModelProperties::callBackAllChild()	JROOT/components/com_bt_property/models/properties.php:386
14	Bt_propertyModelProperties->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_bt_property/views/properties/view.html.php:25
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 1.86 ms** **After last query: 0.08 ms** **Query memory: 0.025 MB Memory before query: 9.538 MB** **Rows returned: 2**

SELECT a.*,b.id as category_id, b.title AS category_title, b.alias AS category_alias, b.image as category_image

  FROM w0iw3_bt_properties as a

  LEFT JOIN w0iw3_bt_property_categories AS b 
  ON a.catid = b.id

  WHERE b.access IN (1,1,5) 
  AND b.published = 1 
  AND a.published = 1 
  AND a.access IN (1,1,5) 
  AND a.language in ('en-GB','*') 
  AND b.id in (5)

  GROUP BY a.id

  ORDER BY a.ordering ASC 
  LIMIT 15

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	68	Using where; Using filesort

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_bt_property/views/properties/view.html.php:25
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 1.30 ms** **After last query: 1.18 ms** **Query memory: 0.024 MB Memory before query: 9.647 MB** **Rows returned: 2**

SELECT a.*,b.id as category_id, b.title AS category_title, b.alias AS category_alias, b.image as category_image

  FROM w0iw3_bt_properties as a

  LEFT JOIN w0iw3_bt_property_categories AS b 
  ON a.catid = b.id

  WHERE b.access IN (1,1,5) 
  AND b.published = 1 
  AND a.published = 1 
  AND a.access IN (1,1,5) 
  AND a.language in ('en-GB','*') 
  AND b.id in (5)

  GROUP BY a.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	68	Using where; Using filesort

**Profile**

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

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_bt_property/views/properties/view.html.php:26
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.62 ms** **After last query: 0.11 ms** **Query memory: 0.022 MB Memory before query: 9.647 MB** **Rows returned: 1**

SELECT inherit 
  FROM w0iw3_bt_property_categories 
  WHERE id =5

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_bt_property/tables/property.php:268
11	Bt_propertyTableProperty::loadExtraFields()	JROOT/components/com_bt_property/views/properties/view.html.php:41
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.61 ms** **After last query: 0.06 ms** **Query memory: 0.022 MB Memory before query: 9.653 MB** **Rows returned: 1**

SELECT parent_id 
  FROM w0iw3_bt_property_categories 
  WHERE id = 5

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_bt_property/tables/property.php:368
12	Bt_propertyTableProperty::categoryParent()	JROOT/administrator/components/com_bt_property/tables/property.php:269
11	Bt_propertyTableProperty::loadExtraFields()	JROOT/components/com_bt_property/views/properties/view.html.php:41
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.61 ms** **After last query: 0.07 ms** **Query memory: 0.022 MB Memory before query: 9.660 MB** **Rows returned: 1**

SELECT extra_fields 
  FROM w0iw3_bt_property_categories 
  WHERE id in (5)

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_bt_property/tables/property.php:274
11	Bt_propertyTableProperty::loadExtraFields()	JROOT/components/com_bt_property/views/properties/view.html.php:41
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 2.13 ms** **After last query: 0.09 ms** **Query memory: 0.023 MB Memory before query: 9.670 MB** **Rows returned: 4**

SELECT e.*,g.title as group_title,g.alias as group_alias

  FROM w0iw3_bt_property_extrafields as e

  LEFT JOIN w0iw3_bt_property_items as g 
  on g.type='exgroup' 
  and e.
  group = g.id

  WHERE e.published = 1 
  AND g.published = 1 
  AND e.featured = 1 
  AND e.`all` = 1

  ORDER BY g.ordering,e.ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using temporary; Using filesort
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.e.group	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_bt_property/tables/property.php:305
11	Bt_propertyTableProperty::loadExtraFields()	JROOT/components/com_bt_property/views/properties/view.html.php:41
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.70 ms** **After last query: 3.44 ms** **Query memory: 0.024 MB Memory before query: 9.926 MB** **Rows returned: 0**

**Duplicate queries**: #20 #29

SELECT id 
  FROM w0iw3_bt_property_categories 
  WHERE parent_id = 5

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_bt_property/helpers/route.php:147
15	BT_PropertyHelperRoute::getCategoryParents()	JROOT/components/com_bt_property/helpers/route.php:34
14	BT_PropertyHelperRoute::getPropertyRoute()	JROOT/templates/bt_property/html/com_bt_property/default/layout/list/grid.php:56
13	include JROOT/templates/bt_property/html/com_bt_property/default/layout/list/grid.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_bt_property/views/properties/view.html.php:77
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.73 ms** **After last query: 0.26 ms** **Query memory: 0.024 MB Memory before query: 9.936 MB** **Rows returned: 6**

select id,title 
  from w0iw3_bt_property_items 
  where published = 1 
  and type='prstatus'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_bt_property/helpers/helper.php:413
14	Bt_propertyHelper::statusTitle()	JROOT/templates/bt_property/html/com_bt_property/default/layout/list/grid.php:65
13	include JROOT/templates/bt_property/html/com_bt_property/default/layout/list/grid.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_bt_property/views/properties/view.html.php:77
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 0.62 ms** **After last query: 0.12 ms** **Query memory: 0.024 MB Memory before query: 9.949 MB** **Rows returned: 0**

**Duplicate queries**: #20 #27

SELECT id 
  FROM w0iw3_bt_property_categories 
  WHERE parent_id = 5

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_bt_property/helpers/route.php:147
15	BT_PropertyHelperRoute::getCategoryParents()	JROOT/components/com_bt_property/helpers/route.php:34
14	BT_PropertyHelperRoute::getPropertyRoute()	JROOT/templates/bt_property/html/com_bt_property/default/layout/list/grid.php:56
13	include JROOT/templates/bt_property/html/com_bt_property/default/layout/list/grid.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_bt_property/views/properties/view.html.php:77
10	Bt_propertyViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_bt_property/controller.php:29
8	Bt_propertyController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_bt_property/bt_property.php:30
6	require_once JROOT/components/com_bt_property/bt_property.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:50

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

**Query Time: 3.36 ms** **After last query: 3.78 ms** **Query memory: 0.041 MB Memory before query: 10.175 MB** **Rows returned: 18**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM w0iw3_modules AS m

  LEFT JOIN w0iw3_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN w0iw3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-07-06 03:27:12') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-06 03:27:12') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 171 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	89	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	webnestd1_propdata.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	webnestd1_propdata.m.module,const	1	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.72 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.08 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.08 ms
Optimizing	0.08 ms
Statistics	0.33 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	1.25 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	*Same as call in the line below.*
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/bt_property/index.php:24
7	require JROOT/templates/bt_property/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 2.93 ms** **After last query: 11.61 ms** **Query memory: 0.030 MB Memory before query: 11.130 MB** **Rows returned: 42**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `w0iw3_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_bt_property','com_bt_socialconnect','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	w0iw3_assets	range	idx_asset_name	idx_asset_name	202	NULL	43	Using index condition

**Profile**

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

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
16	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
15	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:159
12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
11	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
10	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 71.67 ms** **After last query: 0.81 ms** **Query memory: 0.041 MB Memory before query: 11.210 MB** **Rows returned: 2**

SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM w0iw3_content AS a

  LEFT JOIN w0iw3_categories AS c 
  ON c.id = a.catid

  LEFT JOIN w0iw3_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN w0iw3_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN w0iw3_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN w0iw3_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (0,8,9,10,11) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-06 03:27:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-06 03:27:12')

  ORDER BY a.created desc 
  LIMIT 2

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_access,idx_state,idx_catid	idx_state	1	NULL	1214	Using index condition; Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	webnestd1_propdata.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.a.created_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.a.id	1	Using where

**Profile**

Status	Duration
Starting	0.19 ms
checking permissions	0.02 ms
Opening tables	1.65 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.25 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.14 ms
Optimizing	0.09 ms
Statistics	1.57 ms
Preparing	0.03 ms
Unlocking tables	0.01 ms
Preparing	0.11 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	67.04 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:159
12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
11	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
10	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 2.30 ms** **After last query: 2.25 ms** **Query memory: 0.024 MB Memory before query: 11.405 MB** **Rows returned: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `w0iw3_contentitem_tag_map` AS m 

  INNER JOIN `w0iw3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1756 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	389	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	webnestd1_propdata.m.tag_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:159
12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
11	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
10	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 1.11 ms** **After last query: 0.22 ms** **Query memory: 0.023 MB Memory before query: 11.424 MB** **Rows returned: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `w0iw3_contentitem_tag_map` AS m 

  INNER JOIN `w0iw3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1742 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	389	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	webnestd1_propdata.m.tag_id	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:159
12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
11	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
10	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 1.70 ms** **After last query: 1.20 ms** **Query memory: 0.028 MB Memory before query: 11.492 MB** **Rows returned: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `w0iw3_categories` AS `s`

  INNER JOIN `w0iw3_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 11

  ORDER BY c.lft

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
22	ContentRouter->getCategorySegment()	*Same as call in the line below.*
21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:186
12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
11	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
10	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 3.85 ms** **After last query: 11.92 ms** **Query memory: 0.026 MB Memory before query: 12.064 MB** **Rows returned: 0**

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM w0iw3_fields AS a

  LEFT JOIN `w0iw3_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN w0iw3_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN w0iw3_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN w0iw3_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN w0iw3_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	webnestd1_propdata.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	webnestd1_propdata.a.group_id	1	Using where

**Profile**

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.97 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.14 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.10 ms
Optimizing	0.09 ms
Statistics	0.68 ms
Preparing	0.09 ms
Creating tmp table	0.11 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.56 ms
Creating sort index	0.07 ms
Removing tmp table	0.15 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	*Same as call in the line below.*
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 0.94 ms** **After last query: 8.05 ms** **Query memory: 0.027 MB Memory before query: 12.130 MB** **Rows returned: 7**

**Duplicate queries**: #14 #16 #39

SELECT id 
  FROM w0iw3_bt_property_extrafields 
  WHERE published = 1 
  AND `all` = 1 
  order by ordering

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_bt_property/tables/category.php:252
22	Bt_propertyTableCategory->getExtrafieldsAll()	JROOT/administrator/components/com_bt_property/tables/category.php:77
21	Bt_propertyTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_bt_property/router.php:72
19	Bt_propertyBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 0.83 ms** **After last query: 0.25 ms** **Query memory: 0.026 MB Memory before query: 12.143 MB** **Rows returned: 1**

**Duplicate queries**: #15

SELECT *

  FROM w0iw3_bt_property_categories

  WHERE `id` = '5'

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
21	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_bt_property/tables/category.php:135
20	Bt_propertyTableCategory->load()	JROOT/components/com_bt_property/router.php:73
19	Bt_propertyBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 0.87 ms** **After last query: 0.32 ms** **Query memory: 0.026 MB Memory before query: 12.151 MB** **Rows returned: 7**

**Duplicate queries**: #14 #16 #37

SELECT id 
  FROM w0iw3_bt_property_extrafields 
  WHERE published = 1 
  AND `all` = 1 
  order by ordering

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_bt_property/tables/category.php:252
21	Bt_propertyTableCategory->getExtrafieldsAll()	JROOT/administrator/components/com_bt_property/tables/category.php:136
20	Bt_propertyTableCategory->load()	JROOT/components/com_bt_property/router.php:73
19	Bt_propertyBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 1.57 ms** **After last query: 15.86 ms** **Query memory: 0.022 MB Memory before query: 12.388 MB** **Rows returned: 0**

SELECT * 
  FROM w0iw3_bt_users 
  WHERE user_id =  0

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_btsocialconnect_login/helper.php:221
11	modbt_socialconnectHelper::getAvatar()	JROOT/modules/mod_btsocialconnect_login/mod_btsocialconnect_login.php:103
10	include JROOT/modules/mod_btsocialconnect_login/mod_btsocialconnect_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 1.48 ms** **After last query: 0.11 ms** **Query memory: 0.024 MB Memory before query: 12.395 MB** **Rows returned: 8**

SELECT * 
  FROM w0iw3_bt_user_fields 
  WHERE published = 1 
  AND show_listing = 1 
  order by ordering

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_btsocialconnect_login/helper.php:212
12	modbt_socialconnectHelper::getFieldname()	JROOT/modules/mod_btsocialconnect_login/helper.php:223
11	modbt_socialconnectHelper::getAvatar()	JROOT/modules/mod_btsocialconnect_login/mod_btsocialconnect_login.php:103
10	include JROOT/modules/mod_btsocialconnect_login/mod_btsocialconnect_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 0.90 ms** **After last query: 0.11 ms** **Query memory: 0.025 MB Memory before query: 12.401 MB** **Rows returned: 11**

SELECT * 
  FROM w0iw3_bt_user_fields 
  WHERE published = 1  
  AND show_registration = 1 
  order by ordering

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_bt_socialconnect/helpers/helper.php:66
12	Bt_SocialconnectHelper::loadUserFields()	JROOT/modules/mod_btsocialconnect_login/helper.php:203
11	modbt_socialconnectHelper::loadUserFields()	JROOT/modules/mod_btsocialconnect_login/mod_btsocialconnect_login.php:104
10	include JROOT/modules/mod_btsocialconnect_login/mod_btsocialconnect_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 2.33 ms** **After last query: 3.55 ms** **Query memory: 0.022 MB Memory before query: 12.450 MB** **Rows returned: 0**

SELECT *
 
  FROM w0iw3_jmap_metainfo
 
  WHERE `linkurl` = 'https://doonproperty.co.in/index.php/house'
 
  AND `published` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	w0iw3_jmap_metainfo	ref	linkurl,published	linkurl	767	const	1	Using where

**Profile**

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

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:246
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

**Query Time: 1.37 ms** **After last query: 6.31 ms** **Query memory: 0.020 MB Memory before query: 13.278 MB** **Rows returned: 0**

SELECT social_id 
  FROM w0iw3_bt_connections 
  WHERE social_type ="facebook" 
  AND  user_id ="0"

**Explain**

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

**Profile**

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

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:533
8	plgSystemBt_socialconnect_system::getSocialID()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:148
7	plgSystemBt_socialconnect_system->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**4 × SELECT * 
  FROM w0iw3_bt_property_categories**

**4 × SELECT id 
  FROM w0iw3_bt_property_extrafields**

**3 × SELECT id 
  FROM w0iw3_bt_property_categories**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `w0iw3_extensions`**

**2 × SELECT * 
  FROM w0iw3_bt_user_fields**

**2 × SELECT `m`.`tag_id`,`t`.* 
  FROM `w0iw3_contentitem_tag_map` AS m  
  INNER JOIN `w0iw3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**2 × SELECT a.*,b.id as category_id, b.title AS category_title, b.alias AS category_alias, b.image as category_image 
  FROM w0iw3_bt_properties as a 
  LEFT JOIN w0iw3_bt_property_categories AS b 
  ON a.catid = b.id**

**1 × SELECT `data` 
  FROM `w0iw3_session`**

**1 × select id,title 
  from w0iw3_bt_property_items**

**1 × SELECT *  
  FROM w0iw3_jmap_metainfo**

**1 × SELECT * 
  FROM w0iw3_bt_users**

**1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM w0iw3_fields AS a 
  LEFT JOIN `w0iw3_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN w0iw3_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN w0iw3_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN w0iw3_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN w0iw3_fields_groups AS g 
  ON g.id = a.group_id**

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

**1 × SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM w0iw3_content AS a 
  LEFT JOIN w0iw3_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN w0iw3_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN w0iw3_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN w0iw3_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN w0iw3_content_rating AS v 
  ON a.id = v.content_id**

**1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `w0iw3_assets`**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM w0iw3_modules AS m 
  LEFT JOIN w0iw3_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN w0iw3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT inherit 
  FROM w0iw3_bt_property_categories**

**1 × SELECT e.*,g.title as group_title,g.alias as group_alias 
  FROM w0iw3_bt_property_extrafields as e 
  LEFT JOIN w0iw3_bt_property_items as g 
  on g.type='exgroup' 
  and e.
  group = g.id**

**1 × SELECT extra_fields 
  FROM w0iw3_bt_property_categories**

**1 × SELECT parent_id 
  FROM w0iw3_bt_property_categories**

**1 × SELECT `session_id` 
  FROM `w0iw3_session`**

**1 × select parent_id 
  from w0iw3_bt_property_categories**

**1 × SELECT * 
  FROM w0iw3_languages**

**1 × SELECT id, home, template, s.params 
  FROM w0iw3_template_styles as s 
  LEFT JOIN w0iw3_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM w0iw3_menu AS m 
  LEFT JOIN w0iw3_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM w0iw3_extensions**

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

**1 × SELECT id, rules 
  FROM `w0iw3_viewlevels**

**1 × SELECT social_id 
  FROM w0iw3_bt_connections**

OTHER Tables:

**1 × INSERT INTO `w0iw3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6639386137663633383334613162376634343632306636393532386433653936', 1, 1751772432, 0, '', 0**

**1 × UPDATE `w0iw3_extensions` 
  SET `params` = '{\"mediaversion\":\"a89c4642aa8faa8230e99afac35ebd87\"}'**

**1 × SHOW FULL COLUMNS 
  FROM `w0iw3_bt_property_categories**


# JROOT/libraries/src/Language/Text.php

BACK_TO_TOP="TO TOP"
EMAIL_INVALID="INVALID"
EMAIL_NOT_MATCH="NOT MATCH"
PASSWORD_NOT_MATCH="NOT MATCH"
REQUIRED_EMAIL="EMAIL"
REQUIRED_VERIFY_EMAIL="VERIFY EMAIL"

House

Beautiful House 455 Sq Yards Patel Nagar Dehradun

Beautiful House For Sale At Gochar Himachal Pradesh

DISCLAIMER

Contact info

Blog

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 134.07 ms

9 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

Beautiful House 455 Sq Yards Patel Nagar Dehradun

Beautiful House For Sale At Gochar Himachal Pradesh

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**44 Queries Logged** 134.07 ms

**9 duplicate found!**

**32 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 134.07 ms

9 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings