Places to go in South west Wales
Dramatic ruins, fairy tale fortresses and scenic beauty spots are par for the course in South west Wales.
December is the perfect time of year to visit Bethlehem (in Carmarthenshire that is). The towers of Cilgerran Castle, the Teifi Valley Railway and the spectacular waterfalls which dot the region can be admired whatever the season.
Llefydd i fynd yn y De-orllewin
Mae’r de-orllewin yn llawn adfeilion trawiadol, caerau tylwyth teg a golygfeydd hardd.
Mis Rhagfyr yw’r amser delfrydol i ymweld â Bethlehem (hynny yw, yn Sir Gaerfyrddin). Mae tyrau Castell Cilgerran, Rheilffordd Dyffryn Teifi a’r rhaeadrau trawiadol sy’n frith yn yr ardal werth eu gweld ym mhob tymor.
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.county' 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 AS attraction_id, i.id, i.name, i.description, i.classification, c.urlname AS county_urlname FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
[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 AS attraction_id, i.id, i.name, i.description, i.classification, c.urlname AS county_urlname FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
[1] => Array
(
)
[2] => 1
[3] => 9
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Directory/Finder/Abstract.php
[line] => 62
[function] => getPagedRecordSet
[class] => Waterscape_Database
[type] => ->
[args] => Array
(
[0] => SELECT i.id AS attraction_id, i.id, i.name, i.description, i.classification, c.urlname AS county_urlname FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 1
[_name:protected] => Places to go
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 41
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 171761
[_min_northing:private] => 223382
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 261570
[_centre_northing:private] => 224630
[_name:protected] => South west Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/south-west-wales
[_standfirst:protected] => Fairy tale fortresses perch high on cliffs, fallow deer flit through ancient woodlands, all the romance of Wales is here.
[_description:protected] => The south-west of Wales is an untamed expanse of heather-clad moorland, rugged Cambrian mountains and fast-flowing rivers. Carmarthen has long been recognised as the land of Arthurian legend – but this pastoral beauty expands well beyond the county boundary. Spot the fishermen out in traditional coracles on the [/canals-and-rivers/river-towy River Towy], clamber through ruined castles and watch the salmon leap at Cenarth Falls.
[/media/images/21442.jpg Welsh Language Board]
++ Y De-orllewin
**Caerau tylwyth teg ar glogwyni uchel, ewig lwyd yn gwibio drwy goedwigoedd hynafol – mae holl ramant Cymru yma.**
Ledled y de-orllewin, fe welwch ehangder gwyllt rostiroedd grugog, mynyddoedd garw Cambria ac afonydd cyflym. Mae Caerfyrddin yn enwog am ei chysylltiad â’r chwedlau Arthuraidd, ond mae ei harddwch gwledig yn ymestyn ymhell y tu hwnt i ffiniau’r sir. Gwyliwch y pysgotwyr yn eu cwryglau traddodiadol ar yr [/canals-and-rivers/river-towy Afon Tywi], ewch i archwilio’r cestyll hynafol a gwyliwch yr eog yn llamu yn Rhaeadrau Cenarth.
[_id:protected] => 39
[_url_name] => south-west-wales
)
[_range:private] =>
[_directory_type:private] => 2
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 1
[_name:protected] => Places to go
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 41
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 171761
[_min_northing:private] => 223382
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 261570
[_centre_northing:private] => 224630
[_name:protected] => South west Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/south-west-wales
[_standfirst:protected] => Fairy tale fortresses perch high on cliffs, fallow deer flit through ancient woodlands, all the romance of Wales is here.
[_description:protected] => The south-west of Wales is an untamed expanse of heather-clad moorland, rugged Cambrian mountains and fast-flowing rivers. Carmarthen has long been recognised as the land of Arthurian legend – but this pastoral beauty expands well beyond the county boundary. Spot the fishermen out in traditional coracles on the [/canals-and-rivers/river-towy River Towy], clamber through ruined castles and watch the salmon leap at Cenarth Falls.
[/media/images/21442.jpg Welsh Language Board]
++ Y De-orllewin
**Caerau tylwyth teg ar glogwyni uchel, ewig lwyd yn gwibio drwy goedwigoedd hynafol – mae holl ramant Cymru yma.**
Ledled y de-orllewin, fe welwch ehangder gwyllt rostiroedd grugog, mynyddoedd garw Cambria ac afonydd cyflym. Mae Caerfyrddin yn enwog am ei chysylltiad â’r chwedlau Arthuraidd, ond mae ei harddwch gwledig yn ymestyn ymhell y tu hwnt i ffiniau’r sir. Gwyliwch y pysgotwyr yn eu cwryglau traddodiadol ar yr [/canals-and-rivers/river-towy Afon Tywi], ewch i archwilio’r cestyll hynafol a gwyliwch yr eog yn llamu yn Rhaeadrau Cenarth.
[_id:protected] => 39
[_url_name] => south-west-wales
)
[_range:private] =>
[_directory_type:private] => 2
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 262
[function] => render
[class] => Waterscape_Renderer_Component_HtmlRenderer
[type] => ->
[args] => Array
(
[0] => Waterscape_Component_AttractionListingPage Object
(
[_attraction_manager:private] =>
[_is_location_page:private] => 1
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 41
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 171761
[_min_northing:private] => 223382
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 261570
[_centre_northing:private] => 224630
[_name:protected] => South west Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/south-west-wales
[_standfirst:protected] => Fairy tale fortresses perch high on cliffs, fallow deer flit through ancient woodlands, all the romance of Wales is here.
[_description:protected] => The south-west of Wales is an untamed expanse of heather-clad moorland, rugged Cambrian mountains and fast-flowing rivers. Carmarthen has long been recognised as the land of Arthurian legend – but this pastoral beauty expands well beyond the county boundary. Spot the fishermen out in traditional coracles on the [/canals-and-rivers/river-towy River Towy], clamber through ruined castles and watch the salmon leap at Cenarth Falls.
[/media/images/21442.jpg Welsh Language Board]
++ Y De-orllewin
**Caerau tylwyth teg ar glogwyni uchel, ewig lwyd yn gwibio drwy goedwigoedd hynafol – mae holl ramant Cymru yma.**
Ledled y de-orllewin, fe welwch ehangder gwyllt rostiroedd grugog, mynyddoedd garw Cambria ac afonydd cyflym. Mae Caerfyrddin yn enwog am ei chysylltiad â’r chwedlau Arthuraidd, ond mae ei harddwch gwledig yn ymestyn ymhell y tu hwnt i ffiniau’r sir. Gwyliwch y pysgotwyr yn eu cwryglau traddodiadol ar yr [/canals-and-rivers/river-towy Afon Tywi], ewch i archwilio’r cestyll hynafol a gwyliwch yr eog yn llamu yn Rhaeadrau Cenarth.
[_id:protected] => 39
[_url_name] => south-west-wales
)
[_preposition:private] => in
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 1
[_name:protected] => Places to go
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_business_manager:private] =>
[_location_manager:private] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_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] =>
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 16
[_parent_id:protected] =>
[_template:protected] => Component/AttractionList.tpl
[_page_id:protected] => 1646
[_view_component_id:protected] => 149
[_instance_name:protected] => attractions_list
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/south-west-wales/places-to-go
[_path:private] => /in-your-area/south-west-wales/places-to-go
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/south-west-wales/places-to-go
[PHPSESSID] => 13f0efd7934fc7e62fd4cb6392350440
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 15
[page_id] => 1646
[view_name] => locations_placestogo
[title] => Places to go in % LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% for Days out and Attractions | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/placestogo.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/south-west-wales/places-to-go
[location] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 41
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 171761
[_min_northing:private] => 223382
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 261570
[_centre_northing:private] => 224630
[_name:protected] => South west Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/south-west-wales
[_standfirst:protected] => Fairy tale fortresses perch high on cliffs, fallow deer flit through ancient woodlands, all the romance of Wales is here.
[_description:protected] => The south-west of Wales is an untamed expanse of heather-clad moorland, rugged Cambrian mountains and fast-flowing rivers. Carmarthen has long been recognised as the land of Arthurian legend – but this pastoral beauty expands well beyond the county boundary. Spot the fishermen out in traditional coracles on the [/canals-and-rivers/river-towy River Towy], clamber through ruined castles and watch the salmon leap at Cenarth Falls.
[/media/images/21442.jpg Welsh Language Board]
++ Y De-orllewin
**Caerau tylwyth teg ar glogwyni uchel, ewig lwyd yn gwibio drwy goedwigoedd hynafol – mae holl ramant Cymru yma.**
Ledled y de-orllewin, fe welwch ehangder gwyllt rostiroedd grugog, mynyddoedd garw Cambria ac afonydd cyflym. Mae Caerfyrddin yn enwog am ei chysylltiad â’r chwedlau Arthuraidd, ond mae ei harddwch gwledig yn ymestyn ymhell y tu hwnt i ffiniau’r sir. Gwyliwch y pysgotwyr yn eu cwryglau traddodiadol ar yr [/canals-and-rivers/river-towy Afon Tywi], ewch i archwilio’r cestyll hynafol a gwyliwch yr eog yn llamu yn Rhaeadrau Cenarth.
[_id:protected] => 39
[_url_name] => south-west-wales
)
[preposition] => in
[section] => places-to-go
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 41
[_os_country_code:private] => 220
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 171761
[_min_northing:private] => 223382
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 261570
[_centre_northing:private] => 224630
[_name:protected] => South west Wales
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/south-west-wales
[_standfirst:protected] => Fairy tale fortresses perch high on cliffs, fallow deer flit through ancient woodlands, all the romance of Wales is here.
[_description:protected] => The south-west of Wales is an untamed expanse of heather-clad moorland, rugged Cambrian mountains and fast-flowing rivers. Carmarthen has long been recognised as the land of Arthurian legend – but this pastoral beauty expands well beyond the county boundary. Spot the fishermen out in traditional coracles on the [/canals-and-rivers/river-towy River Towy], clamber through ruined castles and watch the salmon leap at Cenarth Falls.
[/media/images/21442.jpg Welsh Language Board]
++ Y De-orllewin
**Caerau tylwyth teg ar glogwyni uchel, ewig lwyd yn gwibio drwy goedwigoedd hynafol – mae holl ramant Cymru yma.**
Ledled y de-orllewin, fe welwch ehangder gwyllt rostiroedd grugog, mynyddoedd garw Cambria ac afonydd cyflym. Mae Caerfyrddin yn enwog am ei chysylltiad â’r chwedlau Arthuraidd, ond mae ei harddwch gwledig yn ymestyn ymhell y tu hwnt i ffiniau’r sir. Gwyliwch y pysgotwyr yn eu cwryglau traddodiadol ar yr [/canals-and-rivers/river-towy Afon Tywi], ewch i archwilio’r cestyll hynafol a gwyliwch yr eog yn llamu yn Rhaeadrau Cenarth.
[_id:protected] => 39
[_url_name] => south-west-wales
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component 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_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[64] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[65] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[66] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[67] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[68] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[69] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[70] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => Array
(
[sql] => SELECT count(*) AS row_count FROM attraction i INNER JOIN address ad ON i.address = ad.address_id LEFT JOIN town t ON ad.town = t.town_id INNER JOIN county c ON ad.county = c.county_id LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND a.county = 39 ORDER BY i.classification DESC, i.name ASC
)
)
[queryCounter] => 75
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array