S. Calabrese Plumbing Service

No advert here.

Notice (8): Undefined variable: markericon [APP/View/Elements/business.ctp, line 41]Code Context    'latitude' => $mapLat,
    'longitude' => $mapLong,
    'markerIcon' => $markericon,
$viewFile = '/home/rogerdw/public_html/test/app/View/Elements/business.ctp'
$dataForView = array(
	'url_key' => 'files%2FBusiness%2Fs-calabrese-plumbing-service',
	'og_image_height' => (int) 82,
	'og_image_width' => (int) 720,
	'og_image' => 'img/logo.jpg',
	'og_title' => 'S. Calabrese Plumbing Service',
	'og_url' => array(),
	'keywords' => 'Murray Bridge, Community, Business, Directory , Search , ',
	'description' => 'Murray Bridge Community and Business Directory, where you can search for information on all businesses, groups, organisations, service and sporting clubs in Murray Bridge and surrounding districts. Including Mannum, Tailem Bend, Wellington, Callington, Mypolonga etc',
	'title_for_layout' => 'Murray Bridge - Community and Business Directory: business - S. Calabrese Plumbing Service',
	'menu_footers' => array(
		(int) 0 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 3 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 4 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 5 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 6 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 7 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		)
	),
	'menu_headers' => array(
		(int) 0 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 3 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		(int) 4 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Content' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		)
	),
	'debugToolbarPanels' => array(
		'history' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'history_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'session' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'session_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'request' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'request_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'sql_log' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'sql_log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'timer' => array(
			'content' => null,
			'elementName' => 'timer_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'log' => array(
			'content' => object(DebugKitLog) {},
			'elementName' => 'log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'variables' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'variables_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'environment' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'environment_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'include' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'include_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		)
	),
	'debugToolbarJavascript' => array(
		'libs' => 'DebugKit./js/js_debug_toolbar'
	),
	'debugToolbarCss' => array(
		(int) 0 => 'DebugKit./css/debug_toolbar.css'
	),
	'limit_ads_for_mobile' => true,
	'specials' => array(),
	'promotion' => array(),
	'headers' => array(),
	'footers' => array(),
	'ads' => array(),
	'business' => array(
		'Business' => array(
			'id' => '1646',
			'user_id' => '',
			'category_id_not_used' => '',
			'name' => 'S. Calabrese Plumbing Service',
			'first_letter' => 'S',
			'url_key' => 's-calabrese-plumbing-service',
			'address1' => '',
			'address2' => '',
			'city' => 'Murray Bridge',
			'state' => 'SA',
			'postcode' => '5253',
			'contact_name1' => null,
			'contact_number1' => null,
			'contact_name2' => null,
			'contact_number2' => null,
			'fax' => null,
			'mobile_name1' => null,
			'mobile1' => null,
			'mobile_name2' => null,
			'mobile2' => null,
			'email1' => null,
			'email2' => null,
			'website' => null,
			'mon_open' => '',
			'mon_close' => '',
			'mon_status' => '',
			'tue_open' => '',
			'tue_close' => '',
			'tue_status' => '',
			'wed_open' => '',
			'wed_close' => '',
			'wed_status' => '',
			'thu_open' => '',
			'thu_close' => '',
			'thu_status' => '',
			'fri_open' => '',
			'fri_close' => '',
			'fri_status' => '',
			'sat_open' => '',
			'sat_close' => '',
			'sat_status' => '',
			'sun_open' => '',
			'sun_close' => '',
			'sun_status' => '',
			'business_activity' => '<hr />
<p>The aim of&nbsp;S.Calabrese Plumbing Service&nbsp;is to provide an excellent plumbing service to our clients by:</p>

<ul>
	<li>Bathroom, Laundry and Kitchen Renovations&nbsp;</li>
	<li>Leaking Taps &amp; Toilets&nbsp;</li>
	<li>Blocked Toilets &amp; Drains&nbsp;</li>
	<li>Guttering and Downpipes</li>
	<li>Fixture Replacement</li>
	<li>Back-flow Prevention</li>
	<li>24/7 Emergency Response</li>
	<li>Recycled Water Systems</li>
	<li>Rain Water Tanks</li>
	<li>Hot Water Service &amp; Change Over</li>
	<li>Pre Purchase Plumbing Inspections</li>
</ul>
',
			'keyword' => '',
			'path' => '',
			'image' => null,
			'video' => '',
			'latitude' => ' -35.1200230',
			'longitude' => '139.27362927',
			'deleted' => '0',
			'created' => '2017-04-10 10:04:34',
			'modified' => '2017-06-18 01:28:08',
			'is_in_mb' => 'Y'
		),
		'Communication' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			)
		),
		'Category' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	)
)
$url_key = 'files%2FBusiness%2Fs-calabrese-plumbing-service'
$og_image_height = (int) 82
$og_image_width = (int) 720
$og_image = 'img/logo.jpg'
$og_title = 'S. Calabrese Plumbing Service'
$og_url = array()
$keywords = 'Murray Bridge, Community, Business, Directory , Search , '
$description = 'Murray Bridge Community and Business Directory, where you can search for information on all businesses, groups, organisations, service and sporting clubs in Murray Bridge and surrounding districts. Including Mannum, Tailem Bend, Wellington, Callington, Mypolonga etc'
$title_for_layout = 'Murray Bridge - Community and Business Directory: business - S. Calabrese Plumbing Service'
$menu_footers = array(
	(int) 0 => array(
		'Content' => array(
			'id' => '35',
			'parent_id' => '0',
			'name' => 'MB Directory Ph. Roger 0400 226 839',
			'order' => '50',
			'url_key' => 'mb-directory-ph-roger-0400-226-839'
		),
		'children' => array()
	),
	(int) 1 => array(
		'Content' => array(
			'id' => '9',
			'parent_id' => '0',
			'name' => 'Found Mistakes - Tell Us Here',
			'order' => '100',
			'url_key' => 'found-mistakes-tell-us-here'
		),
		'children' => array()
	),
	(int) 2 => array(
		'Content' => array(
			'id' => '10',
			'parent_id' => '0',
			'name' => 'Privacy Policy',
			'order' => '200',
			'url_key' => 'privacy-policy'
		),
		'children' => array()
	),
	(int) 3 => array(
		'Content' => array(
			'id' => '11',
			'parent_id' => '0',
			'name' => 'Terms Of Service',
			'order' => '300',
			'url_key' => 'terms-of-service'
		),
		'children' => array()
	),
	(int) 4 => array(
		'Content' => array(
			'id' => '12',
			'parent_id' => '0',
			'name' => 'FAQ',
			'order' => '400',
			'url_key' => 'faq'
		),
		'children' => array()
	),
	(int) 5 => array(
		'Content' => array(
			'id' => '31',
			'parent_id' => '0',
			'name' => 'Is Your Business Listed?',
			'order' => '600',
			'url_key' => 'is-your-business-listed'
		),
		'children' => array()
	),
	(int) 6 => array(
		'Content' => array(
			'id' => '33',
			'parent_id' => '0',
			'name' => 'Murray Bridge parkrun',
			'order' => '600',
			'url_key' => 'murray-bridge-parkrun'
		),
		'children' => array()
	),
	(int) 7 => array(
		'Content' => array(
			'id' => '38',
			'parent_id' => '0',
			'name' => 'Header Ad',
			'order' => '600',
			'url_key' => 'header-ad'
		),
		'children' => array()
	)
)
$menu_headers = array(
	(int) 0 => array(
		'Content' => array(
			'id' => '1',
			'parent_id' => '0',
			'open_content' => '1',
			'name' => 'Home',
			'order' => '100',
			'url_key' => 'home'
		),
		'children' => array()
	),
	(int) 1 => array(
		'Content' => array(
			'id' => '29',
			'parent_id' => '0',
			'open_content' => '0',
			'name' => 'Murray Bridge',
			'order' => '200',
			'url_key' => 'murray-bridge'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 2 => array(
		'Content' => array(
			'id' => '5',
			'parent_id' => '0',
			'open_content' => '1',
			'name' => 'Tourism',
			'order' => '300',
			'url_key' => 'tourism'
		),
		'children' => array()
	),
	(int) 3 => array(
		'Content' => array(
			'id' => '6',
			'parent_id' => '0',
			'open_content' => '1',
			'name' => 'Local Events',
			'order' => '400',
			'url_key' => 'local-events'
		),
		'children' => array()
	),
	(int) 4 => array(
		'Content' => array(
			'id' => '28',
			'parent_id' => '0',
			'open_content' => '0',
			'name' => 'Advertise',
			'order' => '400',
			'url_key' => 'advertise'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 5 => array(
		'Content' => array(
			'id' => '27',
			'parent_id' => '0',
			'open_content' => '0',
			'name' => 'Specials',
			'order' => '600',
			'url_key' => 'specials'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	)
)
$debugToolbarPanels = array(
	'history' => array(
		'content' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'history_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'session' => array(
		'content' => array(
			'Config' => array(
				[maximum depth reached]
			),
			'_Token' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'session_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'request' => array(
		'content' => array(
			'params' => array(
				[maximum depth reached]
			),
			'url' => 'businesses/view/s-calabrese-plumbing-service',
			'query' => array([maximum depth reached]),
			'data' => array(
				[maximum depth reached]
			),
			'cookie' => array([maximum depth reached]),
			'get' => array([maximum depth reached]),
			'currentRoute' => object(CakeRoute) {}
		),
		'elementName' => 'request_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'sql_log' => array(
		'content' => array(
			'connections' => array(
				[maximum depth reached]
			),
			'threshold' => (int) 20
		),
		'elementName' => 'sql_log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'timer' => array(
		'content' => null,
		'elementName' => 'timer_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'log' => array(
		'content' => object(DebugKitLog) {},
		'elementName' => 'log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'variables' => array(
		'content' => array(
			'limit_ads_for_mobile' => true,
			'specials' => array([maximum depth reached]),
			'promotion' => array([maximum depth reached]),
			'headers' => array([maximum depth reached]),
			'footers' => array([maximum depth reached]),
			'ads' => array([maximum depth reached]),
			'business' => array(
				[maximum depth reached]
			),
			'$request->data' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'variables_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'environment' => array(
		'content' => array(
			'php' => array(
				[maximum depth reached]
			),
			'cake' => array(
				[maximum depth reached]
			),
			'app' => array([maximum depth reached])
		),
		'elementName' => 'environment_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'include' => array(
		'content' => array(
			'core' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			),
			'plugins' => array(
				[maximum depth reached]
			),
			'paths' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'include_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	)
)
$debugToolbarJavascript = array(
	'libs' => 'DebugKit./js/js_debug_toolbar'
)
$debugToolbarCss = array(
	(int) 0 => 'DebugKit./css/debug_toolbar.css'
)
$limit_ads_for_mobile = true
$specials = array()
$promotion = array()
$headers = array()
$footers = array()
$ads = array()
$business = array(
	'Business' => array(
		'id' => '1646',
		'user_id' => '',
		'category_id_not_used' => '',
		'name' => 'S. Calabrese Plumbing Service',
		'first_letter' => 'S',
		'url_key' => 's-calabrese-plumbing-service',
		'address1' => '',
		'address2' => '',
		'city' => 'Murray Bridge',
		'state' => 'SA',
		'postcode' => '5253',
		'contact_name1' => null,
		'contact_number1' => null,
		'contact_name2' => null,
		'contact_number2' => null,
		'fax' => null,
		'mobile_name1' => null,
		'mobile1' => null,
		'mobile_name2' => null,
		'mobile2' => null,
		'email1' => null,
		'email2' => null,
		'website' => null,
		'mon_open' => '',
		'mon_close' => '',
		'mon_status' => '',
		'tue_open' => '',
		'tue_close' => '',
		'tue_status' => '',
		'wed_open' => '',
		'wed_close' => '',
		'wed_status' => '',
		'thu_open' => '',
		'thu_close' => '',
		'thu_status' => '',
		'fri_open' => '',
		'fri_close' => '',
		'fri_status' => '',
		'sat_open' => '',
		'sat_close' => '',
		'sat_status' => '',
		'sun_open' => '',
		'sun_close' => '',
		'sun_status' => '',
		'business_activity' => '<hr />
<p>The aim of&nbsp;S.Calabrese Plumbing Service&nbsp;is to provide an excellent plumbing service to our clients by:</p>

<ul>
	<li>Bathroom, Laundry and Kitchen Renovations&nbsp;</li>
	<li>Leaking Taps &amp; Toilets&nbsp;</li>
	<li>Blocked Toilets &amp; Drains&nbsp;</li>
	<li>Guttering and Downpipes</li>
	<li>Fixture Replacement</li>
	<li>Back-flow Prevention</li>
	<li>24/7 Emergency Response</li>
	<li>Recycled Water Systems</li>
	<li>Rain Water Tanks</li>
	<li>Hot Water Service &amp; Change Over</li>
	<li>Pre Purchase Plumbing Inspections</li>
</ul>
',
		'keyword' => '',
		'path' => '',
		'image' => null,
		'video' => '',
		'latitude' => ' -35.1200230',
		'longitude' => '139.27362927',
		'deleted' => '0',
		'created' => '2017-04-10 10:04:34',
		'modified' => '2017-06-18 01:28:08',
		'is_in_mb' => 'Y'
	),
	'Communication' => array(
		(int) 0 => array(
			'id' => '3067',
			'business_id' => '1646',
			'type' => 'Mobile',
			'name' => '',
			'detail' => '0437 478 292',
			'created' => '2017-04-10 10:04:34',
			'modified' => '2017-06-18 01:28:08'
		),
		(int) 1 => array(
			'id' => '3068',
			'business_id' => '1646',
			'type' => 'Email',
			'name' => '',
			'detail' => 'calabreseplumbing@yahoo.com.au',
			'created' => '2017-04-10 10:04:34',
			'modified' => '2017-06-18 01:28:08'
		),
		(int) 2 => array(
			'id' => '3069',
			'business_id' => '1646',
			'type' => 'Website',
			'name' => '',
			'detail' => 'www.calabreseplumbing.com.au/',
			'created' => '2017-04-10 10:07:39',
			'modified' => '2017-06-18 01:28:08'
		)
	),
	'Category' => array(
		(int) 0 => array(
			'id' => '320',
			'cat_code_not_used' => 'P22',
			'name' => 'Plumbers',
			'url_key' => 'plumbers',
			'first_letter' => 'P',
			'deleted' => '0',
			'created' => '0000-00-00 00:00:00',
			'modified' => '2013-11-12 02:39:27',
			'BusinessesCategory' => array(
				[maximum depth reached]
			)
		)
	)
)
$latitude = ' -35.1200230'
$longitude = '139.27362927'
$address1 = ''
$address2 = ''
$city = 'Murray Bridge'
$state = 'SA'
$zip = '5253'
$country = 'Australia'
$address = ', , Murray Bridge, 5253'
$mapLat = ' -35.1200230'
$mapLong = '139.27362927'
include - APP/View/Elements/business.ctp, line 41
View::_evaluate() - CORE/Cake/View/View.php, line 961
View::_render() - CORE/Cake/View/View.php, line 923
View::_renderElement() - CORE/Cake/View/View.php, line 1217
View::element() - CORE/Cake/View/View.php, line 418
include - APP/View/Businesses/view.ctp, line 11
View::_evaluate() - CORE/Cake/View/View.php, line 961
View::_render() - CORE/Cake/View/View.php, line 923
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 960
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118

S. Calabrese Plumbing Service

Murray Bridge, 5253

No image has
been uploaded.

Open map in new browser tab

Why not share this business on Facebook?

Contact
Mobile
	0437 478 292

Email
	calabreseplumbing@yahoo.com.au

Website
	www.calabreseplumbing.com.au/

Business hours
Mon
Tues
Wed
Thurs
Fri
Sat
Sun

The aim of S.Calabrese Plumbing Service is to provide an excellent plumbing service to our clients by:

Bathroom, Laundry and Kitchen Renovations
Leaking Taps & Toilets
Blocked Toilets & Drains
Guttering and Downpipes
Fixture Replacement
Back-flow Prevention
24/7 Emergency Response
Recycled Water Systems
Rain Water Tanks
Hot Water Service & Change Over
Pre Purchase Plumbing Inspections

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`deleted`, `Setting`.`created`, `Setting`.`modified` FROM `rogerdw_murraybridge_test`.`settings` AS `Setting` WHERE 1 = 1	32	32	0
SELECT `Business`.`id`, `Business`.`user_id`, `Business`.`category_id_not_used`, `Business`.`name`, `Business`.`first_letter`, `Business`.`url_key`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`postcode`, `Business`.`contact_name1`, `Business`.`contact_number1`, `Business`.`contact_name2`, `Business`.`contact_number2`, `Business`.`fax`, `Business`.`mobile_name1`, `Business`.`mobile1`, `Business`.`mobile_name2`, `Business`.`mobile2`, `Business`.`email1`, `Business`.`email2`, `Business`.`website`, `Business`.`mon_open`, `Business`.`mon_close`, `Business`.`mon_status`, `Business`.`tue_open`, `Business`.`tue_close`, `Business`.`tue_status`, `Business`.`wed_open`, `Business`.`wed_close`, `Business`.`wed_status`, `Business`.`thu_open`, `Business`.`thu_close`, `Business`.`thu_status`, `Business`.`fri_open`, `Business`.`fri_close`, `Business`.`fri_status`, `Business`.`sat_open`, `Business`.`sat_close`, `Business`.`sat_status`, `Business`.`sun_open`, `Business`.`sun_close`, `Business`.`sun_status`, `Business`.`business_activity`, `Business`.`keyword`, `Business`.`path`, `Business`.`image`, `Business`.`video`, `Business`.`latitude`, `Business`.`longitude`, `Business`.`deleted`, `Business`.`created`, `Business`.`modified`, `Business`.`is_in_mb` FROM `rogerdw_murraybridge_test`.`businesses` AS `Business` WHERE `Business`.`url_key` = 's-calabrese-plumbing-service' LIMIT 1	1	1	1
SELECT `Communication`.`id`, `Communication`.`business_id`, `Communication`.`type`, `Communication`.`name`, `Communication`.`detail`, `Communication`.`created`, `Communication`.`modified` FROM `rogerdw_murraybridge_test`.`communications` AS `Communication` WHERE `Communication`.`business_id` = (1646)	3	3	0
SELECT `Category`.`id`, `Category`.`cat_code_not_used`, `Category`.`name`, `Category`.`url_key`, `Category`.`first_letter`, `Category`.`deleted`, `Category`.`created`, `Category`.`modified`, `BusinessesCategory`.`id`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `rogerdw_murraybridge_test`.`categories` AS `Category` JOIN `rogerdw_murraybridge_test`.`businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 1646 AND `BusinessesCategory`.`category_id` = `Category`.`id`)	1	1	1
SELECT `Advertisement`.`id`, `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` LEFT JOIN `rogerdw_murraybridge_test`.`advertisements_categories` AS `AdvertisementCategory` ON (`AdvertisementCategory`.`advertisement_id` = `Advertisement`.`id`) WHERE `Advertisement`.`deleted` = 0 AND `Advertisement`.`type` = 'category' AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) AND `AdvertisementCategory`.`category_id` = ('320') ORDER BY rand() ASC LIMIT 12	0	0	1	maybe slow
SELECT `Advertisement`.`id`, `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` = 0 AND `Advertisement`.`type` = 'rhs' AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 12	0	0	0
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'footer' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 5	0	0	0
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'header' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 5	0	0	0
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'promotion' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY `id` DESC LIMIT 1	0	0	0
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`image_ext`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'special' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 2	0	0	0
SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`open_content`, `Content`.`name`, `Content`.`order`, `Content`.`url_key` FROM `rogerdw_murraybridge_test`.`contents` AS `Content` WHERE `location` = 'header' AND `deleted` = 0 ORDER BY `order` ASC	16	16	0
SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`name`, `Content`.`order`, `Content`.`url_key` FROM `rogerdw_murraybridge_test`.`contents` AS `Content` WHERE `location` = 'footer' AND `deleted` = 0 ORDER BY `order` ASC	8	8	0

Message	Memory use
Component initialization	3.93 MB
Controller action start	5.91 MB
Controller render start	6.53 MB
View render complete	7.63 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	43.14
Event: Controller.initialize	18.96
Event: Controller.startup	1.66
Controller action	24.08
Event: Controller.beforeRender	27.23
» Processing toolbar data	22.31
Rendering View	12.87
» Event: View.beforeRender	0.03
» Rendering APP/View/Businesses/view.ctp	8.23
» » Rendering APP/View/Elements/business.ctp	4.96
» » Rendering APP/View/Elements/display_advertisements_side.ctp	0.13
» » Rendering APP/View/Elements/display_advertisements_bottom.ctp	0.14
» » Rendering APP/View/Elements/display_special_advertisements.ctp	0.15
» » Rendering APP/View/Elements/display_footer_advertisements.ctp	0.12
» » Rendering APP/View/Elements/footer.ctp	1.99
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	3.60
» » Rendering APP/View/Elements/nav_bar.ctp	1.55
» » » Rendering APP/View/Elements/display_promotion.ctp	0.14
» » » Rendering APP/View/Elements/flash.ctp	0.14
Event: View.afterLayout	0.00

Constant	Value
APP	/home/rogerdw/public_html/test/app/
APP_DIR	app
APPLIBS	/home/rogerdw/public_html/test/app/Lib/
CACHE	/home/rogerdw/public_html/test/app/tmp/cache/
CAKE	/home/rogerdw/public_html/test/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/rogerdw/public_html/test/lib
CORE_PATH	/home/rogerdw/public_html/test/lib/
CAKE_VERSION	2.6.7
CSS	/home/rogerdw/public_html/test/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://murraybridge.net.au
IMAGES	/home/rogerdw/public_html/test/app/webroot/img/
IMAGES_URL	img/
JS	/home/rogerdw/public_html/test/app/webroot/js/
JS_URL	js/
LOGS	/home/rogerdw/public_html/test/app/tmp/logs/
ROOT	/home/rogerdw/public_html/test
TESTS	/home/rogerdw/public_html/test/app/Test/
TMP	/home/rogerdw/public_html/test/app/tmp/
VENDORS	/home/rogerdw/public_html/test/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/rogerdw/public_html/test/app/webroot/

Environment Variable	Value
Php Version	5.6.40
Path	/usr/local/bin:/bin:/usr/bin
Http Accept	/
Http Accept Encoding	gzip, br, zstd, deflate
Http Host	murraybridge.net.au
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http X Https	1
Document Root	/home/rogerdw/public_html
Remote Addr	3.144.100.31
Remote Port	18965
Server Addr	66.147.236.126
Server Name	murraybridge.net.au
Server Admin	webmaster@murraybridge.net.au
Server Port	443
Request Scheme	https
Request Uri	/test/businesses/view/s-calabrese-plumbing-service
Redirect Url	/test/app/webroot/businesses/view/s-calabrese-plumbing-service
Redirect Request Method	GET
Https	on
Redirect Status	200
Crawler Usleep	1000
Crawler Load Limit	5.2
X Spdy	HTTP2
Ssl Protocol	TLSv1.3
Ssl Cipher	TLS_AES_256_GCM_SHA384
Ssl Cipher Usekeysize	256
Ssl Cipher Algkeysize	256
Script Filename	/home/rogerdw/public_html/test/app/webroot/index.php
Query String
Script Uri	https://murraybridge.net.au/test/businesses/view/s-calabrese-plumbing-service
Script Url	/test/businesses/view/s-calabrese-plumbing-service
Script Name	/test/app/webroot/index.php
Server Protocol	HTTP/1.1
Server Software	LiteSpeed
Request Method	GET
X-lscache	on,crawler
Php Self	/test/app/webroot/index.php
Request Time Float	1737305892.2204
Request Time	1737305892
Argc	0

S. Calabrese Plumbing Service

Murray Bridge, 5253

default

Total Time: 3 ms
Total Queries: 12 queries

Query Explain:

Memory

Timers

S. Calabrese Plumbing Service

Murray Bridge, 5253

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 3 ms Total Queries: 12 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 3 ms
Total Queries: 12 queries