Cycling along the Regent's Canal
The Regent's Canal provides an attractive car-free shared use path for leisure and recreation and for travelling to work and school.
Generally the busiest times are weekdays between 7:30am and 9:30am and between 4:30pm and 7pm. If you're planning a recreational visit to London's canals, try to avoid these busy times.
Please cycle on London's towpaths with great care and courtesy to others, observing the new Towpath Code of Conduct and ringing your bell with Two Tings towpath safety.
You can cycle between Little Venice and Islington Tunnel (6.5km), and from Colebrooke Row in Islington to Limehouse Basin (7km).
Cycling routes
Towpath Stoppages
25 Jan 2010 - 01 Apr 2010
Stoppage: Victoria Park, between Mare Street and Old Ford Lock (Regent's)
Associated Regional Office: London WaterwaysTowpath has been closed
UPDATE (12 March 2010): Due to unexpected difficulties encountered during the execution of these works, the completion date has been altered.
UPDATE (16 February 2010): Following the delay in commencing works at this site, the completion date has been altered accordingly.
UPDATE (14 January 2010): Due to the recent adverse weather conditions, the start date for this project has been altered to Monday 25th January.
UPDATE (04 January 2010): The start date for this project has been altered to 18th January.
The boaters' facilities at Old Ford Lock will remain open for the duration of these works, however the Victoria Park Visitor Mooring site will be closed and craft will not be permitted access through Old Ford Lock.
Collapsed waterway wall replacement
Winding below Actons Lock and at the junction of the Hertford Union
(Enquiries: 020 7985 7200)
16 Mar 2010 - 07 May 2010
Towpath Closure only: Islington - Danbury Street to City Road Lock
Associated Regional Office: London WaterwaysUPDATE (16 March 2010): The dates for these planned works have been altered.
The towpath will be closed between Danbury Street Bridge and City Road Lock to allow improvement works to the Danbury Street towpath access ramp.
A diversionary route will be signposted.
The Islington Visitor Mooring site will still be in use but accessible only from Colebrooke Row.
(Enquiries: 0207 985 7200)
27 - 29 Mar 2010
Towpath Closure only: Islington - Packington Street to New North Road
Associated Regional Office: London WaterwaysThe towpath in Islington between the Packington Street bridge and New North Road bridge will be closed to permit the erection of scaffolding.
Visitors are advised to follow the signed diversion route around the closure.
(Enquiries: 0207 985 7200)
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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) 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] => 7
[_name:protected] => Cycling
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => RE
[_min_easting:private] => 526129
[_max_easting:private] => 536526
[_min_northing:private] => 180683
[_max_northing:private] => 184173
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Regent's Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/regents-canal
[_standfirst:protected] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[_description:protected] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 62
[_url_name] => regents-canal
)
[_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] => 7
[_name:protected] => Cycling
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => RE
[_min_easting:private] => 526129
[_max_easting:private] => 536526
[_min_northing:private] => 180683
[_max_northing:private] => 184173
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Regent's Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/regents-canal
[_standfirst:protected] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[_description:protected] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 62
[_url_name] => regents-canal
)
[_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_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => RE
[_min_easting:private] => 526129
[_max_easting:private] => 536526
[_min_northing:private] => 180683
[_max_northing:private] => 184173
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Regent's Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/regents-canal
[_standfirst:protected] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[_description:protected] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 62
[_url_name] => regents-canal
)
[_preposition:private] => along the
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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] =>
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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] =>
)
)
[_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] => Cycle hire, clubs & services
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 713053
[_view_component_id:protected] => 178
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/regents-canal/cycling
[_path:private] => /canals-and-rivers/regents-canal/cycling
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/regents-canal/cycling
[PHPSESSID] => 4561e56428a297eec764b085391961f1
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 24
[page_id] => 713053
[view_name] => waterway_cycling
[title] => Cycling And Cycle Routes %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/cycling.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/regents-canal/cycling
[waterway] => Array
(
[id] => 62
[0] => 62
[name] => Regent's Canal
[1] => Regent's Canal
[urlname] => regents-canal
[2] => regents-canal
[waterway_type] => 15
[3] => 15
[sap_canal_code] => RE
[4] => RE
[introduction] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[5] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[overview] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[6] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 1
[10] => 1
[min_easting] => 526129
[11] => 526129
[min_northing] => 180683
[12] => 180683
[max_easting] => 536526
[13] => 536526
[max_northing] => 184173
[14] => 184173
[centre_easting] =>
[15] =>
[centre_northing] =>
[16] =>
)
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => RE
[_min_easting:private] => 526129
[_max_easting:private] => 536526
[_min_northing:private] => 180683
[_max_northing:private] => 184173
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Regent's Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/regents-canal
[_standfirst:protected] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[_description:protected] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 62
[_url_name] => regents-canal
)
[preposition] => along the
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => RE
[_min_easting:private] => 526129
[_max_easting:private] => 536526
[_min_northing:private] => 180683
[_max_northing:private] => 184173
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Regent's Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/regents-canal
[_standfirst:protected] => From the [/canals-and-rivers/river-thames River Thames] at Limehouse to [/in-your-area/london/paddington Paddington], the nine-mile Regent's Canal is one of the best-kept secrets in the capital.
[_description:protected] => Largely hidden behind buildings, the line sneaks its way through a rich collage of urban landscapes.
It starts at [/in-your-area/london/places-to-go/280/little-venice Little Venice] - a colourful combination of boats and scenery at the junction between the Regent's Canal and the Paddington Arm. At Regent's Park, it passes the famous zoo in a fine example of an city canal line. After the bustle of [/in-your-area/london/places-to-go/91/camden-lock-market Camden Market] and the quieter reaches through north-east London, the line ends at [/in-your-area/london/places-to-go/274/limehouse-basin Limehouse Basin], a well-heeled basin containing boats of all shapes and sizes. Along the way are several tunnels, city basins, and an astonishing variety of waterside architecture.
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 62
[_url_name] => regents-canal
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_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] =>
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[70] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[71] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[72] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[73] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[74] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[75] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[78] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[79] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[80] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[81] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[82] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[83] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[84] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[87] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[88] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[89] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => 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 INNER JOIN service_provider_waterway w ON w.item_id = i.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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 62 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 93
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => 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 = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?