Warning (2): file_get_contents(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0 [APP/View/Elements/business.ctp, line 450]
file_get_contents - [internal], line ??
get_lat_long - APP/View/Elements/business.ctp, line 450
include - APP/View/Elements/business.ctp, line 21
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
Warning (2): file_get_contents(https://maps.googleapis.com/maps/api/geocode/json?address=92+Eleanor+Tce,+,+Murray+Bridge,+5253&key=AIzaSyBX7hsEgTBvrBMP9xyxjR6DQhRux0NK28Y) [function.file-get-contents]: failed to open stream: no suitable wrapper could be found [APP/View/Elements/business.ctp, line 450]
file_get_contents - [internal], line ??
get_lat_long - APP/View/Elements/business.ctp, line 450
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 455]
get_lat_long - APP/View/Elements/business.ctp, line 455
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 462]
get_lat_long - APP/View/Elements/business.ctp, line 462
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 462]
get_lat_long - APP/View/Elements/business.ctp, line 462
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 462]
get_lat_long - APP/View/Elements/business.ctp, line 462
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 462]
get_lat_long - APP/View/Elements/business.ctp, line 462
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 463]
get_lat_long - APP/View/Elements/business.ctp, line 463
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 463]
get_lat_long - APP/View/Elements/business.ctp, line 463
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 463]
get_lat_long - APP/View/Elements/business.ctp, line 463
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Trying to get property of non-object [APP/View/Elements/business.ctp, line 463]
get_lat_long - APP/View/Elements/business.ctp, line 463
include - APP/View/Elements/business.ctp, line 21
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
Notice (8): Undefined variable: markericon [APP/View/Elements/business.ctp, line 41]
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
Servicing Murray Bridge and surrounding districts with anything from Auto airconditioning, Starter Motors, Alternators and Batteries to general auto electrical repairs, large range of spare parts, lighting and accessories.
business_activity<p>Auto Electrical and Airconditioning services.</p>
<p>Servicing Murray Bridge and surrounding districts with anything from Auto airconditioning, Starter Motors, Alternators and Batteries to general auto electrical repairs, large range of spare parts, lighting and accessories.</p>
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` = (145)
5
5
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` = 145 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` = ('30') ORDER BY rand() ASC LIMIT 12
0
0
0
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
1
maybe slow
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
1
maybe slow
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
Query Explain:
Click an "Explain" link above, to see the query explanation.
business_activity<p>Auto Electrical and Airconditioning services.</p>
<p>Servicing Murray Bridge and surrounding districts with anything from Auto airconditioning, Starter Motors, Alternators and Batteries to general auto electrical repairs, large range of spare parts, lighting and accessories.</p>
business_activity<p>Auto Electrical and Airconditioning services.</p>
<p>Servicing Murray Bridge and surrounding districts with anything from Auto airconditioning, Starter Motors, Alternators and Batteries to general auto electrical repairs, large range of spare parts, lighting and accessories.</p>