Walking in North Wales
Gwynedd offers stunning walking country – for the well prepared and well equipped.
The rugged terrain of North Wales is a rural adventure playground for walkers, ramblers and climbers. Take a stroll around the scenic shore of Llyn Ogwen or, for the more ambitious, burn off a few calories on a nearby mountaineering route. The Llyn Trawsfynydd reservoir boasts numerous nature trails and the twin lakes of Llynnau Mymbyr reward brave walkers with stunning views of the Snowdon Horseshoe.
Cerdded yn y Gogledd
Mae Gwynedd yn lleoliad trawiadol ar gyfer cerddwyr sydd wedi paratoi’n dda ac sydd â’r offer priodol.
Gall cerddwyr, crwydrwyr a dringwyr fwynhau anturiaethau lu yn nhirwedd greigiog y Gogledd. Ewch am dro hamddenol o amgylch glannau hardd Llyn Ogwen neu, os ydych chi’n fwy uchelgeisiol, cerddwch ar hyd un o’r llwybrau mynyddig cyfagos a llosgwch ambell i galori! Mae gan gronfa dd?r Llyn Trawsfynydd nifer o lwybrau natur ac mae golygfeydd trawiadol o Bedol yr Wyddfa yn disgwyl y cerddwr dewr ger Llynnau Mymbyr.
Walking routes
Towpath Stoppages
04 Jan 2010 - 26 Mar 2010
Stoppage: Caen Hill Flight (Locks 28,29,30,32,34,35,39,43)
Associated Regional Office: Kennet & Avon WaterwaysTowpath has been closed
UPDATE (08 February 2010): Due to a delay in the commencement of the stoppage works due to the inclement weather, please note the revised stoppage end date of 26th March 2010.
Installing new gates and repairs to towpath along flight. Also repairs to towpath bank between locks 43 and 44.
Winding upstream at Devizes Wharf, downstream below Marsh Lane bridge.
(Enquiries: 01380 722859)
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database.php
[line] => 136
[function] => __construct
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
[2] => 1
[3] => 9
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Directory/Finder/Abstract.php
[line] => 62
[function] => getPagedRecordSet
[class] => Waterscape_Database
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 6
[_name:protected] => Walking
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 43
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 213973
[_min_northing:private] => 326140
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 319080
[_centre_northing:private] => 344530
[_name:protected] => North Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/north-wales
[_standfirst:protected] => The soaring peaks of Snowdonia tower above tranquil lakes and quiet valleys.
[_description:protected] => Ancient castles, rugged mountains and vast moorlands of purple heather, the landscape of north Wales still echoes with its tempestuous past. Explorers who stumble upon the quiet lakes of Snowdonia will be charmed by long walks, scenic climbs and excellent fishing.
[/media/images/21442.jpg Welsh Language Board]
++ Y Gogledd
**Mae llynnoedd llonydd a dyffrynnoedd distaw yng nghanol copaon uchel Eryri.**
Cestyll hynafol, mynyddoedd garw a rhostiroedd eang o rug piws - mae gorffennol tymhestlog y gogledd wedi gadael ei ôl ar y dirwedd. Bydd ymwelwyr â llynnoedd distaw Eryri yn cael eu cyfareddu gan lwybrau cerdded hir, mynyddoedd gyda golygfeydd trawiadol a physgota rhagorol.
[_id:protected] => 41
[_url_name] => north-wales
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 6
[_name:protected] => Walking
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 43
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 213973
[_min_northing:private] => 326140
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 319080
[_centre_northing:private] => 344530
[_name:protected] => North Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/north-wales
[_standfirst:protected] => The soaring peaks of Snowdonia tower above tranquil lakes and quiet valleys.
[_description:protected] => Ancient castles, rugged mountains and vast moorlands of purple heather, the landscape of north Wales still echoes with its tempestuous past. Explorers who stumble upon the quiet lakes of Snowdonia will be charmed by long walks, scenic climbs and excellent fishing.
[/media/images/21442.jpg Welsh Language Board]
++ Y Gogledd
**Mae llynnoedd llonydd a dyffrynnoedd distaw yng nghanol copaon uchel Eryri.**
Cestyll hynafol, mynyddoedd garw a rhostiroedd eang o rug piws - mae gorffennol tymhestlog y gogledd wedi gadael ei ôl ar y dirwedd. Bydd ymwelwyr â llynnoedd distaw Eryri yn cael eu cyfareddu gan lwybrau cerdded hir, mynyddoedd gyda golygfeydd trawiadol a physgota rhagorol.
[_id:protected] => 41
[_url_name] => north-wales
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 262
[function] => render
[class] => Waterscape_Renderer_Component_HtmlRenderer
[type] => ->
[args] => Array
(
[0] => Waterscape_Component_DirectoryListingPage Object
(
[_is_location_page:private] => 1
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 43
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 213973
[_min_northing:private] => 326140
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 319080
[_centre_northing:private] => 344530
[_name:protected] => North Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/north-wales
[_standfirst:protected] => The soaring peaks of Snowdonia tower above tranquil lakes and quiet valleys.
[_description:protected] => Ancient castles, rugged mountains and vast moorlands of purple heather, the landscape of north Wales still echoes with its tempestuous past. Explorers who stumble upon the quiet lakes of Snowdonia will be charmed by long walks, scenic climbs and excellent fishing.
[/media/images/21442.jpg Welsh Language Board]
++ Y Gogledd
**Mae llynnoedd llonydd a dyffrynnoedd distaw yng nghanol copaon uchel Eryri.**
Cestyll hynafol, mynyddoedd garw a rhostiroedd eang o rug piws - mae gorffennol tymhestlog y gogledd wedi gadael ei ôl ar y dirwedd. Bydd ymwelwyr â llynnoedd distaw Eryri yn cael eu cyfareddu gan lwybrau cerdded hir, mynyddoedd gyda golygfeydd trawiadol a physgota rhagorol.
[_id:protected] => 41
[_url_name] => north-wales
)
[_preposition:private] => in
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 6
[_name:protected] => Walking
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_business_manager:private] =>
[_location_manager:private] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_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] =>
)
)
)
[_town_manager:private] =>
[_limit:protected] =>
[_title:protected] => Walking clubs & services
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 1730
[_view_component_id:protected] => 154
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/north-wales/walking
[_path:private] => /in-your-area/north-wales/walking
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/north-wales/walking
[PHPSESSID] => 4bd21bf0c00da08c2d4abae5ac868039
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 13
[page_id] => 1730
[view_name] => locations_walking
[title] => Walks, Walking and Walking Routes %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/walking.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/north-wales/walking
[location] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 43
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 213973
[_min_northing:private] => 326140
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 319080
[_centre_northing:private] => 344530
[_name:protected] => North Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/north-wales
[_standfirst:protected] => The soaring peaks of Snowdonia tower above tranquil lakes and quiet valleys.
[_description:protected] => Ancient castles, rugged mountains and vast moorlands of purple heather, the landscape of north Wales still echoes with its tempestuous past. Explorers who stumble upon the quiet lakes of Snowdonia will be charmed by long walks, scenic climbs and excellent fishing.
[/media/images/21442.jpg Welsh Language Board]
++ Y Gogledd
**Mae llynnoedd llonydd a dyffrynnoedd distaw yng nghanol copaon uchel Eryri.**
Cestyll hynafol, mynyddoedd garw a rhostiroedd eang o rug piws - mae gorffennol tymhestlog y gogledd wedi gadael ei ôl ar y dirwedd. Bydd ymwelwyr â llynnoedd distaw Eryri yn cael eu cyfareddu gan lwybrau cerdded hir, mynyddoedd gyda golygfeydd trawiadol a physgota rhagorol.
[_id:protected] => 41
[_url_name] => north-wales
)
[preposition] => in
[section] => walking
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 43
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 213973
[_min_northing:private] => 326140
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 319080
[_centre_northing:private] => 344530
[_name:protected] => North Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/north-wales
[_standfirst:protected] => The soaring peaks of Snowdonia tower above tranquil lakes and quiet valleys.
[_description:protected] => Ancient castles, rugged mountains and vast moorlands of purple heather, the landscape of north Wales still echoes with its tempestuous past. Explorers who stumble upon the quiet lakes of Snowdonia will be charmed by long walks, scenic climbs and excellent fishing.
[/media/images/21442.jpg Welsh Language Board]
++ Y Gogledd
**Mae llynnoedd llonydd a dyffrynnoedd distaw yng nghanol copaon uchel Eryri.**
Cestyll hynafol, mynyddoedd garw a rhostiroedd eang o rug piws - mae gorffennol tymhestlog y gogledd wedi gadael ei ôl ar y dirwedd. Bydd ymwelwyr â llynnoedd distaw Eryri yn cael eu cyfareddu gan lwybrau cerdded hir, mynyddoedd gyda golygfeydd trawiadol a physgota rhagorol.
[_id:protected] => 41
[_url_name] => north-wales
)
[_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] =>
)
[_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] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_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] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_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] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_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] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_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] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_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] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[81] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[82] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[83] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[84] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[85] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[86] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[88] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND a.county = 41 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 91
)
)
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waypoint wp ON r.route_id = wp.route_id WHERE c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 3
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => 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 = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => 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 = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => 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 = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => 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 = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => 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 = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?