Winner of an international design
competition which saw dozens of entries and
several brilliant concepts, Absoluteworld is like nothing ever seen before.
SOPHISTICATED BOUTIQUE CONDOMINIUMS
IN UPTOWN OAKVILLE

Condominiums coming soon to Dundas & Sixth Line
Register Now
SOUTH CALEDON'S
PREMIUM COMMUNITY

2 Car Garage Townhomes,
30' & 38' Detached Homes Coming Soon
Register Now
LIVE WHERE YOU PLAY AND RE-DISCOVER THE THING YOU VALUE MOST IN SOUTH BARRIE

Presentation Centre Now Open at Mapleview Drive E. and 20th Sideroad
Register Now
60' Custom Quality Estate Homes

NOW SELLING IN SOUTH WEST OAKVILLE
Register Now
Natural Enclave Living in Oakville

Coming Soon to Burnhamthorpe Rd. & Sixth Line
Register Now
New Release Coming This Spring

Towns and Singles at Bronte Rd. and Upper Middle Rd.
Register Now
Modern. Ravine. Enclave.

at a convenient West Toronto Location

Last Chance to Purchase Custom Quality Ravine Semis and Towns
Register Now
A SPECIAL RESERVE OF CUSTOM QUALITY
ESTATE HOMES AT YONGE ST. & BLOOMINGTON RD.

Now Selling in Aurora
Register Now
Stylish Family Sized Townhomes in the Heart of Guelph

Presentation Centre Now Open
Register Now
Luxury Homes Next to the Grand River in Paris

Presentation Centre Now Open
Register Now
Prestigious Enclave Residences
In The Heart Of Rockwood

Now Selling Freehold townhomes, 36' and 40' Singles
REGISTER NOW
Elegance and Sophistication

A New Standard of
Architectural Excellence
REGISTER NOW
SURROUNDED BY NATURE. IMMERSED IN LUXURY.

A LIMITED COLLECTION OF RAVINE HOMES AT FOREST CREEK
Register Now
Estate Residences on Unprecedented 100' wide lots

Now Selling in South Oakville
Register Now
36', 42' and 50' Singles in Innisfil steps from the Water

Presentation Centre Now Open
REGISTER NOW

Led by industry visionary Danny Salvatore, and his son Joe, Fernbrook Homes has an eye for design that transcends the typical.
Winner of an international design competition which saw dozens of entries and several brilliant concepts, Absoluteworld is like nothing ever seen before.
SOPHISTICATED BOUTIQUE CONDOMINIUMS IN UPTOWN OAKVILLE

Condominiums coming soon to Dundas & Sixth Line
Register Now
SOUTH CALEDON'S
PREMIUM COMMUNITY

2 Car Garage Townhomes,
30' & 38' Detached Homes Coming Soon
Register Now
LIVE WHERE YOU PLAY AND RE-DISCOVER THE THING YOU VALUE MOST IN SOUTH BARRIE

Presentation Centre Now Open at Mapleview Drive E. and 20th Sideroad
Register Now
60' Custom Quality Estate Homes

NOW SELLING IN SOUTH WEST OAKVILLE
Register Now
Natural Enclave Living in Oakville

Coming Soon to Burnhamthorpe Rd. & Sixth Line
Register Now
New Release Coming This Spring

Towns and Singles at Bronte Rd. and Upper Middle Rd.
Register Now
Modern. Ravine. Enclave.

at a convenient West Toronto Location

Last Chance to Purchase Custom Quality Ravine Semis and Towns
Register Now
A SPECIAL RESERVE OF CUSTOM QUALITY ESTATE HOMES AT YONGE ST. & BLOOMINGTON RD.

Now Selling In Aurora
Register Now
Stylish Family Sized Townhomes in the Heart of Guelph

Presentation Centre Now Open
Register Now
Luxury Homes Next to The Grand River in Paris

Presentation Centre Now Open
Register Now
Prestigious Enclave Residences In The Heart Of Rockwood

Now Selling Freehold townhomes, 36' and 40' Singles
REGISTER NOW
Elegance and Sophistication

A New Standard of Architectural Excellence
REGISTER NOW
SURROUNDED BY NATURE. IMMERSED IN LUXURY.

A LIMITED COLLECTION OF RAVINE HOMES AT FOREST CREEK
Register Now
te Residences on Unprecedented 100' wide lots

NOW SELLING IN SOUTH OAKVILLE
Register Now
36', 42' and 50' Singles in Innisfil steps from the Water

Presentation Centre Now Open
REGISTER NOW

Featured Community of the Month

Discover Our Communities

Oakville
Oakville
The Crawford
Toronto
Rockwood
Paris
Oakville
Guelph
Thornhill
Milton
Oakville
Toronto
FOREST CREEK
Oakville - SOLD OUT
Oakville
Oakville
Caledon
Toronto
Pickering
Innisfil
Oakville
Vaughan
Cambridge
East Gwillimbury
North Toronto
Toronto
Aurora
Oakville - SOLD OUT
Florida
Georgetown
Toronto

The Fernbrook Difference

We take care of you.

Fernbrook Homes is one of Canada's leading builders, widely acclaimed for their impressive collection of distinguished communities. With a keen understanding of homebuyers' personal preferences, Fernbrook has garnered an exceptional reputation for architectural integrity, classic design and custom-style luxury in a host of Southern Ontario locations extending across Metro and beyond.

Led by industry visionary Danny Salvatore, and his son Joe, Fernbrook Homes has an eye for design that transcends the typical. This is proudly on display both in the company’s distinguished low-rise communities, and in its more recent involvement in the condominium market. Fernbrook’s landmark high-rises are iconic symbols that epitomize Toronto’s soaring new cityscape.

Creating the finest new home communities is no simple task. Especially when each one must live up to the Fernbrook reputation for excellence. Creating a work of art requires imagination, talent and lots of hard work. First, the location must be perfect. Next, the company's planners, architects, and managers must have the imagination and expertise to conceive of a community with its own special character, as a unique and master planned and unified whole. And then there are the homes that are completely integrated, self-contained total lifestyle environments providing their owners with all the comforts, luxuries and conveniences that make life enjoyable.

Danny Salvatore and Joe Salvatore
Founder & Chairman and President & CEO of Fernbrook Homes

headerimage danny joe

Over Four Decades of Success

Since 1981, we have developed more than 52 million square feet of residential real estate, including 4 million square feet of condominiums
and have built more than 35,000 single-family homes in 100 different communities throughout Canada.

Past

Current

Future

A splendid synthesis of surf, sand, sun and style. How does one improve on something as perfect as that which nature has already gifted us? It’s rare, but once in a while it happens. And when it does the result is transformative, giving us an even deeper appreciation for the world around us.

Fernbrook Homes
2220 Hwy 7 West, Unit 5
Concord, Ontario L4K 1W7
416-667-0447

Condos

Residential Communities

Covid Popup

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1606517066,
                "last": 1606517066,
                "now": 1606517066
            },
            "token": "4HDRD0OxOTUNSAwvtx6b4joMhSdhh94F"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 4.37 ms / 4.37 ms Memory: 0.513 MB / 0.89 MB Application: afterLoad

Time: 50.03 ms / 54.40 ms Memory: 1.937 MB / 2.83 MB Application: afterInitialise

Time: 28.99 ms / 83.39 ms Memory: 1.935 MB / 4.76 MB Application: afterRoute

Time: 0.87 ms / 84.26 ms Memory: 0.018 MB / 4.78 MB Application: beforeRenderComponent com_focalpoint

Time: 120.16 ms / 204.42 ms Memory: 2.939 MB / 7.72 MB Application: afterRenderComponent com_focalpoint

Time: 0.26 ms / 204.68 ms Memory: 0.005 MB / 7.72 MB Application: Before Access::preloadComponents (all components)

Time: 1.90 ms / 206.58 ms Memory: 0.064 MB / 7.79 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 206.61 ms Memory: 0.000 MB / 7.78 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.31 ms / 206.92 ms Memory: 0.071 MB / 7.86 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 4.00 ms / 210.91 ms Memory: 0.043 MB / 7.90 MB Application: afterDispatch

Time: 10.99 ms / 221.90 ms Memory: 0.610 MB / 8.51 MB Application: beforeRenderModule mod_widgetkit (Slideshow | Home)

Time: 6.92 ms / 228.83 ms Memory: 0.129 MB / 8.64 MB Application: afterRenderModule mod_widgetkit (Slideshow | Home)

Time: 0.04 ms / 228.86 ms Memory: 0.000 MB / 8.64 MB Application: beforeRenderModule mod_widgetkit (Slideshow | Home | MOBILE)

Time: 5.60 ms / 234.47 ms Memory: 0.037 MB / 8.67 MB Application: afterRenderModule mod_widgetkit (Slideshow | Home | MOBILE)

Time: 0.08 ms / 234.55 ms Memory: 0.002 MB / 8.68 MB Application: beforeRenderModule mod_custom (Community Logos + Featured | HOME PAGE)

Time: 13.06 ms / 247.61 ms Memory: 0.122 MB / 8.80 MB Application: afterRenderModule mod_custom (Community Logos + Featured | HOME PAGE)

Time: 0.08 ms / 247.69 ms Memory: 0.000 MB / 8.80 MB Application: beforeRenderModule mod_custom (Content | HOME PAGE)

Time: 0.31 ms / 248.00 ms Memory: 0.004 MB / 8.80 MB Application: afterRenderModule mod_custom (Content | HOME PAGE)

Time: 0.04 ms / 248.04 ms Memory: 0.000 MB / 8.80 MB Application: beforeRenderModule mod_custom (Joe & Danny | HOMEPAGE)

Time: 0.31 ms / 248.35 ms Memory: 0.003 MB / 8.81 MB Application: afterRenderModule mod_custom (Joe & Danny | HOMEPAGE)

Time: 0.11 ms / 248.47 ms Memory: 0.003 MB / 8.81 MB Application: beforeRenderModule mod_custom (Florida Title | Home)

Time: 0.53 ms / 248.99 ms Memory: 0.003 MB / 8.81 MB Application: afterRenderModule mod_custom (Florida Title | Home)

Time: 0.07 ms / 249.06 ms Memory: 0.001 MB / 8.81 MB Application: beforeRenderModule mod_focalpointlocationmap (Florida - FocalPoint)

Time: 2.55 ms / 251.62 ms Memory: 0.042 MB / 8.85 MB Application: afterRenderModule mod_focalpointlocationmap (Florida - FocalPoint)

Time: 0.08 ms / 251.70 ms Memory: 0.000 MB / 8.84 MB Application: beforeRenderModule mod_custom (Bottom Footer)

Time: 0.32 ms / 252.01 ms Memory: 0.003 MB / 8.85 MB Application: afterRenderModule mod_custom (Bottom Footer)

Time: 0.04 ms / 252.05 ms Memory: 0.000 MB / 8.85 MB Application: beforeRenderModule mod_custom (Condos)

Time: 0.32 ms / 252.37 ms Memory: 0.003 MB / 8.85 MB Application: afterRenderModule mod_custom (Condos)

Time: 0.04 ms / 252.41 ms Memory: 0.000 MB / 8.85 MB Application: beforeRenderModule mod_custom (Residential Communities)

Time: 0.30 ms / 252.71 ms Memory: 0.003 MB / 8.85 MB Application: afterRenderModule mod_custom (Residential Communities)

Time: 0.08 ms / 252.79 ms Memory: 0.002 MB / 8.86 MB Application: beforeRenderModule mod_custom (Community Map | HOME)

Time: 0.54 ms / 253.33 ms Memory: 0.003 MB / 8.86 MB Application: afterRenderModule mod_custom (Community Map | HOME)

Time: 3.15 ms / 256.49 ms Memory: 0.055 MB / 8.91 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.31 ms / 256.80 ms Memory: 0.006 MB / 8.92 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.28 ms / 257.08 ms Memory: 0.003 MB / 8.92 MB Application: beforeRenderModule mod_menu (Menu)

Time: 8.70 ms / 265.78 ms Memory: 0.579 MB / 9.50 MB Application: afterRenderModule mod_menu (Menu)

Time: 4.57 ms / 270.35 ms Memory: 0.021 MB / 9.52 MB Application: beforeRenderModule mod_custom (Logo Mobile)

Time: 0.32 ms / 270.67 ms Memory: 0.003 MB / 9.53 MB Application: afterRenderModule mod_custom (Logo Mobile)

Time: 3.37 ms / 274.04 ms Memory: 0.081 MB / 9.61 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 0.55 ms / 274.60 ms Memory: 0.010 MB / 9.62 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.04 ms / 274.64 ms Memory: 0.000 MB / 9.61 MB Application: beforeRenderModule mod_custom (Copyright (Home))

Time: 0.31 ms / 274.95 ms Memory: 0.003 MB / 9.62 MB Application: afterRenderModule mod_custom (Copyright (Home))

Time: 0.80 ms / 275.75 ms Memory: 0.009 MB / 9.63 MB Application: beforeRenderModule mod_popupaholic (Covid Popup)

Time: 1.14 ms / 276.89 ms Memory: 0.015 MB / 9.64 MB Application: afterRenderModule mod_popupaholic (Covid Popup)

Time: 0.05 ms / 276.94 ms Memory: 0.000 MB / 9.63 MB Application: beforeRenderModule mod_menu (Menu | MOBILE)

Time: 4.19 ms / 281.13 ms Memory: 0.027 MB / 9.66 MB Application: afterRenderModule mod_menu (Menu | MOBILE)

Time: 89.70 ms / 370.83 ms Memory: 1.771 MB / 11.43 MB Application: afterRender

Database queries total: 108.33 ms

Memory Usage

Database Queries

136 Queries Logged 108.33 ms

13 duplicate found!

11 duplicates: #22 #23 #24 #25 #26 #27 #28 #30 #31 #32 #35

2 duplicates: #29 #33

Query Time: 0.44 ms Query memory: 0.023 MB Memory before query: 1.254 MB Rows returned: 0

SELECT `data`

  FROM `hcl_session`

  WHERE `session_id` = X'3937366339333261383438666239646364383837393237366266343236313131'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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.90 ms Query memory: 0.020 MB Memory before query: 1.271 MB Rows returned: 0

SELECT `session_id`

  FROM `hcl_session`

  WHERE `session_id` = X'3937366339333261383438666239646364383837393237366266343236313131' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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: 6.47 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.276 MB

INSERT INTO `hcl_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3937366339333261383438666239646364383837393237366266343236313131', 1, 1606517066, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `hcl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3937366339333261383438666239646364383837393237366266343236313131', 1, 1606517066, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.87 ms After last query: 0.88 ms Query memory: 0.025 MB Memory before query: 1.374 MB Rows returned: 46

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

  FROM `hcl_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_extensions	NULL	ref	extension	extension	82	const	49	1.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.79 ms Query memory: 0.021 MB Memory before query: 1.411 MB Rows returned: 3

SELECT id, rules

  FROM `hcl_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.51 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.422 MB Rows returned: 1

SELECT b.id

  FROM hcl_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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: 1.59 ms After last query: 0.18 ms Query memory: 0.035 MB Memory before query: 1.444 MB Rows returned: 130

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

  FROM hcl_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_extensions	NULL	ref	extension	extension	82	const	159	0.40	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php: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.52 ms After last query: 16.38 ms Query memory: 0.025 MB Memory before query: 2.536 MB Rows returned: 1

SELECT id,template 
  FROM hcl_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_template_styles	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.39 ms After last query: 5.72 ms Query memory: 0.022 MB Memory before query: 2.781 MB Rows returned: 0

select email 
  from hcl_users 
  where id=-1 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:246
12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:253
11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:367
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.44 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.789 MB Rows returned: 0

SELECT id, ipaddress 
  from hcl_bfstop_whitelist 
  WHERE (ipaddress='18.213.192.104' 
  AND LOCATE('/', ipaddress) = 0)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:189
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.021 MB Memory before query: 2.795 MB Rows returned: 0

SELECT id, ipaddress 
  from hcl_bfstop_whitelist 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('18.213.192.104') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:190
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.76 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.802 MB Rows returned: 0

SELECT id, ipaddress, crdate, duration 
  FROM hcl_bfstop_bannedip b 
  WHERE (ipaddress='18.213.192.104' 
  AND LOCATE('/', ipaddress) = 0) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2020-11-27 17:44:27') 
  AND NOT EXISTS (SELECT 1 
  FROM hcl_bfstop_unblock u 
  WHERE b.id = u.block_id)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	b	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1978	10.00	Using where
2	DEPENDENT SUBQUERY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	fernbroo.b.id	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:179
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.31 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 2.808 MB Rows returned: 0

SELECT id, ipaddress, crdate, duration 
  FROM hcl_bfstop_bannedip b 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('18.213.192.104') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2020-11-27 17:44:27') 
  AND NOT EXISTS (SELECT 1 
  FROM hcl_bfstop_unblock u 
  WHERE b.id = u.block_id)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	b	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1978	100.00	Using where
2	DEPENDENT SUBQUERY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	fernbroo.b.id	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:180
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 5.40 ms After last query: 0.89 ms Query memory: 0.372 MB Memory before query: 2.921 MB Rows returned: 407

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

  LEFT JOIN hcl_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	539	9.07	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	fernbroo.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.56 ms After last query: 8.32 ms Query memory: 0.025 MB Memory before query: 4.509 MB Rows returned: 1

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

  FROM `hcl_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/zooseo/zooseo.php:520
9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:100
8	plgSystemZooSeo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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: 4.79 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 4.502 MB

UPDATE `hcl_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	hcl_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/zooseo/zooseo.php:520
9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:100
8	plgSystemZooSeo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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.64 ms After last query: 4.00 ms Query memory: 0.023 MB Memory before query: 4.694 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM hcl_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	4	1.25	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	fernbroo.e.element	1	62.50	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
12	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_widgetkit/widgetkit.php:43
11	plgSystemWidgetkit->{closure}()	Same as call in the line below.
10	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
9	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:132
8	YOOtheme\Framework\Application->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/JoomlaPlugin.php:141
7	YOOtheme\Framework\Joomla\JoomlaPlugin->init()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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.52 ms After last query: 4.60 ms Query memory: 0.019 MB Memory before query: 4.770 MB Rows returned: 1

SELECT *

  FROM hcl_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/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: 1.06 ms After last query: 7.83 ms Query memory: 0.027 MB Memory before query: 4.975 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `hcl_focalpoint_maps`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_focalpoint/tables/map.php:45
14	FocalpointTablemap->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_focalpoint/models/map.php:112
12	FocalpointModelMap->getTable()	JROOT/components/com_focalpoint/models/map.php:64
11	FocalpointModelMap->getData()	JROOT/components/com_focalpoint/views/map/view.html.php:65
10	FocalpointViewMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_focalpoint/controller.php:42
8	FocalpointController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_focalpoint/focalpoint.php:30
6	require_once JROOT/components/com_focalpoint/focalpoint.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.44 ms After last query: 1.12 ms Query memory: 0.023 MB Memory before query: 5.005 MB Rows returned: 1

SELECT *

  FROM hcl_focalpoint_maps

  WHERE `id` = '8'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hcl_focalpoint_maps	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_focalpoint/models/map.php:65
11	FocalpointModelMap->getData()	JROOT/components/com_focalpoint/views/map/view.html.php:65
10	FocalpointViewMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_focalpoint/controller.php:42
8	FocalpointController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_focalpoint/focalpoint.php:30
6	require_once JROOT/components/com_focalpoint/focalpoint.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: 20.43 ms After last query: 1.50 ms Query memory: 0.146 MB Memory before query: 5.084 MB Rows returned: 144

Winner of an international design competition which saw dozens of entries and several brilliant concepts, Absoluteworld is like nothing ever seen before.

SOPHISTICATED BOUTIQUE CONDOMINIUMS IN UPTOWN OAKVILLE

Condominiums coming soon to Dundas & Sixth Line

SOUTH CALEDON'S PREMIUM COMMUNITY

2 Car Garage Townhomes,30' & 38' Detached Homes Coming Soon

LIVE WHERE YOU PLAY AND RE-DISCOVER THE THING YOU VALUE MOST IN SOUTH BARRIE

Presentation Centre Now Open at Mapleview Drive E. and 20th Sideroad

60' Custom Quality Estate Homes

NOW SELLING IN SOUTH WEST OAKVILLE

Natural Enclave Living in Oakville

Coming Soon to Burnhamthorpe Rd. & Sixth Line

New Release Coming This Spring

Towns and Singles at Bronte Rd. and Upper Middle Rd.

Modern. Ravine. Enclave.

at a convenient West Toronto Location

Last Chance to Purchase Custom Quality Ravine Semis and Towns

A SPECIAL RESERVE OF CUSTOM QUALITY ESTATE HOMES AT YONGE ST. & BLOOMINGTON RD.

Now Selling in Aurora

Stylish Family Sized Townhomes in the Heart of Guelph

Presentation Centre Now Open

Luxury Homes Next to the Grand River in Paris

Presentation Centre Now Open

Prestigious Enclave Residences In The Heart Of Rockwood

Now Selling Freehold townhomes, 36' and 40' Singles

Elegance and Sophistication

A New Standard ofArchitectural Excellence

SURROUNDED BY NATURE. IMMERSED IN LUXURY.

A LIMITED COLLECTION OF RAVINE HOMES AT FOREST CREEK

Estate Residences on Unprecedented 100' wide lots

Now Selling in South Oakville

36', 42' and 50' Singles in Innisfil steps from the Water

Presentation Centre Now Open

Led by industry visionary Danny Salvatore, and his son Joe, Fernbrook Homes has an eye for design that transcends the typical.

Winner of an international design competition which saw dozens of entries and several brilliant concepts, Absoluteworld is like nothing ever seen before.

SOPHISTICATED BOUTIQUE CONDOMINIUMS IN UPTOWN OAKVILLE

Condominiums coming soon to Dundas & Sixth Line

SOUTH CALEDON'S PREMIUM COMMUNITY

2 Car Garage Townhomes,30' & 38' Detached Homes Coming Soon

LIVE WHERE YOU PLAY AND RE-DISCOVER THE THING YOU VALUE MOST IN SOUTH BARRIE

Presentation Centre Now Open at Mapleview Drive E. and 20th Sideroad

60' Custom Quality Estate Homes

NOW SELLING IN SOUTH WEST OAKVILLE

Natural Enclave Living in Oakville

Coming Soon to Burnhamthorpe Rd. & Sixth Line

New Release Coming This Spring

Towns and Singles at Bronte Rd. and Upper Middle Rd.

Modern. Ravine. Enclave.

at a convenient West Toronto Location

Last Chance to Purchase Custom Quality Ravine Semis and Towns

A SPECIAL RESERVE OF CUSTOM QUALITY ESTATE HOMES AT YONGE ST. & BLOOMINGTON RD.

Now Selling In Aurora

Stylish Family Sized Townhomes in the Heart of Guelph

Presentation Centre Now Open

Luxury Homes Next to The Grand River in Paris

Presentation Centre Now Open

Prestigious Enclave Residences In The Heart Of Rockwood

Now Selling Freehold townhomes, 36' and 40' Singles

Elegance and Sophistication

A New Standard of Architectural Excellence

SURROUNDED BY NATURE. IMMERSED IN LUXURY.

A LIMITED COLLECTION OF RAVINE HOMES AT FOREST CREEK

te Residences on Unprecedented 100' wide lots

NOW SELLING IN SOUTH OAKVILLE

36', 42' and 50' Singles in Innisfil steps from the Water

Presentation Centre Now Open

Featured Community of the Month

Discover Our Communities

The Fernbrook Difference

We take care of you.

Over Four Decades of Success

Since 1981, we have developed more than 52 million square feet of residential real estate, including 4 million square feet of condominiumsand have built more than 35,000 single-family homes in 100 different communities throughout Canada.

Past

Current

Future

Condos

Residential Communities

Covid Popup

PRESENTATION CENTRES NOW OPEN

Joomla! Debug Console

Session

Winner of an international design
competition which saw dozens of entries and
several brilliant concepts, Absoluteworld is like nothing ever seen before.

SOPHISTICATED BOUTIQUE CONDOMINIUMS
IN UPTOWN OAKVILLE

SOUTH CALEDON'S
PREMIUM COMMUNITY

2 Car Garage Townhomes,
30' & 38' Detached Homes Coming Soon

A SPECIAL RESERVE OF CUSTOM QUALITY
ESTATE HOMES AT YONGE ST. & BLOOMINGTON RD.

Prestigious Enclave Residences
In The Heart Of Rockwood

A New Standard of
Architectural Excellence

SOUTH CALEDON'S
PREMIUM COMMUNITY

2 Car Garage Townhomes,
30' & 38' Detached Homes Coming Soon

Since 1981, we have developed more than 52 million square feet of residential real estate, including 4 million square feet of condominiums
and have built more than 35,000 single-family homes in 100 different communities throughout Canada.