Home

THE LOCAVORE | STIRLING, ADELAIDE HILLS

The Locavore is a small family owned and run restaurant in Stirling, Adelaide Hills.

Specialising in locally sourced produce we strive to live by the '100 mile diet' using produce grown within a 100 mile (160 km) radius of the restaurant itself as often as possible.

We serve Berkshire Pork from the Barrossa, Lamb from the Adelaide Hills and Fleurieu Peninsula, Beef from the Murrylands, Poultry from Forest Range (Adelaide Hills), seafood from Spencer and St Vincent Gulfs as well as from the Coorong. Our cheese is from La Casa Del Formaggio based in Glynde and Udder Delights based in Hahndorf and all of our fresh produce is from either the hills or the northern farms.

We only stock wine and beer from South Australian regions and breweries. Most of our spirits come from South Australia however we do stock Whiskey and Rum from some small distilleries in Tasmania and New South Wales.

We are open for dinner Wednesday to Saturday and lunch Wednesday to Sunday, so come on through to try some of the best our state has to offer!

Book now for a group dinner
or
function for Christmas

$22 Burger Special
Weekdays Lunch & Dinner

Opening Hours

Lunch | Wednesday - Sunday
Dinner | Wednesday - Saturday

GIVING BACK TO THE COMMUNITY

Being part of such a close-knit community like the Adelaide Hills is important to us. As such we do our part to support and sponsor a number of local groups including

Heathfield Netball Club

Heathfield High School Volleyball Program

Stirling East Primary School

Mt Lofty Football Club

YOUR PLACE OR OURS?

At Locavore we can work with you to tailor any event to your needs.

Whether you're looking for a venue to host your event or looking for someone to cater for you wherever you need it, we have options to suit most occasions and budgets.

Download our catering & function information pack here (PDF)

EAT & DRINK

These menu's are a sample and change according to availability and seasonality.

Food Menu

Dessert Menu

Wine Menu

Kids Menu

Our Suppliers

The Australian Olive Company

Hahndorf Venison

Nature's Chicken

Hahndorf Fruit & Veg Market

Barossa Fine Foods

La Casa del Formaggio

Pao Fresco Bakery

Tweedvale Milk

Udder Delights Cheese

Brasilia Coffee

Dine With Us

Mon - Closed

Tue - Closed

Wed, Thurs & Fri - Lunch & Dinner

Sat - Kitchen open all day from 12 noon

Sun - Lunch Only

Christmas Day - Closed
Boxing Day - Closed
New Years Day - Closed

Find Us

49 Mount Barker Rd,
Stirling SA 5152

PH: (08) 8339 4416

Trading times may vary on public holidays. Please feel free to call with any enquiries.

A 15% surcharge will be added to all bills on public holidays.

Email Us

Email *
Name *
Message *
Help us prevent SPAM! *

Keep up with our latest

Joomla! Debug Console

Session

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

Memory Usage

Database Queries

22 Queries Logged 290.43 ms

Query Time: 0.94 ms Query memory: 0.025 MB Memory before query: 1.531 MB Rows returned: 0

SELECT `data`

  FROM `chdg4_session`

  WHERE `session_id` = X'7130643665686d71376f386761387166396961336a6364336532'

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.04 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php: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.80 ms After last query: 6.07 ms Query memory: 0.022 MB Memory before query: 1.547 MB Rows returned: 0

SELECT `session_id`

  FROM `chdg4_session`

  WHERE `session_id` = X'7130643665686d71376f386761387166396961336a6364336532' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

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

INSERT INTO `chdg4_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'7130643665686d71376f386761387166396961336a6364336532', 1, 1701246538, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7130643665686d71376f386761387166396961336a6364336532', 1, 1701246538, 0, '', 0)

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.04 ms
Update	0.21 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	33.36 ms
Closing tables	0.06 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

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

SELECT id, rules

  FROM `chdg4_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.19 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

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

SELECT b.id

  FROM chdg4_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.27 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.07 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

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

SELECT `value`

  FROM `chdg4_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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.03 ms After last query: 8.56 ms Query memory: 0.024 MB Memory before query: 2.472 MB Rows returned: 0

SELECT *

  FROM `chdg4_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profile

Status	Duration
Starting	0.13 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.15 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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.97 ms After last query: 93.88 ms Query memory: 0.024 MB Memory before query: 2.955 MB Rows returned: 0

SELECT *

  FROM `chdg4_admintools_ipautoban`

  WHERE `ip` = '3.233.221.90'

Explain

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

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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.90 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 2.961 MB Rows returned: 51

SELECT `ip`

  FROM `chdg4_admintools_ipblock`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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.86 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 2.968 MB Rows returned: 1

SELECT *

  FROM `chdg4_admintools_storage`

  WHERE `key` LIKE 'timestamp_%'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	1	Using where

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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.97 ms After last query: 213.84 ms Query memory: 0.023 MB Memory before query: 2.977 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `chdg4_admintools_redirects`

  WHERE ((`dest` = '') OR (`dest` = '') OR ('' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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.83 ms After last query: 0.46 ms Query memory: 0.022 MB Memory before query: 2.982 MB Rows returned: 1

SELECT `lastupdate`

  FROM `chdg4_ak_storage`

  WHERE `tag` = 'akeebaupdatecheck_lastrun'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_ak_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:81
8	plgSystemAkeebaupdatecheck->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.97 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 2.986 MB Rows returned: 1

SELECT `template`

  FROM `chdg4_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

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

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.16 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->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: 89.37 ms After last query: 43.22 ms Query memory: 0.026 MB Memory before query: 3.294 MB Rows returned: 1

SELECT *

  FROM `chdg4_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('','com_sppagebuilder') 
  AND `view` IN('','page') 
  AND `task` IN('','page.') 
  AND `enabled` = '1'

  GROUP BY `query`

  ORDER BY `query` ASC

Explain

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

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	87.78 ms
Preparing	0.27 ms
Creating tmp table	0.13 ms
Sorting result	0.06 ms
Executing	0.03 ms
Sending data	0.19 ms
Creating sort index	0.05 ms
Removing tmp table	0.03 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.04 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:87
10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
8	plgSystemAdmintools->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: 32.96 ms After last query: 3.48 ms Query memory: 0.005 MB Memory before query: 3.364 MB

UPDATE `chdg4_extensions`

  SET `params` = '{\"mediaversion\":\"4988650fe2c69b85cad453c0bbddb363\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `chdg4_extensions` SET `params` = '{\"mediaversion\":\"4988650fe2c69b85cad453c0bbddb363\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.24 ms
Updating	0.21 ms
End of update loop	0.07 ms
Query end	0.03 ms
Commit	31.83 ms
Closing tables	0.05 ms
Unlocking tables	0.02 ms
Closing tables	0.06 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php: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: 1.46 ms After last query: 39.49 ms Query memory: 0.030 MB Memory before query: 3.591 MB Rows returned: 39

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

  FROM `chdg4_assets`

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

Explain

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

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.12 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.45 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
11	SppagebuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sppagebuilder/models/page.php:175
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.17 ms After last query: 3.72 ms Query memory: 0.032 MB Memory before query: 3.719 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `chdg4_sppagebuilder`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	1.02 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
Checking permissions	0.18 ms
Closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.20 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
11	SppagebuilderTablePage->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.01 ms After last query: 2.25 ms Query memory: 0.148 MB Memory before query: 3.776 MB Rows returned: 1

SELECT *

  FROM chdg4_sppagebuilder

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_sppagebuilder	const	PRIMARY	PRIMARY	8	const	1

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.19 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	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_sppagebuilder/models/page.php:177
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 112.40 ms After last query: 0.30 ms Query memory: 0.005 MB Memory before query: 3.901 MB

UPDATE chdg4_sppagebuilder

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explain

EXPLAIN not possible on query: UPDATE chdg4_sppagebuilder SET `hits` = (`hits` + 1) WHERE `id` = '1'

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init for update	0.06 ms
Updating	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	111.80 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 359.00 ms Query memory: 0.032 MB Memory before query: 11.937 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `chdg4_extensions`

Explain

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

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	1.12 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.06 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.15 ms
Closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.19 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

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/libraries/src/Table/Extension.php:32
14	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/modules/mod_simpleemailform/sefv2/formfactory.php:64
12	sefv2formfactory->createSefv2FormObject()	JROOT/modules/mod_simpleemailform/sefv2/helper.php:98
11	sefv2helper->buildForm()	JROOT/modules/mod_simpleemailform/mod_simpleemailform.php:50
10	include JROOT/modules/mod_simpleemailform/mod_simpleemailform.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:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
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: 1.98 ms After last query: 1.25 ms Query memory: 0.032 MB Memory before query: 11.983 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `chdg4_modules`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.97 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.15 ms
Closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.16 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

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/libraries/src/Table/Module.php:32
14	Joomla\CMS\Table\Module->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/modules/mod_simpleemailform/sefv2/formfactory.php:66
12	sefv2formfactory->createSefv2FormObject()	JROOT/modules/mod_simpleemailform/sefv2/helper.php:98
11	sefv2helper->buildForm()	JROOT/modules/mod_simpleemailform/mod_simpleemailform.php:50
10	include JROOT/modules/mod_simpleemailform/mod_simpleemailform.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:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
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.82 ms After last query: 277.54 ms Query memory: 0.023 MB Memory before query: 4.869 MB Rows returned: 1

SELECT `value`

  FROM `chdg4_admintools_storage`

  WHERE `key` = 'criticalfiles'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chdg4_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/admintools/feature/criticalfiles.php:204
10	AtsystemFeatureCriticalfiles->load()	JROOT/plugins/system/admintools/feature/criticalfiles.php:32
9	AtsystemFeatureCriticalfiles->onAfterRender()	JROOT/plugins/system/admintools/admintools/main.php:308
8	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:187
7	plgSystemAdmintools->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.]

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `value` 
  FROM `chdg4_admintools_storage`

1 × SELECT `data` 
  FROM `chdg4_session`

1 × SELECT `session_id` 
  FROM `chdg4_session`

1 × SELECT id, rules 
  FROM `chdg4_viewlevels

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

1 × SELECT * 
  FROM `chdg4_admintools_wafexceptions`

1 × SELECT * 
  FROM `chdg4_admintools_ipautoban`

1 × SELECT `ip` 
  FROM `chdg4_admintools_ipblock

1 × SELECT * 
  FROM `chdg4_admintools_storage`

1 × SELECT `source`,`keepurlparams` 
  FROM `chdg4_admintools_redirects`

1 × SELECT `lastupdate` 
  FROM `chdg4_ak_storage`

1 × SELECT `template` 
  FROM `chdg4_template_styles`

1 × SELECT * 
  FROM `chdg4_admintools_wafblacklists`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `chdg4_assets`

1 × SELECT * 
  FROM chdg4_sppagebuilder

OTHER Tables:

1 × INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'7130643665686d71376f386761387166396961336a6364336532', 1, 1701246538, 0, '', 0

1 × UPDATE `chdg4_extensions` 
  SET `params` = '{\"mediaversion\":\"4988650fe2c69b85cad453c0bbddb363\"}'

1 × SHOW FULL COLUMNS 
  FROM `chdg4_sppagebuilder

1 × UPDATE chdg4_sppagebuilder 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `chdg4_extensions

1 × SHOW FULL COLUMNS 
  FROM `chdg4_modules

THE LOCAVORE | STIRLING, ADELAIDE HILLS

Book now for a group dinner or function for Christmas

Opening Hours

Lunch | Wednesday - SundayDinner | Wednesday - Saturday

GIVING BACK TO THE COMMUNITY

YOUR PLACE OR OURS?

EAT & DRINK

Our Suppliers

The Australian Olive Company

Hahndorf Venison

Nature's Chicken

Hahndorf Fruit & Veg Market

Barossa Fine Foods

La Casa del Formaggio

Pao Fresco Bakery

Tweedvale Milk

Udder Delights Cheese

Brasilia Coffee

Dine With Us

Find Us

Email Us

Keep up with our latest

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

22 Queries Logged 290.43 ms

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Book now for a group dinner
or
function for Christmas

Lunch | Wednesday - Sunday
Dinner | Wednesday - Saturday