Fishing along the River Medway
Although in the past pollution from local industry had caused damage to the waters and the life therein, recently anglers have recorded catches of sole, eels, flounder, brown shrimps, sea trout, whiting and even the odd salmon.
Iron rich streams in the Weald support resident populations of small but highly coloured brown trout. The River Teise is managed as a game fishery down to Marden while the lower stretches of both the Teise and Beult are managed as coarse fisheries with chub, roach, dace and pike.
In the middle and lower reaches of streams where the water is deeper, there are bream and tench. Minnows, gudgeon stone loaches, bullheads, brook lampreys and perch are also found in riffles.
The main river has considerable angling interests over its entire length and attracts large number of fishermen. Chub, roach and pike along with several other species can be found in the upper reaches, while the stretch below Ashurst Weir has a breeding population of barbel and is an important spawning ground. Grayling have been stocked to the upper reaches over recent years and some also find their way down the River Teise into the Medway.
Eels are less prolific in the Medway catchment than on the Kentish Stour and the River Rother. In wet years the occasional sea trout or salmon is reported but existing water conditions in the estuary prevent a self-sustaining population from being re-established at present.
You can fish for nothing in the following stretches without belonging to an angling club, as long as you have a valid rod licence (obtainable from post offices) if aged 12 or over: - upstream from Yalding Sluice, 200m along south bank (except April to September); - the Lees at Yalding, south bank; - East Farleigh Lock to Maidstone, north bank (excluding the moorings). Some angling clubs sell day tickets for fishing on other stretches of the river. Day tickets can be purchased from Tonbridge and District Angling and Fish Preservation Society, 01732 832352.
You must also have a valid rod licence, available from local Post Offices.
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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
[2] =>
[3] =>
)
)
[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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
[1] =>
[2] =>
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/FisheryListingPage.php
[line] => 39
[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] => 5
[_name:protected] => Fishing
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 555000
[_max_easting:private] => 590153
[_min_northing:private] => 145470
[_max_northing:private] => 175945
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Medway
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-medway
[_standfirst:protected] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[_description:protected] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[_id:protected] => 157
[_url_name] => river-medway
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] =>
[_page_limit:private] =>
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/FisheryListingPage.php
[line] => 18
[function] => getFishingServices
[class] => Waterscape_Component_FisheryListingPage
[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] => 5
[_name:protected] => Fishing
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 555000
[_max_easting:private] => 590153
[_min_northing:private] => 145470
[_max_northing:private] => 175945
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Medway
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-medway
[_standfirst:protected] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[_description:protected] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[_id:protected] => 157
[_url_name] => river-medway
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] =>
[_page_limit:private] =>
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_FisheryListingPage
[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] => 5
[_name:protected] => Fishing
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 555000
[_max_easting:private] => 590153
[_min_northing:private] => 145470
[_max_northing:private] => 175945
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Medway
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-medway
[_standfirst:protected] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[_description:protected] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[_id:protected] => 157
[_url_name] => river-medway
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] =>
[_page_limit:private] =>
)
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[8] => 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_FisheryListingPage Object
(
[_fishery_manager:private] =>
[_is_location_page:private] =>
[_location:private] =>
[_preposition:private] =>
[_descriptor:private] =>
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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] => Fisheries and fishing services along the River Medway
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 34
[_parent_id:protected] =>
[_template:protected] => Component/FisheryListPage.tpl
[_page_id:protected] => 717231
[_view_component_id:protected] => 194
[_instance_name:protected] => fisheries
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/river-medway/fishing
[_path:private] => /canals-and-rivers/river-medway/fishing
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/river-medway/fishing
[PHPSESSID] => f7da83f131714adf70f23ca31c6cc052
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 22
[page_id] => 717231
[view_name] => waterway_fishing
[title] => Angling, Fisheries and Fishing %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/fishing.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/river-medway/fishing
[waterway] => Array
(
[id] => 157
[0] => 157
[name] => River Medway
[1] => River Medway
[urlname] => river-medway
[2] => river-medway
[waterway_type] => 16
[3] => 16
[sap_canal_code] => UNKNOWN
[4] => UNKNOWN
[introduction] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[5] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[overview] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[6] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 1
[10] => 1
[min_easting] => 555000
[11] => 555000
[min_northing] => 145470
[12] => 145470
[max_easting] => 590153
[13] => 590153
[max_northing] => 175945
[14] => 175945
[centre_easting] =>
[15] =>
[centre_northing] =>
[16] =>
)
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 555000
[_max_easting:private] => 590153
[_min_northing:private] => 145470
[_max_northing:private] => 175945
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Medway
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-medway
[_standfirst:protected] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[_description:protected] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[_id:protected] => 157
[_url_name] => river-medway
)
[preposition] => along the
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 555000
[_max_easting:private] => 590153
[_min_northing:private] => 145470
[_max_northing:private] => 175945
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Medway
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-medway
[_standfirst:protected] => The River Medway was opened to navigation over 250 years ago when water-borne transport was in its heyday. Today the river between Maidstone and Tonbridge is maintained as a public right of navigation, enabling water users to experience the delightful scenery of the Garden of England.
[_description:protected] => The river is popular with canoeists and anglers and trips can be taken on the river by pleasure boat or under your own power in a rowing boat.
There are opportunities to visit the locks or parks near the river and enjoy the views of weirs, meadows, pastures, medieval bridges and oast houses. There are several villages on, or close to the rivers which provide ample occasion for the traveller to explore and take refreshment.
The Navigation Authority for the Medway between Allington and Tonbridge is The Environment Agency.
[_id:protected] => 157
[_url_name] => river-medway
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => 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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => 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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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] =>
)
)
)
[_media_manager:protected] => 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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * 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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 157 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[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 media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELE