Exception Object
(
[message:protected] => Element with key 'online_map' does not exist in hashtable
[string:private] =>
[code:protected] => 0
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Util/Hashtable.php
[line:protected] => 85
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 254
[function] => get
[class] => Waterscape_Util_Hashtable
[type] => ->
[args] => Array
(
[0] => online_map
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/%%96^962^96223EEB%%map.tpl.php
[line] => 9
[function] => smartyFunctionComponent
[class] => Waterscape_Smarty
[type] => ->
[args] => Array
(
[0] => Array
(
[name] => online_map
)
[1] => Waterscape_Smarty Object
(
[_is_for_print:private] =>
[_is_text_only:private] =>
[template_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates/
[compile_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/
[config_dir] => /home/waterscape/public_html/waterscape/var/smarty/configs/
[plugins_dir] => Array
(
[0] => plugins
)
[debugging] =>
[error_reporting] =>
[debug_tpl] =>
[debugging_ctrl] => NONE
[compile_check] => 1
[force_compile] =>
[caching] => 0
[cache_dir] => /home/waterscape/public_html/waterscape/var/smarty/cache/
[cache_lifetime] => 3600
[cache_modified_check] =>
[php_handling] => 0
[security] =>
[secure_dir] => Array
(
)
[security_settings] => Array
(
[PHP_HANDLING] =>
[IF_FUNCS] => Array
(
[0] => array
[1] => list
[2] => isset
[3] => empty
[4] => count
[5] => sizeof
[6] => in_array
[7] => is_array
[8] => true
[9] => false
[10] => null
)
[INCLUDE_ANY] =>
[PHP_TAGS] =>
[MODIFIER_FUNCS] => Array
(
[0] => count
)
[ALLOW_CONSTANTS] =>
)
[trusted_dir] => Array
(
)
[left_delimiter] => {
[right_delimiter] => }
[request_vars_order] => EGPCS
[request_use_auto_globals] => 1
[compile_id] =>
[use_sub_dirs] =>
[default_modifiers] => Array
(
)
[default_resource_type] => file
[cache_handler_func] =>
[autoload_filters] => Array
(
)
[config_overwrite] => 1
[config_booleanize] => 1
[config_read_hidden] =>
[config_fix_newlines] => 1
[default_template_handler_func] =>
[compiler_file] => Smarty_Compiler.class.php
[compiler_class] => Smarty_Compiler
[config_class] => Config_File
[_tpl_vars] => Array
(
[page_title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[page_description] => Map of %LOCATION_NAME%
[page_keywords] => Map of %LOCATION_NAME%, Maps, Waterscape.com
[page_metadata] => Waterscape_Model_Metadata Object
(
[_title:private] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[_description:private] => Map of %LOCATION_NAME%
[_keywords:private] => Map of %LOCATION_NAME%, Maps, Waterscape.com
[_alt_text:private] =>
[_author:private] =>
[_language:private] => en-GB
[_source:private] =>
[_relation:private] =>
[_format:private] =>
[_identifier:private] =>
[_publisher:private] =>
[_coverage:private] =>
[_rights:private] =>
[_contributor:private] =>
[_easting:private] => 0
[_northing:private] => 0
[_created:private] => 2007-10-08 01:08:04
[_updated:private] => 2007-10-08 01:08:04
[_indexed:private] =>
[_geo_data_id:private] =>
[_geo_data_type:private] => point
[_id:protected] => 43447
)
[response] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 113
[page_id] => 3371
[view_name] => map_location
[title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_noimgorsearch.tpl
[template] => Page/locations/map.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/worcestershire/tardebigge/map
[onload] => mapInit();
[google_map_key] => ABQIAAAADBrEc2bNhMboJ0bBJ2wI4xRvp9RyboS0d78StvLqOsTlN5qkjBQCzLGnvMpYqkEl0uAspKjpWLMgPg
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[preposition] => near
[section] => map
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_component_id:protected] =>
[_parent_id:protected] =>
[_template:protected] => Component/LocationNavigationMenu.tpl
[_page_id:protected] =>
[_view_component_id:protected] =>
[_instance_name:protected] =>
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/worcestershire/tardebigge/map
[_path:private] => /in-your-area/worcestershire/tardebigge/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/worcestershire/tardebigge/map
[PHPSESSID] => 215f2efc5a64896a729f06e159e90fcf
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] =>
[_dimension_manager] => Waterscape_Service_DimensionManager Object
(
[_dimension_dao:private] => Waterscape_Dao_Dimension Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[PLACEHOLDER_PAGE_NUM] => map
[PLACEHOLDER_LOCATION_COUNTY_NAME] => Worcestershire
[PLACEHOLDER_LOCATION_NAME] => Tardebigge
[PLACEHOLDER_LOCATION_PREPOSITION] => near
)
[_count:private] => 23
)
[request] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/worcestershire/tardebigge/map
[_path:private] => /in-your-area/worcestershire/tardebigge/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/worcestershire/tardebigge/map
[PHPSESSID] => 215f2efc5a64896a729f06e159e90fcf
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[components] => Waterscape_Util_Hashtable Object
(
[_store:private] => Array
(
[google_map] => Waterscape_Component_Map Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_geo_point_mgr:private] =>
[_geo_linestring_mgr:private] =>
[_os_ref_obj:private] =>
[_config:private] => Waterscape_Configuration_Config Object
(
[_xml_doc:private] => SimpleXMLElement Object
(
[application-paths] => SimpleXMLElement Object
(
[path] => Array
(
[0] => /home/waterscape/public_html/waterscape/
[1] => lib/
[2] => var/www/
[3] => var/run/log/
[4] => media/
[5] => var/test/
[6] => var/test/cases/
[7] => var/test/resources/
[8] => var/smarty/
[9] => var/smarty/templates/
[10] => /usr/share/misc/file/magic
)
)
[application-properties] => SimpleXMLElement Object
(
[property] => Array
(
[0] => www.waterscape.com
[1] => editor@waterscape.com
[2] => ABQIAAAADBrEc2bNhMboJ0bBJ2wI4xRvp9RyboS0d78StvLqOsTlN5qkjBQCzLGnvMpYqkEl0uAspKjpWLMgPg
)
)
[application-options] => SimpleXMLElement Object
(
[option] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => devmode
)
[property] => 1
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => auth
)
[comment] => SimpleXMLElement Object
(
)
[property] => 3600
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => xdebug
)
[property] => Array
(
[0] => 0
[1] => 1
[2] => 1
[3] => /home/waterscape/public_html/waterscape/debug/
)
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => pdflib
)
[property] => L700102-010000-117599-YFYEG2-WBFDF2
)
)
)
[database] => SimpleXMLElement Object
(
[@attributes] => Array
(
[default-connection] => waterscape
)
[connection] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_v2
[username] => waterscape_v2
[password] => d3VeloP375
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => bwaterways
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => bwaterways
[username] => ws_reader
[password] => Wsr34d3r
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape-test
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_test
[username] => waterscape_test
[password] => f15hEsEye
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape-test-paul
)
[driver] => ${database.connection.waterscape-test-paul.driver}
[hostname] => ${database.connection.waterscape-test-paul.hostname}
[port] => ${database.connection.waterscape-test-paul.port}
[dbname] => ${database.connection.waterscape-test-paul.dbname}
[username] => ${database.connection.waterscape-test-paul.username}
[password] => ${database.connection.waterscape-test-paul.password}
[persistent] => 0
[buffer-queries] => 1
[errormode] => 2
)
[4] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape-no-persistence
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_v2
[username] => waterscape_v2
[password] => d3VeloP375
[persistent] => 0
[buffer-queries] => 1
[errormode] => 2
)
[5] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => bw_reader
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_v2
[username] => bw_reader
[password] => bWr34Der
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[6] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape_wp
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_wp
[username] => wp_reader
[password] => w0Rdpre55
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
)
)
[channels] => SimpleXMLElement Object
(
[channel] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => locations
)
[tabname] => in your area
[basepath] => /in-your-area
[position] => 1
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterways
)
[tabname] => canals & rivers
[basepath] => /canals-and-rivers
[position] => 2
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => activities
)
[tabname] => things to to
[basepath] => /things-to-do
[position] => 3
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => features
)
[tabname] => features & articles
[basepath] => /features-and-articles
[position] => 4
)
)
)
[socialBookmarks] => SimpleXMLElement Object
(
[@attributes] => Array
(
[implements] => links to social networking sites at the bottom of news, events and features
)
[site] => Array
(
[0] => SimpleXMLElement Object
(
[enabled] => 0
[url] => none
[image] => /media/images/social/dopplr.gif
[name] => Dopplr
[height] => 18
[width] => 88
)
[1] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://del.icio.us/post?url=%URL
[image] => /media/images/social/del_icio_us.gif
[name] => Delicious
[height] => 18
[width] => 18
)
[2] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://www.facebook.com/sharer.php?u=%URL
[image] => /media/images/social/facebook.gif
[name] => Facebook
[height] => 18
[width] => 18
)
[3] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://digg.com/submit?url=%URL
[image] => /media/images/social/digg.gif
[name] => Digg
[height] => 18
[width] => 18
)
[4] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://www.reddit.com/submit?url=%URL
[image] => /media/images/social/reddit.gif
[name] => reddit
[height] => 18
[width] => 18
)
)
)
[dynamicFooter] => SimpleXMLElement Object
(
[use] => 1
[cache] => 1
[class] => Waterscape_Model_Cache_Db
)
[twitter] => SimpleXMLElement Object
(
[username] => waterscape_com
[pass] => Clarendon64
[ttl] => 60
[count] => 5
)
)
)
[_component_id:protected] => 48
[_parent_id:protected] =>
[_template:protected] => Component/Map.tpl
[_page_id:protected] => 3371
[_view_component_id:protected] => 203
[_instance_name:protected] => google_map
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/worcestershire/tardebigge/map
[_path:private] => /in-your-area/worcestershire/tardebigge/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/worcestershire/tardebigge/map
[PHPSESSID] => 215f2efc5a64896a729f06e159e90fcf
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 113
[page_id] => 3371
[view_name] => map_location
[title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_noimgorsearch.tpl
[template] => Page/locations/map.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/worcestershire/tardebigge/map
[onload] => mapInit();
[google_map_key] => ABQIAAAADBrEc2bNhMboJ0bBJ2wI4xRvp9RyboS0d78StvLqOsTlN5qkjBQCzLGnvMpYqkEl0uAspKjpWLMgPg
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[preposition] => near
[section] => map
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(