Properties for Sale| | Properties for Sale

Message

[DEBUG] loading lessc-0.4.0

[DEBUG] lessc v0.4.0

Real Estate Manager - property management joomla listing software for Real Estate Brokers, Real Estate Companies and other Enterprises selling Real estate How to create real estate website

COMMERCIAL PROPERTIES

Active

MBE183

View listing

Search:

Price

from

Listing type

Listing status

Real estate manager by OrdaSoft.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1783954338,
                "last": 1783954338,
                "now": 1783954338
            }
        },
        "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
        },
        "array": 1,
        "rem_housesort": {
            "order_direction": "desc",
            "order_field": "date"
        }
    }
}

Database Queries

70 Queries Logged 48.99 ms

21 duplicate found!

2 duplicates: #2 #9

2 duplicates: #15 #53

4 duplicates: #18 #31 #47 #59

2 duplicates: #19 #44

2 duplicates: #20 #45

2 duplicates: #21 #46

3 duplicates: #33 #41 #64

2 duplicates: #34 #60

2 duplicates: #51 #58

Query Time: 0.55 ms Query memory: 0.023 MB Memory before query: 3.869 MB Rows returned: 0

SELECT `data`

  FROM `l4rew_session`

  WHERE `session_id` = X'6365366234353932643134393263633539656366646433326439653962396261'

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

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.38 ms After last query: 0.86 ms Query memory: 0.020 MB Memory before query: 3.965 MB Rows returned: 0

Duplicate queries: #9

SELECT `session_id`

  FROM `l4rew_session`

  WHERE `session_id` = X'6365366234353932643134393263633539656366646433326439653962396261' 
  LIMIT 1

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

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

#	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.85 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.032 MB

INSERT INTO `l4rew_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6365366234353932643134393263633539656366646433326439653962396261', 1, 1783954338, 0, '', 0)

EXPLAIN not possible on query: INSERT INTO `l4rew_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6365366234353932643134393263633539656366646433326439653962396261', 1, 1783954338, 0, '', 0)

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

#	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.22 ms After last query: 1.88 ms Query memory: 0.024 MB Memory before query: 4.247 MB Rows returned: 38

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

  FROM `l4rew_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

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

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

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

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

Query Time: 0.30 ms After last query: 1.49 ms Query memory: 0.021 MB Memory before query: 4.436 MB Rows returned: 4

SELECT id, rules

  FROM `l4rew_viewlevels`

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

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

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

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

Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.448 MB Rows returned: 2

SELECT b.id

  FROM l4rew_usergroups AS a

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

  WHERE a.id = 9

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

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

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

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

Query Time: 0.68 ms After last query: 0.45 ms Query memory: 0.030 MB Memory before query: 4.516 MB Rows returned: 81

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

  FROM l4rew_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

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

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 12.95 ms Query memory: 0.032 MB Memory before query: 6.594 MB Rows returned: 14

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

  LEFT JOIN l4rew_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

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	101	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.m.component_id	1	Using where

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 12.46 ms Query memory: 0.024 MB Memory before query: 8.252 MB Rows returned: 1

Duplicate queries: #2

SELECT `session_id`

  FROM `l4rew_session`

  WHERE `session_id` = X'6365366234353932643134393263633539656366646433326439653962396261' 
  LIMIT 1

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

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
15	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
14	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
13	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
12	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
11	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_realestatemanager/router.php:270
10	RealEstateManagerParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.36 ms Query memory: 0.022 MB Memory before query: 8.294 MB Rows returned: 1

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

  FROM `l4rew_extensions`

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

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

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

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

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

Query Time: 0.35 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 8.284 MB

UPDATE `l4rew_extensions`

  SET `params` = '{\"mediaversion\":\"8a81649bd716e8622533c9bf5b796364\"}'

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

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 1.40 ms Query memory: 0.019 MB Memory before query: 8.458 MB Rows returned: 1

SELECT *

  FROM l4rew_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.16 ms Query memory: 0.058 MB Memory before query: 8.469 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM l4rew_template_styles as s

  LEFT JOIN l4rew_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

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	303	mbestate_db2.s.template,const	1	Using index condition; Using where

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

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 4.86 ms Query memory: 0.021 MB Memory before query: 9.185 MB Rows returned: 1

SELECT title, lang_code, sef 
  FROM l4rew_rem_languages

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4rew_rem_languages	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_realestatemanager/language.php:27
7	require_once JROOT/administrator/components/com_realestatemanager/language.php	JROOT/components/com_realestatemanager/realestatemanager.php:45
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.17 ms After last query: 0.03 ms Query memory: 0.189 MB Memory before query: 9.191 MB Rows returned: 1276

Duplicate queries: #53

SELECT c.const, cl.value_const 
  FROM l4rew_rem_const_languages as cl 
  LEFT JOIN l4rew_rem_languages AS l 
  ON cl.fk_languagesid=l.id 
  LEFT JOIN l4rew_rem_const AS c 
  ON cl.fk_constid=c.id 
  WHERE l.lang_code = 'en-GB'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	system	PRIMARY,lang_code	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	cl	ALL	fk_languagesid	NO INDEX KEY COULD BE USED	NULL	NULL	1276	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.cl.fk_constid	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_realestatemanager/language.php:70
7	require_once JROOT/administrator/components/com_realestatemanager/language.php	JROOT/components/com_realestatemanager/realestatemanager.php:45
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 1.57 ms Query memory: 0.021 MB Memory before query: 9.985 MB Rows returned: 2

SELECT l.lang_code 
  FROM l4rew_languages as l

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	index	NULL	idx_langcode	21	NULL	2	Using index

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_realestatemanager/language.php:80
7	require_once JROOT/administrator/components/com_realestatemanager/language.php	JROOT/components/com_realestatemanager/realestatemanager.php:45
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.72 ms After last query: 36.90 ms Query memory: 0.026 MB Memory before query: 10.813 MB Rows returned: 24

SHOW FULL COLUMNS 
  FROM `l4rew_menu`

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

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Opening tables	0.79 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.13 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.26 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
10	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
9	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
8	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Menu.php:33
7	Joomla\CMS\Table\Menu->__construct()	JROOT/components/com_realestatemanager/realestatemanager.php:377
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.56 ms Query memory: 0.021 MB Memory before query: 10.865 MB Rows returned: 1

Duplicate queries: #31 #47 #59

SELECT *

  FROM l4rew_menu

  WHERE `id` = '282'

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

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
8	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
7	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/realestatemanager.php:378
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 10.871 MB Rows returned: 1

Duplicate queries: #44

SELECT  c.name, c.title, c.id AS catid, c.parent_id
                    
  FROM l4rew_rem_main_categories AS c
                    
  WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) 
  AND c.id = 52

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/realestatemanager.php:538
8	PHP_realestatemanager::addTitleAndMetaTags()	JROOT/components/com_realestatemanager/realestatemanager.php:1364
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 10.877 MB Rows returned: 1

Duplicate queries: #45

SELECT  name, title, c.id AS catid, parent_id
                        
  FROM l4rew_rem_main_categories AS c
                        
  WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) 
  AND c.id = 48

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/realestatemanager.php:551
8	PHP_realestatemanager::addTitleAndMetaTags()	JROOT/components/com_realestatemanager/realestatemanager.php:1364
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 10.882 MB Rows returned: 0

Duplicate queries: #46

SELECT h.htitle, c.id AS catid
                    
  FROM l4rew_rem_houses AS h
                    
  LEFT JOIN l4rew_rem_categories AS hc 
  ON h.id=hc.iditem
                    
  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat
                    
  WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) 
  AND h.id=0
                    
  GROUP BY h.id

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/realestatemanager.php:574
8	PHP_realestatemanager::addTitleAndMetaTags()	JROOT/components/com_realestatemanager/realestatemanager.php:1364
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 10.886 MB Rows returned: 1

SELECT * 
  FROM l4rew_rem_main_categories 
  WHERE id='52'

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

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1367
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 10.894 MB Rows returned: 1

SELECT COUNT(DISTINCT h.id)
            

  FROM l4rew_rem_houses AS h

  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.iditem=h.id

  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat

  WHERE c.id = '52' 
  AND h.published='1'  
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null)  
  AND h.approved='1' 
  AND c.published='1'
             
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	hc	ref	iditem,idcat	idcat	5	const	1
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using index condition; Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/components/com_realestatemanager/realestatemanager.php:1439
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.78 ms After last query: 0.94 ms Query memory: 0.037 MB Memory before query: 10.982 MB Rows returned: 1

SELECT h.*,hc.idcat AS catid,hc.idcat AS idcat, c.title as category_title 

  FROM l4rew_rem_houses AS h 

  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.iditem=h.id 

  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat 

  WHERE hc.idcat = '52' 
  AND h.published='1' 
    
  AND c.published='1'   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null)  
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )

  GROUP BY h.id

  ORDER BY date desc

  LIMIT 0,10;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hc	ref	iditem,idcat	idcat	5	const	1	Using index condition; Using temporary; Using filesort
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.idcat	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1457
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.36 ms After last query: 0.03 ms Query memory: 0.044 MB Memory before query: 10.996 MB Rows returned: 5

SELECT h.*,c.id, c.parent_id, c.title, c.image,COUNT(hc.iditem) as houses,
        '1' as display 
 
  FROM  l4rew_rem_main_categories as c  
 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id  
 
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem   
 
  WHERE c.section='com_realestatemanager'   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null)   
  AND c.published=1 
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
        
 
  GROUP BY c.id
        
 
  ORDER BY c.parent_id DESC, c.ordering

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	cat_idx	cat_idx	153	const,const	5	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	hc	ALL	idcat	NO INDEX KEY COULD BE USED	NULL	NULL	77	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1511
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 11.046 MB Rows returned: 1

SELECT COUNT(hc.iditem) as houses
 
  FROM  l4rew_rem_main_categories as c 
 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id 
 
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem 
 
  WHERE c.section='com_realestatemanager' 
  AND c.published=1   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null) 
                          
 
  AND ( h.published || isnull(h.published) ) 
  AND ( h.approved || isnull(h.approved )) 
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
                          
 
  AND c.id = 53
                          
 
  GROUP BY c.id

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	hc	ref	idcat	idcat	5	const	4
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1525
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 11.052 MB Rows returned: 1

SELECT COUNT(hc.iditem) as houses
 
  FROM  l4rew_rem_main_categories as c 
 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id 
 
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem 
 
  WHERE c.section='com_realestatemanager' 
  AND c.published=1   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null) 
                          
 
  AND ( h.published || isnull(h.published) ) 
  AND ( h.approved || isnull(h.approved )) 
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
                          
 
  AND c.id = 52
                          
 
  GROUP BY c.id

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	hc	ref	idcat	idcat	5	const	1
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1525
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 11.058 MB Rows returned: 1

SELECT COUNT(hc.iditem) as houses
 
  FROM  l4rew_rem_main_categories as c 
 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id 
 
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem 
 
  WHERE c.section='com_realestatemanager' 
  AND c.published=1   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null) 
                          
 
  AND ( h.published || isnull(h.published) ) 
  AND ( h.approved || isnull(h.approved )) 
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
                          
 
  AND c.id = 51
                          
 
  GROUP BY c.id

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	hc	ALL	idcat	NO INDEX KEY COULD BE USED	NULL	NULL	77	Using where
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1525
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 11.063 MB Rows returned: 1

SELECT COUNT(hc.iditem) as houses
 
  FROM  l4rew_rem_main_categories as c 
 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id 
 
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem 
 
  WHERE c.section='com_realestatemanager' 
  AND c.published=1   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null) 
                          
 
  AND ( h.published || isnull(h.published) ) 
  AND ( h.approved || isnull(h.approved )) 
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
                          
 
  AND c.id = 48
                          
 
  GROUP BY c.id

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	hc	ref	idcat	idcat	5	const	1
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1525
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 11.069 MB Rows returned: 1

SELECT COUNT(hc.iditem) as houses
 
  FROM  l4rew_rem_main_categories as c 
 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id 
 
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem 
 
  WHERE c.section='com_realestatemanager' 
  AND c.published=1   
  and ( h.language = 'en-GB' or h.language like 'all' or h.language like ''  or h.language like '*' or h.language is null)  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like '' or  c.language like '*' or c.language is null) 
                          
 
  AND ( h.published || isnull(h.published) ) 
  AND ( h.approved || isnull(h.approved )) 
  AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
                          
 
  AND c.id = 46
                          
 
  GROUP BY c.id

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	hc	ref	idcat	idcat	5	const	1
1	SIMPLE	h	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using where

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1525
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 11.080 MB Rows returned: 1

Duplicate queries: #18 #47 #59

SELECT *

  FROM l4rew_menu

  WHERE `id` = '282'

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
8	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/realestatemanager.php:1536
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.68 ms Query memory: 0.023 MB Memory before query: 11.181 MB Rows returned: 5

SELECT * 
  FROM l4rew_rem_main_categories 
  WHERE section = 'com_realestatemanager' 
  AND published = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4rew_rem_main_categories	ref	cat_idx	cat_idx	153	const,const	5	Using index condition

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:1326
8	PHP_realestatemanager::constructPathway()	JROOT/components/com_realestatemanager/realestatemanager.php:1557
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.39 ms Query memory: 0.026 MB Memory before query: 11.220 MB Rows returned: 1

Duplicate queries: #41 #64

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 52

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	1

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
17	RealEstateManagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_realestatemanager/compat.joomla1.5.php:269
9	sefRelToAbs()	JROOT/components/com_realestatemanager/realestatemanager.php:1334
8	PHP_realestatemanager::constructPathway()	JROOT/components/com_realestatemanager/realestatemanager.php:1557
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.43 ms Query memory: 0.025 MB Memory before query: 11.259 MB Rows returned: 1

Duplicate queries: #60

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 48

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	1

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
17	RealEstateManagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_realestatemanager/compat.joomla1.5.php:269
9	sefRelToAbs()	JROOT/components/com_realestatemanager/realestatemanager.php:1334
8	PHP_realestatemanager::constructPathway()	JROOT/components/com_realestatemanager/realestatemanager.php:1557
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.59 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 11.261 MB Rows returned: 0

SELECT *, COUNT(a.id) AS numlinks 
  FROM l4rew_rem_main_categories AS cc
  JOIN l4rew_rem_categories AS hc 
  ON hc.idcat = cc.id
  JOIN l4rew_rem_houses AS a 
  ON a.id = hc.iditem
 
  WHERE a.published='1' 
  AND a.approved='1' 
  AND section='com_realestatemanager'  
  AND cc.parent_id='52' 
  AND cc.published='1' 
  AND ( cc.params LIKE '%,-2' or cc.params = '-2' or cc.params LIKE '-2,%' or cc.params LIKE '%,-2,%' ) 
 
  GROUP BY cc.id
 
  ORDER BY cc.ordering

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hc	ALL	iditem,idcat	NO INDEX KEY COULD BE USED	NULL	NULL	77	Using temporary; Using filesort
1	SIMPLE	cc	range	PRIMARY,cat_idx	cat_idx	153	NULL	5	Using index condition; Using where; Using join buffer (flat, BNL join)
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.hc.iditem	1	Using index condition; Using where

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:3977
8	PHP_realestatemanager::is_exist_subcategory_houses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 11.266 MB Rows returned: 0

SELECT id 
  FROM l4rew_rem_main_categories AS cc  
  WHERE section='com_realestatemanager' 
  AND parent_id='52' 
  AND published='1' 
  AND ( cc.params LIKE '%,-2' or cc.params = '-2' or cc.params LIKE '-2,%' or cc.params LIKE '%,-2,%' )

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	ref	cat_idx	cat_idx	153	const,const	5	Using index condition; Using where

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/realestatemanager.php:3986
8	PHP_realestatemanager::is_exist_subcategory_houses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 4.21 ms Query memory: 0.027 MB Memory before query: 11.707 MB Rows returned: 7

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

  FROM l4rew_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-13 14:52:18') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-13 14:52:18') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 282 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	15	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	mbestate_db2.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	mbestate_db2.m.module,const	1	Using index condition; Using where

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
16	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:169
15	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_realestatemanager/compat.joomla1.5.php:83
10	positions_rem()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:93
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.20 ms After last query: 1.21 ms Query memory: 0.036 MB Memory before query: 11.707 MB Rows returned: 63

SHOW FULL COLUMNS 
  FROM `l4rew_rem_houses`

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

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_realestatemanager/realestatemanager.class.php:201
10	mosRealEstateManager->__construct()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:251
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.32 ms Query memory: 0.038 MB Memory before query: 11.791 MB Rows returned: 1

SELECT *

  FROM l4rew_rem_houses

  WHERE `id` = '92'

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

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:252
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 11.788 MB Rows returned: 1

SELECT idcat 
  FROM l4rew_rem_categories 
  WHERE iditem=92

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4rew_rem_categories	ref	iditem	iditem	4	const	1

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/components/com_realestatemanager/realestatemanager.class.php:225
10	mosRealEstateManager->setCatIds()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:253
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.797 MB Rows returned: 1

Duplicate queries: #33 #64

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 52

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	1

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

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
18	RealEstateManagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_realestatemanager/compat.joomla1.5.php:269
10	sefRelToAbs()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:263
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 11.807 MB Rows returned: 1

SELECT rc.idcat AS catid, r.htitle
 
  FROM l4rew_rem_houses AS r
 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.iditem=r.id
 
  LEFT JOIN l4rew_rem_main_categories AS rmc 
  ON rmc.id=rc.idcat
 
  WHERE r.id = 92

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	rc	ref	iditem	iditem	4	const	1

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

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:194
18	RealEstateManagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_realestatemanager/compat.joomla1.5.php:269
10	sefRelToAbs()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:263
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 11.816 MB Rows returned: 0

SELECT  b.rent_from , b.rent_until  
  FROM l4rew_rem_rent AS b  
  LEFT JOIN l4rew_rem_houses AS c 
  ON b.fk_houseid = c.id  
  WHERE c.id=92 
  AND c.published='1' 
  AND c.approved='1' 
  AND b.rent_return IS NULL

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

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:297
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.42 ms Query memory: 0.022 MB Memory before query: 11.823 MB Rows returned: 1

Duplicate queries: #19

SELECT  c.name, c.title, c.id AS catid, c.parent_id
                    
  FROM l4rew_rem_main_categories AS c
                    
  WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) 
  AND c.id = 52

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

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/realestatemanager.php:538
11	PHP_realestatemanager::addTitleAndMetaTags()	JROOT/components/com_realestatemanager/realestatemanager.php:2210
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 11.831 MB Rows returned: 1

Duplicate queries: #20

SELECT  name, title, c.id AS catid, parent_id
                        
  FROM l4rew_rem_main_categories AS c
                        
  WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) 
  AND c.id = 48

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

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/realestatemanager.php:551
11	PHP_realestatemanager::addTitleAndMetaTags()	JROOT/components/com_realestatemanager/realestatemanager.php:2210
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 11.837 MB Rows returned: 0

Duplicate queries: #21

SELECT h.htitle, c.id AS catid
                    
  FROM l4rew_rem_houses AS h
                    
  LEFT JOIN l4rew_rem_categories AS hc 
  ON h.id=hc.iditem
                    
  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat
                    
  WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) 
  AND h.id=0
                    
  GROUP BY h.id

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

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/realestatemanager.php:574
11	PHP_realestatemanager::addTitleAndMetaTags()	JROOT/components/com_realestatemanager/realestatemanager.php:2210
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 11.849 MB Rows returned: 1

Duplicate queries: #18 #31 #59

SELECT *

  FROM l4rew_menu

  WHERE `id` = '282'

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

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/realestatemanager.php:2220
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 2.61 ms Query memory: 0.024 MB Memory before query: 12.077 MB Rows returned: 77

SELECT price  
  FROM   l4rew_rem_houses

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

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/components/com_realestatemanager/realestatemanager.php:2559
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.61 ms Query memory: 0.024 MB Memory before query: 12.147 MB Rows returned: 77

SELECT lot_size  
  FROM   l4rew_rem_houses

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

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/components/com_realestatemanager/realestatemanager.php:2614
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 12.164 MB Rows returned: 77

SELECT house_size  
  FROM   l4rew_rem_houses

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

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/components/com_realestatemanager/realestatemanager.php:2661
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.47 ms Query memory: 0.023 MB Memory before query: 12.205 MB Rows returned: 1

Duplicate queries: #58

SELECT max(price+0) 
  FROM l4rew_rem_houses

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

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

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_realestatemanager/views/show_search_house/tmpl/default.php:20
12	require JROOT/components/com_realestatemanager/views/show_search_house/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:288
11	HTML_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:2707
10	PHP_realestatemanager::showSearchHouses()	JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php:425
9	require JROOT/components/com_realestatemanager/views/alone_category/tmpl/default.php	JROOT/components/com_realestatemanager/realestatemanager.html.php:207
8	HTML_realestatemanager::displayHouses()	JROOT/components/com_realestatemanager/realestatemanager.php:1679
7	PHP_realestatemanager::showCategory()	JROOT/components/com_realestatemanager/realestatemanager.php:390
6	require_once JROOT/components/com_realestatemanager/realestatemanager.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 6.12 ms Query memory: 0.022 MB Memory before query: 11.762 MB Rows returned: 1

SELECT l.title, l.lang_code, l.sef 
  FROM l4rew_rem_const_languages as cl 
  LEFT JOIN l4rew_rem_languages AS l 
  ON cl.fk_languagesid=l.id 
  LEFT JOIN l4rew_rem_const AS c 
  ON cl.fk_constid=c.id 
  GROUP BY  l.title

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	index	NULL	fk_constid	8	NULL	1276	Using index; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.cl.fk_languagesid	1	Using where

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:35
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.10 ms After last query: 0.06 ms Query memory: 0.190 MB Memory before query: 11.769 MB Rows returned: 1276

Duplicate queries: #15

SELECT c.const, cl.value_const 
  FROM l4rew_rem_const_languages as cl 
  LEFT JOIN l4rew_rem_languages AS l 
  ON cl.fk_languagesid=l.id 
  LEFT JOIN l4rew_rem_const AS c 
  ON cl.fk_constid=c.id 
  WHERE l.lang_code = 'en-GB'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	system	PRIMARY,lang_code	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	cl	ALL	fk_languagesid	NO INDEX KEY COULD BE USED	NULL	NULL	1276	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	mbestate_db2.cl.fk_constid	1	Using where

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:62
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 1.10 ms Query memory: 0.022 MB Memory before query: 12.528 MB Rows returned: 6

SELECT id 
  FROM l4rew_menu 
  WHERE link LIKE'%option=com_realestatemanager%' 
  AND params LIKE '%back_button%'

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

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:90
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 12.534 MB Rows returned: 1

SELECT lang_code 
  FROM l4rew_languages 
  WHERE sef = 'en'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4rew_languages	const	idx_sef	idx_sef	152	const	1

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:103
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 12.542 MB Rows returned: 5

SELECT c.*, c.parent_id AS parent, c.params AS access
 
  FROM l4rew_rem_main_categories c
 
  WHERE section='com_realestatemanager'
 
  AND published <> 0  
  AND ( c.language = 'en-GB' or c.language like 'all' or c.language like ''  or c.language like '*' or c.language is null )
 
  ORDER BY ordering

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx	cat_idx	153	NULL	5	Using index condition; Using where; Using filesort

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_realestatemanager/functions.php:2841
13	com_house_categoryArray()	JROOT/components/com_realestatemanager/functions.php:2791
12	com_house_categoryTreeList()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:112
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.09 ms Query memory: 0.028 MB Memory before query: 12.560 MB Rows returned: 21

SHOW FULL COLUMNS 
  FROM `l4rew_rem_main_categories`

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

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

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_realestatemanager/realestatemanager.main.categories.class.php:85
13	mainRealEstateCategories->__construct()	JROOT/components/com_realestatemanager/functions.php:2795
12	com_house_categoryTreeList()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:112
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 12.587 MB Rows returned: 1

Duplicate queries: #51

SELECT max(price+0) 
  FROM l4rew_rem_houses

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

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_realestatemanagersearch/tmpl/default.php:134
11	require JROOT/modules/mod_realestatemanagersearch/tmpl/default.php	JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.php:17
10	include JROOT/modules/mod_realestatemanagersearch/mod_realestatemanagersearch.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 1.01 ms Query memory: 0.026 MB Memory before query: 11.857 MB Rows returned: 1

Duplicate queries: #18 #31 #47

SELECT *

  FROM l4rew_menu

  WHERE `id` = '282'

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

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/router.php:48
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 11.868 MB Rows returned: 1

Duplicate queries: #34

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 48

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	1

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 11.881 MB Rows returned: 1

SELECT *

  FROM l4rew_menu

  WHERE `id` = '389'

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

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/router.php:48
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 11.891 MB Rows returned: 71

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 51

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ALL	idcat	NO INDEX KEY COULD BE USED	NULL	NULL	77	Using where

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 11.904 MB Rows returned: 1

SELECT *

  FROM l4rew_menu

  WHERE `id` = '390'

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

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/router.php:48
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 11.915 MB Rows returned: 1

Duplicate queries: #33 #41

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 52

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	1

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 11.937 MB Rows returned: 1

SELECT *

  FROM l4rew_menu

  WHERE `id` = '391'

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

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/router.php:48
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 11.953 MB Rows returned: 4

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 53

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	4

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 11.966 MB Rows returned: 1

SELECT *

  FROM l4rew_menu

  WHERE `id` = '388'

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

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/components/com_realestatemanager/router.php:48
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 11.976 MB Rows returned: 1

SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id  
  WHERE rmc.section = 'com_realestatemanager' 
  AND rmc.id = 46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rmc	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	rc	ref	idcat	idcat	5	const	1

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_realestatemanager/router.php:153
19	RealEstateManagerBuildRoute()	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_menu/helper.php:139
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 4.85 ms Query memory: 0.021 MB Memory before query: 12.879 MB Rows returned: 1

SELECT manifest_cache

  FROM l4rew_extensions

  WHERE type='component' 
  AND element='com_baforms'

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

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:560
9	baformsHelper::aboutUs()	JROOT/components/com_baforms/helpers/baforms.php:458
8	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:39
7	plgSystemBaforms->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 12.886 MB Rows returned: 0

SELECT `key`

  FROM l4rew_baforms_api

  WHERE service = 'balbooa_activation'

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

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:545
9	baformsHelper::checkFormsActivation()	JROOT/components/com_baforms/helpers/baforms.php:459
8	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:39
7	plgSystemBaforms->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
8 × SELECT * 
  FROM l4rew_menu
```

8 × SELECT rmc.id, rmc.name,rmc.title, rc.idcat, rmc.parent_id  
  FROM l4rew_rem_main_categories AS rmc 
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.idcat=rmc.id  
  LEFT JOIN l4rew_rem_houses AS r 
  ON rc.iditem = r.id

5 × SELECT COUNT(hc.iditem) as houses  
  FROM  l4rew_rem_main_categories as c   
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id   
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem

2 × SELECT  name, title, c.id AS catid, parent_id                         
  FROM l4rew_rem_main_categories AS c

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

2 × SELECT `session_id` 
  FROM `l4rew_session`

2 × SELECT max(price+0) 
  FROM l4rew_rem_house

2 × SELECT c.const, cl.value_const 
  FROM l4rew_rem_const_languages as cl 
  LEFT JOIN l4rew_rem_languages AS l 
  ON cl.fk_languagesid=l.id 
  LEFT JOIN l4rew_rem_const AS c 
  ON cl.fk_constid=c.id

2 × SELECT * 
  FROM l4rew_rem_main_categories

2 × SELECT h.htitle, c.id AS catid                     
  FROM l4rew_rem_houses AS h                     
  LEFT JOIN l4rew_rem_categories AS hc 
  ON h.id=hc.iditem                     
  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat

2 × SELECT  c.name, c.title, c.id AS catid, c.parent_id                     
  FROM l4rew_rem_main_categories AS c

1 × SELECT rc.idcat AS catid, r.htitle  
  FROM l4rew_rem_houses AS r  
  LEFT JOIN l4rew_rem_categories AS rc 
  ON rc.iditem=r.id  
  LEFT JOIN l4rew_rem_main_categories AS rmc 
  ON rmc.id=rc.idcat

1 × SELECT  b.rent_from , b.rent_until  
  FROM l4rew_rem_rent AS b  
  LEFT JOIN l4rew_rem_houses AS c 
  ON b.fk_houseid = c.id

1 × SELECT price  
  FROM   l4rew_rem_house

1 × SELECT `data` 
  FROM `l4rew_session`

```
1 × SELECT * 
  FROM l4rew_rem_houses
```

1 × SELECT lot_size  
  FROM   l4rew_rem_house

1 × SELECT house_size  
  FROM   l4rew_rem_house

1 × SELECT l.title, l.lang_code, l.sef 
  FROM l4rew_rem_const_languages as cl 
  LEFT JOIN l4rew_rem_languages AS l 
  ON cl.fk_languagesid=l.id 
  LEFT JOIN l4rew_rem_const AS c 
  ON cl.fk_constid=c.id 
  GROUP BY  l.titl

```
1 × SELECT id 
  FROM l4rew_menu
```

1 × SELECT lang_code 
  FROM l4rew_languages

1 × SELECT c.*, c.parent_id AS parent, c.params AS access  
  FROM l4rew_rem_main_categories c

1 × SELECT manifest_cache 
  FROM l4rew_extensions

1 × SELECT idcat 
  FROM l4rew_rem_categories

1 × SELECT h.*,c.id, c.parent_id, c.title, c.image,COUNT(hc.iditem) as houses,         '1' as display   
  FROM  l4rew_rem_main_categories as c    
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.idcat=c.id    
  LEFT JOIN l4rew_rem_houses AS h 
  ON h.id=hc.iditem

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM l4rew_modules AS m 
  LEFT JOIN l4rew_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN l4rew_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id 
  FROM l4rew_rem_main_categories AS cc

1 × SELECT *, COUNT(a.id) AS numlinks 
  FROM l4rew_rem_main_categories AS cc   JOIN l4rew_rem_categories AS hc 
  ON hc.idcat = cc.id   JOIN l4rew_rem_houses AS a 
  ON a.id = hc.iditem

1 × SELECT h.*,hc.idcat AS catid,hc.idcat AS idcat, c.title as category_title  
  FROM l4rew_rem_houses AS h  
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.iditem=h.id  
  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat

1 × SELECT COUNT(DISTINCT h.id)              
  FROM l4rew_rem_houses AS h 
  LEFT JOIN l4rew_rem_categories AS hc 
  ON hc.iditem=h.id 
  LEFT JOIN l4rew_rem_main_categories AS c 
  ON c.id=hc.idcat

1 × SELECT l.lang_code 
  FROM l4rew_languages as

1 × SELECT title, lang_code, sef 
  FROM l4rew_rem_language

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

```
1 × SELECT * 
  FROM l4rew_languages
```

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 l4rew_menu AS m 
  LEFT JOIN l4rew_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 l4rew_extensions

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

1 × SELECT id, rules 
  FROM `l4rew_viewlevels

1 × SELECT `key` 
  FROM l4rew_baforms_api

OTHER Tables:

1 × INSERT INTO `l4rew_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6365366234353932643134393263633539656366646433326439653962396261', 1, 1783954338, 0, '', 0

1 × UPDATE `l4rew_extensions` 
  SET `params` = '{\"mediaversion\":\"8a81649bd716e8622533c9bf5b796364\"}'

1 × SHOW FULL COLUMNS 
  FROM `l4rew_menu

1 × SHOW FULL COLUMNS 
  FROM `l4rew_rem_houses

1 × SHOW FULL COLUMNS 
  FROM `l4rew_rem_main_categories

Message

For Sale

To Rent

Info

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

70 Queries Logged 48.99 ms

21 duplicate found!

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: